Posted: March 12th, 2023
Analysis and design techniques
System
A
nalysis
Assignment III
1. 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)
2. Draw the ERD for DePaul and class registration. List the tables, attributes, and relationships.
3. 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 |
2023 |
Mares |
Basketball |
Rebels |
2nd |
Green |
Elm |
A | |||||||
|
222-5644 |
Sue Rose |
456 Madison Chicago IL |
Madison |
A- |
|||||||||||
|
666-7373 |
Dennis Olufsen |
234 Quincy Los Angeles |
Simek |
Baseball |
Chargers |
3rd |
Blue |
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.