Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

How easy the information is to remember

Answered: 1 week ago

Question

design a simple performance appraisal system

Answered: 1 week ago