PART II - Normalizing to 3 NF For each question, identify the current normal form \{UNF, 1NF, 2NF, 3NF\}, generate a few business rules \{functional dependencies\}. Then normalize the tables into 3NF. - You may create key attributes [primary keys or foreign keys] if needed. - You may either draw the tables (using Word table option) or use standard written form. Standard Written Form: TABLENAME(primaryKey, attribute, attribute, ..., foreiankeygttribyte) TABLENAMES are in all caps - primaryKeys are underlined foreigakeys are italicized not all tables have foreign keys BUT all tables have primary keys 1. A database is needed to track procedures performed by surgeons. What form is this table in? Identify at least 3 business rules (functional dependencies). I have done provided the first one as an example. 1. Surgeons are identified by a unique numeric PIN 2. - 3. - Normalize to 3NF. 2. Movie Rental Scenario. A database is needed to track customer movie rentals. The following data is rnllected: What form is this table in? Identify at least 3 business rules (functional dependencies). 1. - 2. - 3. - Normalize to 3NF. 4. A Veterinary Office needs a database to track the services provided. What form is this table in? Identify at least 3 business rules (functional dependencies). 1. - 2. - 3. - Normalize to 3NF