ITFN 1201 Foundations of Database Design Assignment 1: Type your answers (not bold) to questions 1, 2, and 3 on this page. Create a Power Architect diagram. See instructions below. Consider this table C 1 PetName- PetType 2 King 3 Teddy 4 Fido Dog 5 AJ Dog 6 Cedro Cat 7 Woolley Cat 8 Buster Dog P etBreed Std. Poodle Cashmier Std. Poodle Collie Mix Unknown Unknown Border Collie PetDOB O wnerLastName 27-Feb-10 Downs 1-Feb-09 James 17-Jul-11 Downs 5-May-11 Frier 6 Jun-08 James 777 James 11-Dec-07 Trent OwnerFirstName Marsha Richard Marsha Liz Richard Richard Miles OwnerPhone 201-823-5467 201-735-9812 201-823-5467 201-823-6578 201-735-9812 201-735-9812 201-634-7865 OwnerEmail Marsha Downs@somewhere.com Richard James@somewhere.com Marsha.Downs@somewhere.com Liz Frer@somewhere.com Richard James@somewhere.com Richard James@somewhere.com Miles. Trent@somewhere.com 1. Assume that the data in the table is a true representation of the functional dependencies. List the functional dependencies. 2. There are two themes represented by the data in the table. What are they? 3. For each theme, identify any attribute that could serve as a candidate key. If there is no suitable candidate key for a given theme, create a surrogate key. Use Power Architect to create a table for each theme you identified. Experiment drawing relationship lines from one table to another. Decide on a solution that you feel best represents the relationship. Use Power Architect's File menu to export the playpen to a pdf file. Make Sure You Have Both "A" And "B": A) This page with answers typed in for questions 1, 2, and 3. B) A pdf of the diagram you created with Power Architect and the file of Power Architect ITFN 1201 Foundations of Database Design Assignment 1: Type your answers (not bold) to questions 1, 2, and 3 on this page. Create a Power Architect diagram. See instructions below. Consider this table C 1 PetName- PetType 2 King 3 Teddy 4 Fido Dog 5 AJ Dog 6 Cedro Cat 7 Woolley Cat 8 Buster Dog P etBreed Std. Poodle Cashmier Std. Poodle Collie Mix Unknown Unknown Border Collie PetDOB O wnerLastName 27-Feb-10 Downs 1-Feb-09 James 17-Jul-11 Downs 5-May-11 Frier 6 Jun-08 James 777 James 11-Dec-07 Trent OwnerFirstName Marsha Richard Marsha Liz Richard Richard Miles OwnerPhone 201-823-5467 201-735-9812 201-823-5467 201-823-6578 201-735-9812 201-735-9812 201-634-7865 OwnerEmail Marsha Downs@somewhere.com Richard James@somewhere.com Marsha.Downs@somewhere.com Liz Frer@somewhere.com Richard James@somewhere.com Richard James@somewhere.com Miles. Trent@somewhere.com 1. Assume that the data in the table is a true representation of the functional dependencies. List the functional dependencies. 2. There are two themes represented by the data in the table. What are they? 3. For each theme, identify any attribute that could serve as a candidate key. If there is no suitable candidate key for a given theme, create a surrogate key. Use Power Architect to create a table for each theme you identified. Experiment drawing relationship lines from one table to another. Decide on a solution that you feel best represents the relationship. Use Power Architect's File menu to export the playpen to a pdf file. Make Sure You Have Both "A" And "B": A) This page with answers typed in for questions 1, 2, and 3. B) A pdf of the diagram you created with Power Architect and the file of Power Architect
