Question colection of database part iii

Brief Answer Questions: [1.5x10=15]

1. List out the three major disadvantages of File Processing System.
2. Define strong entity and weak entity.
3. What do you mean by Integrity Constraints?
4. Describe one-to-many relationship with suitable example.
5. Give syntax for ‘group by’ and ‘order by’ clause.
6. What is specialization and generalization?
7. Differentiate between Cartesian product operation and Natural join operation in relation algebra.
8. Define the difference between HAVING and WHERE clause with example.
9. Define Domain with example.
10. Give different symbols of ER Diagram with name.

Short Answer Questions: [5x3=15]

11. Explain Data Model in DBMS.
12. Explain the major advantages of DBMS over file processing system.
13. Draw an ER Diagram for Library Management System with at least four entity sets and assume required attributes.

Question collection of database part 2

1. Match the following terms and definitions:

……… Data ………..Repository ……….Metadata

……… Database Application ..……… Data Warehouse ……….Constraint

………. Database …………Information … ……User view

……….. Data independence

1. data placed in a context or summarized
2. application program(s)
3. facts, text, graphics, images, etc
4. integrated decision support database
5. organized collection of related data
6. includes data definitions and constraints
7. centralized storehouse for all data definitions
8. separation of data descriptions from programs
9. a rule that cannot be violated
10. logical description of portion of database

2. List any four significant differences between a file-processing system and a DBMS.

3. What are five main functions of a DBA.

4. Define Data Model with its types.

5. Explain the difference between physical and logical data independence.

Question collection of database part 2

1. Match the following terms and definitions:

……… Data ………..Repository ……….Metadata

……… Database Application ..……… Data Warehouse ……….Constraint

………. Database …………Information … ……User view

……….. Data independence

1. data placed in a context or summarized
2. application program(s)
3. facts, text, graphics, images, etc
4. integrated decision support database
5. organized collection of related data
6. includes data definitions and constraints
7. centralized storehouse for all data definitions
8. separation of data descriptions from programs
9. a rule that cannot be violated
10. logical description of portion of database

2. List any four significant differences between a file-processing system and a DBMS.

3. What are five main functions of a DBA.

4. Define Data Model with its types.

5. Explain the difference between physical and logical data independence.

Question collection of database part 1

1. Is there any difference between Database and Database Management System? Explain.
2. Explain Network Model and Hierarchical Model with diagram.
3. Design a ER Diagram for Hospital Management System.
4. Write short notes on (Any TWO)
1. Primary Key
2. Mapping Constraints
3. Instances and Schema
5. Write down SQL statements for following (Any THREE)
1. Display all employee whose name is starting from letter ‘R’ and ending with letter ‘H’.
2. Display all employees no, name, annual salary of department 20.
3. Display all employees whose salary is greater than their commission.
4. Display all employees working under department no 10,20,30.

6. Who is Database Administrator (DBA)? Explain their task and dutie

funny gif animation

funny gif animation

funny videos from daily motion

Talking Heads - Funny Animation
Uploaded by aniboom. - Sitcom, sketch, and standup comedy videos.

funny videos from daily motion

Red Hot Chili Peppers - Dani California

Red Hot Chili Peppers - Dani California