CSIS 325
ProjectID -> Supervisor, Project Manager , Client
DateID -> EmpID, Date, Hours Worked
Question #4:
Describe any insertion anomalies that can occur in your 1NF table. In 1NF, the table is identified based on the primary key. We cannot add additional new data from other tables because we don’t have the primary key
Question #5:
Describe any deletion anomalies that can occur in your 1NF table. Duplicate date is present, therefore, deleting any entry will delete all rows having that entry.
Question #6:
Describe any modification anomalies that can occur in your 1NF table. Duplicate date is present, therefore, updating any entry will update all rows having that entry.
Question #7:
Based on your 1NF table, in the space below, re-write the table so that it is in second normal form. You may add ID fields to any new tables you create and use those IDs as foreign keys in other tables as appropriate. (10 points)
Page 2 of 5
