Problem
1. Explain the distinction between total and partial constraints.
2. Figure 2.31 shows a lattice structure of generalization and specialization. For entity sets A, B, and C, explain how attributes are inherited from the higher level entity sets X and Y. Discuss how to handle a case where an attribute of X has the same name as some attribute of Y.