Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ITM 315 Fall 2018 Homework 3 Ch 5 and Ch 6 part 1 Due Saturday, October 20, 5pm. Please submit the assignment via blackboard by
ITM 315 Fall 2018 Homework 3 Ch 5 and Ch 6 part 1 Due Saturday, October 20, 5pm. Please submit the assignment via blackboard by the above due date/time. Insert the Schema and ERD in the areas indicated. Please name your 21 Points possible file homework 3 lastname 1. Convert the ERD below to a relational schema EMPLOYEE EmpD EmaName EmaRhone trainer manager CENTER VOLUNTEER YolUe Vol Name DONATION Genter DONOR DengrName Insert your schema here: 2. Create the ERD for the following scenario: Joe wants to create a database to store information about the teams, players, games and courts of his youth basketball league: .Each team has several players; a player can only play for one team. .Each team has a captain. A player can only be the captain of one team. Team name, year founded and .For each player, the Player ID, player name, player age, and player position are tracked. Each team has a Team ID, a mascot. Players are ranked. A relationship will be used to determine the order in which the players are ranked. .Each game has a Game ID and date that is tracked. .Each court has a Court ID, Court name and seating capacity Each game is played on a single court; but many games are played on the same court. .Each team plays in at least one game. A single game has more than one team that plays in it. .For each team in each game, he wants to record the team's points in the game. Insert your ERD here
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