Purchase Solution

Database Analysis: Data Modeling and E-R Diagrams

Not what you're looking for?

Ask Custom Question

After completing a course in database management, you have been asked to develop a preliminary ERD for a symphony orchestra. You discover the following entity types that should be included:
- CONCERT SEASON The season during which a series of concerts will be performed. Identifier is Opening_Date, which includes Month, Day, and Year.
- CONCERT A given performance of one or more compositions. Identifier is of the following: Month, Day, Year, and Time. Each concert typically has more than one concert date.
- COMPOSITION Compositions to be preformed at each concert. Identifier is Composition_ID, which consists of the following: COMPOSER_Name and Composition_Name. Another attribute is Movement_ID, which consist of two parts: Movement_Number and Movement_Name. Many, but not all, compositions have multiple movements
- CONDUCTOR Person who will conduct the concert. Identifier is Conductor_ID. Another attribute in Conductor_Name.
- SOLOIST Solo artist who performs a given compostion on a particular concert. Identifier is Soloist_ID. Another attribute is Soloist_Name.
During further discussion you discover the following:
- A concert season schedules one or more concerts. The particular concert is scheduled for only one season.
- A concert includes the performance of one or more compositions. A composition may be performed at one or more concerts or may not be performed.
- For each concert there is one conductor. A conductor may conduct any number of concerts or may not conduct any concerts.
- Each composition may require one or more soloists or may not require a soloist. A soloist may perform one or more compositions at a given concert or may not perform any composition. The symphony orchestra wishes to record the date when a soloist last performed a given composition (Date_Last_Performed).
Draw a ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E-R diagram. Also draw a data model for this situation using the Visio.

Purchase this Solution

Solution Summary

Data modeling and E-R diagrams for database analysis is examined.

Purchase this Solution

Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.