Question: help me with this assignment of Database Mod 04 Binary Many to Many Relationships Draw the entities and relationships suggested by each word problem. Include
help me with this assignment of Database Mod 04 Binary Many to Many Relationships
Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s). Remember to make a copy for yourself.
- A course may have many sections or not be offered at all (no sections). Sections always belong to a single course. Students take at least one and often multiple sections during a semester. We want to capture a students grade and, if that grade is an F, last date attended. Courses have a CID, course name and department. Sections have a CRN, a room and a time. Sections have no students, or many students. Students have a CWID, name and year (like Sophomore).
- Concerts are the coming together of one or more bands at one or more locations. So a location will host one or bands and bands will play at one or more locations. When a band plays again at the same location we will just overwrite the prior data. For every concert we want to capture the ticket price and local quiet hours (if any). Bands have a unique name, a genre, and a cost. Locations have a city, state, tax rate and a venue.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
