Q1. Define the term Relational completeness. Deduce the Natural Join and Division operator in terms of fundamental relational algebra operations.
Q2. Write down the difference between:
a) Strong and weak entity set.
b) Super key, Candidate key and Primary key.
c) Condition-defined and user-defined constraints in ER diagram.
d) 3NF and BCNF.
Q3. Describe multivalued dependency and Join dependency. Explain why they are not desirable in a relation. Validate.