Many-to-Many ERD CUSTOMER has: customer_id first and last names address TAPE has: tape_id title description length in minutes A CUSTOMER may rent many TAPEs. A TAPE can be rented by many CUSTOMERs. Draw a Crow’s Foot ERD that includes the bridge table between Customer and Tape to account fully for the many-to-many relationship.
Many-to-Many ERD
- CUSTOMER has:
- customer_id
- first and last names
- address
- TAPE has:
- tape_id
- title
- description
- length in minutes
- A CUSTOMER may rent many TAPEs.
- A TAPE can be rented by many CUSTOMERs.
- Draw a Crow’s Foot ERD that includes the bridge table between Customer and Tape to account fully for the many-to-many relationship.
Course and Class ERD
Table name: COURSE
|
COURSE_ID |
TITLE |
DESCRIPTION |
CREDITS |
|
ACCT-211 |
Basic Accounting |
An introduction to accounting. Required of all business majors. |
3 |
|
CIS-380 |
|
Database design and implementation issues. Uses CASE tools to generate designs and implement in a major RDBMS. |
3 |
|
CIS-490 |
Database Systems II |
The second half of CIS-380. Basic Web database application development and management issues. |
4 |
Table name: CLASS
|
CLASS_ID |
COURSE_ID |
SECTION |
TIME |
LOCATION |
|
100 |
ACCT-211 |
1 |
8:00 a.m. – 9:30 a.m. T-Th. |
AA 325 |
|
101 |
ACCT-211 |
2 |
8:00 a.m. – 8:50 a.m. MWF |
AA 325 |
|
102 |
ACCT-211 |
3 |
8:00 a.m. – 8:50 a.m. MWF |
AA 402 |
|
201 |
CIS-380 |
1 |
11:00 a.m. – 11:50 a.m. MWF |
AA 415 |
|
202 |
CIS-380 |
2 |
3:00 p.m. – 3:50 a.m. MWF |
AA 398 |
|
301 |
CIS-490 |
1 |
1:00 p.m. – 3:00 p.m. MW |
AA 398 |
|
302 |
CIS-490 |
2 |
6:00 p.m. – 10:00 p.m. Th. |
AA 398 |
Draw an ERD to represent COURSE and CLASS and the relationship between them.
Step by step
Solved in 2 steps with 2 images
