4. A Veterinary Office needs a database to track the services provided. B C Type Breed...

 

Transcribed Image Text:

4. A Veterinary Office needs a database to track the services provided. B C Type Breed Dog Std. Poodle Cat Cashmier ma Dog Std. Poodle Dog Collie Mix Cat Unknown Cat Unknown Dog Border Collie 1 PetName 2 Kino 3 Teddy 4 Filo 5 AJ 6 Cedro A 7 Woolley 8 Buster What form is this table in? 2. 3. Normalize to 3NF. - E Owner 27-Feb-05 Marsha Downs 1-Feb-04 Richard James 17-Jul-06 Marsha Downs. 5-May-05 Liz Frier 6-Jun-01 Richard James Richard James 11-Dec-00 Miles Trent DOB ??? Identify at least 3 business rules (functional dependencies). 1. D F OwnerPhone 555-123-6788 555-444-0098 555-123-6788 555-444-5596 555-444-0098 555-444-0098 555-999-8861 OwnerEmail MD@somewhere.com RJ@somewhere.com MD@somewhere.com LF@somewhere.com RJ@somewhere.com RJ@somewhere.com MT@somewhere.com H Service Ear Infection. Nail Clip One year shots. Nail Clip Skin Infection Laceration Repair Date J Charge 65.00 27.50 17-Aug-06 $ 5-Sep-06 $ 5-May-06 $ 42.50 5-Sep-06 $ 27.50 3-Oct-06 $ 35.00 5-Oct-06 $ 127.00 4. A Veterinary Office needs a database to track the services provided. B C Type Breed Dog Std. Poodle Cat Cashmier ma Dog Std. Poodle Dog Collie Mix Cat Unknown Cat Unknown Dog Border Collie 1 PetName 2 Kino 3 Teddy 4 Filo 5 AJ 6 Cedro A 7 Woolley 8 Buster What form is this table in? 2. 3. Normalize to 3NF. - E Owner 27-Feb-05 Marsha Downs 1-Feb-04 Richard James 17-Jul-06 Marsha Downs. 5-May-05 Liz Frier 6-Jun-01 Richard James Richard James 11-Dec-00 Miles Trent DOB ??? Identify at least 3 business rules (functional dependencies). 1. D F OwnerPhone 555-123-6788 555-444-0098 555-123-6788 555-444-5596 555-444-0098 555-444-0098 555-999-8861 OwnerEmail MD@somewhere.com RJ@somewhere.com MD@somewhere.com LF@somewhere.com RJ@somewhere.com RJ@somewhere.com MT@somewhere.com H Service Ear Infection. Nail Clip One year shots. Nail Clip Skin Infection Laceration Repair Date J Charge 65.00 27.50 17-Aug-06 $ 5-Sep-06 $ 5-May-06 $ 42.50 5-Sep-06 $ 27.50 3-Oct-06 $ 35.00 5-Oct-06 $ 127.00

Answer rating: 100% (QA)

This table is in a flat table format also known as a twodimensional table Some business rules that c... View the full answer