Question

Need help with database ER diagram. Thank you

Design a database for team sport of your choice (for example hockey, soccer). Include information

about athletes and their team. Draw the ER diagram. Be sure to underline the Primary keys.

-ATHLETE includes their name, age, id,

-TEAM includes name, id, colors, city, ranking

-Each athlete PLAYS_FOR a team and what year they started

Answer 1

Dear Student ,

As per requirement submitted above kindly find below solution.

This demonstration is using SQL Server.

1.Table Name :ATHLETE

create table ATHLETE (
id int primary key,
name varchar(20),
age int)

2.Table Name :TEAM

create table TEAM (
id int primary key,
name varchar(20),
colors varchar(20),
city varchar(50),
ranking int)

3.Table Name :PLAYS_FOR

create table PLAYS_FOR (
Player_id int ,
Team_id int,
year int,
primary key(Player_Id,Team_Id,year),
foreign key (Player_id) references ATHLETE(id),
foreign key (Team_id) references team(id)
);

***************************************

ER Diagram :

NOTE :PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.