Question

Examine the determinants of the functional dependencies. If any determinant is not a candidate key, the...

Examine the determinants of the functional dependencies. If any determinant is not a candidate key, the relation is not well formed. In this case: a. Place the columns of the functional dependency in a new relation of their own. b. Make the determinant of the functional dependency the primary key of the new relation. c. Leave a copy of the determinant as a foreign key in the original relation. d. Create a referential integrity constraint between the original relation and the new relation.

The Veterinary Office List Version Two King Std. Poodle 27-Feb-12 Down 3 Teddy 1-Feb-11 James Cashmier Std. Poodle 4 Fila 17-Jul-13 Downs 5 May 13 Frier Collie Mix 6 Cedro Cat Unknown 6 Jun 10 James 7 Woolley Unknown 11-Dec-09 Trent 8 Buster Border Collie 1 Jul-06 Evans Richard Marsha Richard Richard Miles 201-823-5467 Marsha Downs@so com Ear Infection 17-Aug-14 65.00 5-Sep-14 s 27.50 201-735-9812 Richard James com Nail Clip 201-823-5467 42.50 201-823-6578 One year shots 5 May 14 S 5-Sep-14 201-735-9812 lanes Somewherecom Nail Clip 201-735-9812 Richard James@somewhere.com Skin Infection 3-Oct-14 35.00 201-634-7865 Miles, Trent@somewhere.com Laceration Repair 5-Oct-14 127.00 210-634-2345 Hilary Evans omewhere.com Booster Shots 4-Nov-14 S 111.00

The Veterinary Office List Version Two King Std. Poodle 27-Feb-12 Down 3 Teddy 1-Feb-11 James Cashmier Std. Poodle 4 Fila 17-Jul-13 Downs 5 May 13 Frier Collie Mix 6 Cedro Cat Unknown 6 Jun 10 James 7 Woolley Unknown 11-Dec-09 Trent 8 Buster Border Collie 1 Jul-06 Evans Richard Marsha Richard Richard Miles 201-823-5467 Marsha Downs@so com Ear Infection 17-Aug-14 65.00 5-Sep-14 s 27.50 201-735-9812 Richard James com Nail Clip 201-823-5467 42.50 201-823-6578 One year shots 5 May 14 S 5-Sep-14 201-735-9812 lanes Somewherecom Nail Clip 201-735-9812 Richard James@somewhere.com Skin Infection 3-Oct-14 35.00 201-634-7865 Miles, Trent@somewhere.com Laceration Repair 5-Oct-14 127.00 210-634-2345 Hilary Evans omewhere.com Booster Shots 4-Nov-14 S 111.00
0 0
Add a comment Improve this question
Answer #1

Solution: a) Placing the columas ofthe functionl dpadeayla sewrdasion OWNER (OwnerPhone, OwnerLastName, OwnerFirstName, Owner

Add a comment
Know the answer?
Add Answer to:
Examine the determinants of the functional dependencies. If any determinant is not a candidate key, the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2.1 Apply the normalization process to the Veterinary Office List–Version One relation shown in Figure 1-34...

    2.1 Apply the normalization process to the Veterinary Office List–Version One relation shown in Figure 1-34 (see page 63 and below) to develop a set of normalized relations. Show the results of each of the steps in the normalization process. 1 PetName 2 King 3 Teddy 4 Fido 5 AJ 6 Cedro 7 Woolley 8 Buster 9 Jiddah PetType Dog Cat Dog Dog Cat Cat Dog Cat C P etBreed Std. Poodle Cashmier Std. Poodle Collie Mix Unknown Unknown Border...

  • The figure below shows a list used by a veterinary office. Refer to the list and...

    The figure below shows a list used by a veterinary office. Refer to the list and answer the questions below. 1. G H OwnerEmail Marsha Dow@somewhere.com Richaed James@omewhere.com Marha Downs@somewhere.com Lic Frie@somehere.com Richard James@somewhere.com Richard James@somewhere.com Mies Trent@somewhere.com Hilay Exains@smewhere.com PerD08 27-Feb-12 Downs 1Feb-11 James 17-Jul-13 Downs 5-May-13 Frer 6Jun-10 James Ownerl astName OwnerFirstName Marsha Richard Marsha Liz Richard Richard Miles Hilary OwnerPhone 201-823-5467 201-735-9812 201-823-5467 201-823-6578 201-735-9812 201-735-9812 201-634-7065 210-634-2345 PetType PetName 2 King 3 Teddy 4 Fido 5...

  • Sample data for these tables are shown in Figures 3-26 and 3-27. For each SQL statement...

    Sample data for these tables are shown in Figures 3-26 and 3-27. For each SQL statement you write, show the results based on these data. If possible, run the statements you write for the questions that follow in an actual DBMS, as appropriate, to obtain results. Use data types that are consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types by using either the MySQL, Microsoft SQL Server, or Oracle...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT