Q1. How would the given ER constructs be mapped to the relational model?
b) Generalization or Specialization.
Q2. What do you mean by referential integrity? Illustrate the requirement for triggers and how are they implemented in the SQL? Give illustration.
Q3. What do you mean by cardinality ratios? Illustrate the possible cardinality ratios for a binary relationship? Describe with illustrations.
Q4. What do you mean by the primary goal of normalization? Illustrate how the concepts of functional dependency and multi valued dependency related with the normalization? Give an illustration for the same.