Problem 1 1. Discuss insertion, deletion, and modification anomalies. Why are they considered bad? 2. Consider figure 1. Show scenarios where insertion, deletion, and modification anomalies may be present in the relation. EMP_DEPT Ename San Bdate Address Dnumber Dname Dmgr_san Figure 1: Emp_Dept relation Problem 2 1. What is a functional dependency? What are the possible sources of the information that defines the functional dependencies that hold among the attributes of a relation schema? 2. Define first, second, third and Boyce-Codd normal forms. How does Boyce-Codd normal form differ from 3NF? Why is it considered a stronger form of 3NF? 3. What undesirable dependencies are avoided when a relation is in 2NF? is in 3NF? Problem 3 Consider the table below with the set of functional dependencies FDs: Property_id# - County_name, Lot#, Area, Price, Tax_rate {County_name, Lot#} - Area, Price, Tax_rate, Property_id# County_name - Tax_rate Area - Price Candidate Key LOTS Property id# County_name Lot# Area Price Tax_rate FD1 FD2 FD3 FD4 Figure3: FDs for LOTS relation