Question
Draw the ER or UML diagram for the above. Mark the primary [PK] and foreign key columns [FK] Consider the following information given to you
Draw the ER or UML diagram for the above. Mark the primary [PK] and foreign key columns [FK] Consider the following information given to you to build a database system that keeps records of Quidditch teams and their coaches:
Each team has a name, a school it represents, year founded, a coach, and a set of seven players. Coaches have first names and last names, experience (years) and an id. Coaches of teams can change over time. A coach can stop coaching altogether or start coaching another team. Each player belongs to only one team. Each player has a number, a name, date of birth and position in the game. Player positions are seeker, keeper, chaser and beater.
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