PART II - Normalizing to 3NF For each question, identify the current normal formUNF, INF, 2NF, 3NF, generate a few business rules functional dependencies). Then normalize the tables into 3NF. .You may create key attributes Iprimary keys or foreign keysl if needed. or use standard written form Standard Written Form .You may either draw the tables (using Word table option) TABLENAME(primaryKey, attribute, attribute,..., foreignkeyattribute) o TABLENAMES are in all caps primaryKeys are underlined o foreignKeys are italicized o not all tables have foreign keys BUT all tables have primary keys . A database is needed to track procedures performed by surgeons Surgeons Procedure Surgeons Procedure Surgery Pin ID Name Name Date What form is this table in? Identify at least 3 business rules (functional dependencies). I have done provided the first one as an example. . 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 collected Full Names Moviesr Salutation Category Address First Street Plot No 4 lanet lones Pirates of the Ms. Action, Action Clash of the Titans Forgetting Sarah Mr Marshal, Daddy's Little Girls Clash of the Titans Mr Robert Phil Street 34 Romance Robert Phil Avenue Action What form is this table in? Identify at least 3 business rules (functional dependencies). 2. Normalize to 3NF. 4. A Veterinary Office needs a database to track the services provided PetName Breed Sid. Poodle DOB OwnerPhone 555-123-6788 Owner OwnerEmail Date Charge ype Dog Cat Dog Dog Cat 27-Feb-05 Marsha Downs Ear Infection Nail Clip 17-Aug-06 65.00 5-Sep0627.50 Teddy 4 Filo 5 A 6 Cedro Sid Poodle Collie Mix Unknown Unknown Border Collie 1-Feb-04 Richard James 7-Jul-06 Marsha Downs 5-May-05 Liz Frier 6-Jun-01 Richard James 555-123-6788 555-444-5596 |woolley Buster One year shots 5-May-06$ 42.50 5-Sep-06 27.50 3-Oct-06 35.00 127 00 Nail Clip Skin Infection Laceration Repair Richard James Dog 1-Dec-00 Mles Trent 5-Oct-06 What form is this table in? Identify at least 3 business rules (functional dependencies) Normalize to 3NF. PART III - Using the form below and a sample un- normalized table containing all related attributes and sample data, develop a set of database tables that are normalized to 3NF. Then create a corresponding ER diagram (the ER diagram needs to show cardinality/optionality) ease DreamHome Lease DreamHome Lease Property Number PG Client Number cR76 Enter if known) Full Name Jhn Please print Property Address 6 Lawrence St, Glasgow Owner Number CO0 Enter if known) Monthly Rent 350 Rent Start 01/07I0 Rent Finish 3108104 Full Name Tia M (Please print) clientNo cName propertyNo pAddress rentStart rentFinish rent ownerNo oName CR76 ohn PG4 Kay Lawrence St.-l-03 31-Ang 04 300Tina Murp Glasgow Glasgow Lawrence St 1-S-02 10-me-335 P6r Dr, 1Sp04 1 C9 Tony Shaw Tna Marpl CR56Aline PG4 Stewart Glasgow Manor Rd, 10-01-03 1-Dec-04 375 C9Tony Shaw PG36 Glasgow ll-Nov-05| 10-Aug06|450|C093 |Tony Shaw PG16 5Novar Dr, Glasgow