Question Bank
Module-1
1. Describe the characteristics of database approach.
2. Define the following terms
a. Data model
b. Scheme
c. Canned Transaction
d. DML
e. Meta Data
f. Attribute
3. Write an E.R diagram to represent car entity type with two key attributes
Reg. No & Vehicle Id.
4. Discuss the advantages & disadvantages of using the using the DBMS
approach.
5. Explain the component modules of dbms & their interaction with help of
diagram.
6. Explain three schema architecture with neat diagram and Data
Independence.
7. Define the following terms
a. Weak entity
b. DBMS catalog
c. Snapshot
d. Value sets
e. Cardinality ratio
f. Degree of Relationship
8. Explain the categories of data models.
9. Explain different types of user interfaces and types of users who typically use each
10. Explain different types of attributes that occurs in E-R diagram model with example.
11. Develop an ER diagram for keeping track of information about
companydatabase constraints as follows:
a. An Employee works for department
b. Every department is headed by an manager
c. An employee works for one or more projects
d. An Employee has dependents
e. A Department controls projects.
12. Explain types of end users with suitable examples
13. Explain two-tier and three-tier client-server architecture?
14. List and explain the criteria for classification of DBMS.
Module-2
1. List and explain characteristics of Relations.
2. Define the following
i. Primary key
ii. Super key
iii. Foreign key
iv. Candidate key
3. Explain the different relational model constraints.
4. With suitable example, explain schema based constraints.
5. With general form, explain unary relational operation with example.
6. Explain what are the different update operations can be performed
on relational database, explain different types of constraints may
be violated by each update operation.
7. Explain operation on set theory with suitable example.
i. Union
ii. Intersection
iii. Set difference or Minus
iv. Cartesian product
8. Write a note on following
i. Equijoin
ii. Natural join
iii. Theta join
iv. Division
9. Explain aggregate functions and grouping with suitable examples.
10. Explain E-R to Relational mapping with Company Database.
