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.

View More Free Quizzes
Related BrainMass Solutions

  • Data modeling tools

    How can data modeling tools such as an E-R diagram help identify inconsistencies early on in the data modeling process? How can the data modeling process encourage accountants and other users to get more involved in database design?

  • The Process of Conceptual Data Modeling

    514381 The Process of Conceptual Data Modeling Conceptual Modeling looks at how the data is structured and what the characteristics of the data are. What characteristics of data are represented in an E-R diagram?

  • Data Modeling Tools in Microsoft Access Database

    166856 Data Modeling Tools in Microsoft Access Database Please give examples of the data modeling tools in Microsoft Access database and how they help in designing Access databases.

  • Database Concepts

    However, modeling of the physical data model must express a detailed description of the database. This is done using Rational's Data Modeling Profile for the UML.

  • This post addresses denormalization and binary relationships

    Illustrate using IE Crow's Foot E-R diagrams.

  • UML diagrams

    50008 Which UML diagrams are useful for analysis modeling? Which UML diagrams are useful for analysis modeling? Provide an example of each. Some UML tools analyze existing source code and reverse-engineer it into a set of UML diagrams.

  • Accounting Information Systems: Placement of Primary Keys

    These two relational database concepts E-R diagrams and normalization facilitate to a large extent the placement of primary keys in relational tables in order to link multiple tables together. References Rob, P., & Coronel, C. (2004).

  • Database Design

    " - Business analysis and top-down database design are often neglected, or shortcuts are taken, especially when the developer is eager to "get his hands dirty" and start building a system with row data directly.

  • Context Diagram vs. Case Diagram

    Case Diagram Compare and contrast a context diagram (using data flow diagram (DFD) modeling) and a use case diagram (using unified modeling language (UML))?

View More Related Solutions