ART II - Normalizing to 3NF or each question, identify the current normal form \{UNF, 1NF, 2NF, 3NF\}, generate a few usiness 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, ..., foreignkeyattribute) TABLENAMES are in all caps primaryKeys are underlined foreignKeys are italicized not all tables have foreign keys BUT all tables have primary keys 4. A Veterinary Office needs a database to track the services provided. What form is this table in? 2NF Identify at least 3 business rules (functional dependencies). 1. - 2. 3. - Normalize to 3NF. ART II - Normalizing to 3NF or each question, identify the current normal form \{UNF, 1NF, 2NF, 3NF\}, generate a few usiness 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, ..., foreignkeyattribute) TABLENAMES are in all caps primaryKeys are underlined foreignKeys are italicized not all tables have foreign keys BUT all tables have primary keys 4. A Veterinary Office needs a database to track the services provided. What form is this table in? 2NF Identify at least 3 business rules (functional dependencies). 1. - 2. 3. - Normalize to 3NF