Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Robb,Carlos Coronel

5th Edition

061906269X, 9780619062699

More Books

Students also viewed these Databases questions