Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ISM 310 Homework #3 Many-to-Many Relationships Name (print clearly): Link each pair of tables in a many-to-many relationship by adding a linking table between the
ISM 310 Homework #3 Many-to-Many Relationships Name (print clearly): Link each pair of tables in a many-to-many relationship by adding a linking table between the two existing tables. Add 4 records of data to the linking table. Draw relationship lines and appropriate crows foot notation. Don't forget to complete the back also. Points will be lost for: Missing or incorrect table identifiers, missing or incorrect attribute identifiers, missing or incorrect specification of primary/foreign keys, incorrect relationship directions, failure to adhere to naming conventions, or missing attributes. StudentID (PK) 00321924 00321925 00321926 LastName Hrbek Puckett Harper Student DateOfBirth 6/27/1994 11/3/1995 1/11/1995 ClubID (PK) 00045 00046 00047 00048 Club ClubName ISA Club Chess Club Jazz Band Ultimate Frisbee Club Vehicle VIN (PK) Vw0001 WW0002 WW0003 VS0001 Make vw ww vw Vespa Model Golf Jetta Jetta GTS 250 Driver Drivers License (PK) AZ0001 AZ0002 CA0001 CA0002 CA0003 LastName Holmes Watson Moriarty Lestrade Hudson ISM 310 Homework #3 Many-to-Many Relationships Name (print clearly): Link each pair of tables in a many-to-many relationship by adding a linking table between the two existing tables. Add 4 records of data to the linking table. Draw relationship lines and appropriate crows foot notation. Don't forget to complete the back also. Points will be lost for: Missing or incorrect table identifiers, missing or incorrect attribute identifiers, missing or incorrect specification of primary/foreign keys, incorrect relationship directions, failure to adhere to naming conventions, or missing attributes. StudentID (PK) 00321924 00321925 00321926 LastName Hrbek Puckett Harper Student DateOfBirth 6/27/1994 11/3/1995 1/11/1995 ClubID (PK) 00045 00046 00047 00048 Club ClubName ISA Club Chess Club Jazz Band Ultimate Frisbee Club Vehicle VIN (PK) Vw0001 WW0002 WW0003 VS0001 Make vw ww vw Vespa Model Golf Jetta Jetta GTS 250 Driver Drivers License (PK) AZ0001 AZ0002 CA0001 CA0002 CA0003 LastName Holmes Watson Moriarty Lestrade Hudson
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