Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do this in hand/ hand drawn please. Multiple Entities ERD Optional HW You have been asked to prepare a preliminary E-R diagram for the
please do this in hand/ hand drawn please.
Multiple Entities ERD Optional HW You have been asked to prepare a preliminary E-R diagram for the local symphony orchestra. Include all keys and one additional attribute for every entity (sometimes this is provided for you, sometimes not). The following describes user requirements A concert is scheduled in one concert season. Track opening date for each season. There are several concerts scheduled for each season, usually 4-5. A concert is scheduled for one day, for a particular season, and includes the performance of several compositions (a composition is a song or symphony). For each concert, there is one conductor only (track the conductor's name and experience). A composition may be performed in many concerts. Each composition may have more than one solo, which is where a single instrument plays alone for a period of time. A solo belongs to one composition and would not exist except in relationship to its composition. For each solo, track the instrument that is playedStep 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