1) Explain Each of the following Terms:
a) Relational Data Model
b) Attribute Domain
c) Super Key
d) Candidate Key
e) Entity Integrity Rule
f) Normalization
g) BCNF
h) Relational Algebra
i) Natural Join
j) Theta Join
2) Explain the Circumstances when you would use each of the following relational Algebra Operations:
a) Select
b) Project
c) Join
d) Assignment
e) Substraction
f) Divide
3) What is a multivalued dependency? What type of constraint does it specify?
4) Write down the difference between tuple relational calculus and domain relational calculus?
5) Why normalization required? Write down its disadvantages?
6) Explain the different normal form in normalization with appropriate examples.
7) Define term anomalies. Describe BCNF in detail.
8) Explain the three-level architecture of DBMS? Also explain its importance in a database environment.
9) What do you understand by mapping cardinalities? Describe different type of cardinalities.
10) What do you mean by transitive dependency? Describe the domain key normal form (DKNF)?