1) describe 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) describe 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) prepare down the difference between tuple relational calculus and domain relational calculus?
5) Why normalization required? prepare down its disadvantages?
6) describe the different normal form in normalization with appropriate exs.
7) Define term anomalies. Describe BCNF in detail.
8) describe the three-level architecture of DBMS? Also describe 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)?