Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed

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 played

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management System MCQs Multiple Choice Questions And Answers

Authors: Arshad Iqbal

1st Edition

1073328554, 978-1073328550

Students also viewed these Databases questions

Question

Evaluating Group Performance?

Answered: 1 week ago