Coach’s Department Team

Draw the ERD for the following set of tables.
Member (member id, name, address, city, team ID)
Team (team ID, team name, team division, team color, team grade)
Division ( Division ID, division grade, division town)
Town ( Town ID, town zip, town name)

Members belongs to teams. Teams are in divisions and only one town per division)

Draw the ERD for DePaul and class registration. List the tables, attributes, and relationships.
Create the tables . group by main groupings and normalize the table. If an intersecting table is required please include that. Also please include primary and foreign keys.

Member Number Member Name Member Address Year Coach Coach’s Department Team
Name Grade Team
Color School Ratings
333-2433 Steve Keane 123 Main St.
Chicago IL 2022 Schloss Soccer Bobcat 1st Red Madison A+
333-2423 Steve Keane 123 Main St.
Chicago IL 2023 Mares Basketball Rebels 2nd Green Elm A
222-5644 Sue Rose 456 Madison
Chicago IL 2023 Mares Basketball Rebels 1st Green Madison
A-
666-7373 Dennis Olufsen 234 Quincy
Los Angeles 2022 Simek Baseball Chargers 3rd Blue Elm A

Sample solution

Member Table
Primary Key: Member Number
Attributes: Member Name, Member Address, Year, Coach, Coach’s Department

Team Table
Primary Key: Team Name
Attributes: Grade, Team Color School Ratings
Foreign Key: Member Number (References to the Member Table)

Coach Table
Primary Key: Coach
Attributes: Department

Division Table
Primary Key : Grade
Foreign Key : Team Name (References to the Team Table)

Towns Table Primary key : Town Name Attributes : Zip Code

This question has been answered.

Get Answer