Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(TCO 2) Here is a database that keeps records of baseball coaches, the teams they have worked for, baseball players and the teams that have
(TCO 2) Here is a database that keeps records of baseball coaches, the teams they have worked for, baseball players and the teams that have played on. Coaches may have worked for several teams over the years. The same can be said about the players You are to finish this ERD by answering the follow questions. 1. What is the primary key for each table? List each table and its primary key 2. What are the foreign keys for the tables? List each table and its foreign keys if any 3. Explain the Parent/Child relationship lines for each relationship. Just explain from the Parent's point of view. Be sure to explain which table gets the crowsfeet in each relationship if there is crowsfeet Also, be sure to identify any many to many relationships if there are any. Coach Player Coachl PlayeriD PlayerName Age PlayerPhone Team TeamiD CoachExperience TeamN ame CoachlD TeamPhone TeamiD TeamCity YearsExperience TeamPlayerAffiliation PlayerlD TeamiD Years
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started