Question

Task:

The understanding of database analysis and design are necessary to develop a database management system. Choose a real-world example to illustrate the effectiveness of database systems in the business world?

In order to do that, you are asked to design and implement a database system for any business of your choice. By developing this database system, you should be able to achieve better business processes and operations with goal to enhance how the average person views and interacts with their data.

The development of the application will require students to use ER modeling techniques, relational modeling techniques. You are required to develop a database that can be used to provide the frontend and the backend support intended for a business of your choice.

Your database application should include the following parts for the suggested business:

1. Description of requirements of the database with the description of attributes and constraints.
2. Conceptual Model:
   ER Diagram for the database. Show all constraints & state all assumptions which are listed in the requirements. Your ER diagram may be hand-drawn, but it must be clear and readable.

Answer 1

I am taking an example of a Concert Hosting company which hosts several concerts in a concert season.

Now CONCERT SEASON entity has opening date as primary key and it is an example of composite attribute which consists of Month,Day and Year.

CONCERT SEASON has 1 to N cardinality ratio and total participation with CONCERT entity as One concert season can have multiple concert performance.

CONCERT entity has Concert_number as it's primary key and has Concer_Date non prime attribute which is multi valued and composite attribute consists of Month,Day,Year and Time.**

CONCERT performs COMPOSITION nad has total participation and M to N cardinality ratio as one composition can be performed in several concerts and vice versa.

COMPOSITION has Composition_ID as it's primary key which is a composite attribute and consists of Composer_Name and Composition_Name.It also has Movement_ID non prime attribute which is composite attribute and made of Movement_Number and Movement_Name.

One SOLOIST can perform numerous composition and one composition can have numerous soloist , thus they have M to N cardinality ratio and total participation.

SOLOIST has Soloist_ID as the primary key and Soloist_Name,Date_Last_Performed as the other non prime attributes.

CONCERT can have atmost one CONDUCTOR and may have no CONDUCTOR too,CONDUCTOR entity has Conductor_ID as primary key and Conductor_Name as non prime attribute.

**NOTE If one attribute is multivalued and composite altogether we can make a separate table for that.