Store information about musicians who perform on its albums

Assignment Help Database Management System

Reference no: EM13749075

Please read the high-level requirements for each problem carefully. Develop a Design Document for each problem containing at minimum the following:

• Conceptual/Logical design represented by an ERD using one of the modeling notations in Appendix A of the textbook, preferably Visio Professional 2010. All many-to-many relationships must be eliminated. Must show all entities, attributes, types, constraints (PK, not null), relationships (PK/FK), relationship names, and cardinalities.

• List of all assumptions you have made during the analysis and design process.

• Physical design of the database from the ERD preferably using DDLs within either Microsoft SQL Server or Oracle environment.

• List of potential applications, reports, and queries that will use the database.

• List of potential solutions for Hardware, O/S, Software and Networking.

PROBLEM #1: SmallWorld Sports League

REQUIREMENTS: A database needs to be designed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team and the result of the game. You must choose one sport (soccer, football, baseball, etc.).

PROBLEM #2: YoTown Records

REQUIREMENTS: YoTown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database.

• Each musician that records at YoTown has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.

• Each instrument that is used in songs recorded at YoTown has a name (i.e., guitar, synthesizer, flute) and a musical key (i.e., C, B-flat, E-flat).

• Each album that is recorded on the YoTown label has a title, a copyright date, a format (i.e., CD, MC), and an album identifier.

• Each song recorded at YoTown has a title and an author.

• Each musician may play several instruments, and a given instrument may be played by several musicians.

• Each album has a number of songs on it, but no song may appear on more than one album.

• Each song is performed by one or more musicians, and a musician may perform a number of songs.

• Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course.

Reference no: EM13749075

Questions Cloud

Who justified american separation from britain : Jefferson justified American separation from Britain in the Declaration of Independence based on the majority of Americans who voted for it.

The company after completion of the bpm project : Identify ways in which mentors and mentees can use "shadowing" as a method for tracking and assessing the ongoing changes within the company after completion of the BPM project.

Compare and contrast early social systems of egypt and aksum : Compare and contrast early social systems of Egypt, Aksum, and the inland Niger Delta. Offer ideas on the possible transmission/transference of culture among these civilizations.

Construct the normal form of game : Construct the normal form of game assuming consumers move simultaneously and choose between two strategies: "Adopt" or "Don't Adopt." Solve for any (pure strategy) Nash equilibria.

Store information about musicians who perform on its albums : REQUIREMENTS: YoTown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database

Operations and supply chain management : Operations and Supply Chain Management. Service versus Manufacturing Process Design: Factors need to be considered before opening a business.

Discuss the notion of the pope and what apostalic succession : I want you to Discuss the notion of the pope and what apostalic succession. Further, explain the role of Paul and Constantine in spreading Christianity across the Roman Empire.

Discuss the future of managed care : Managed care has changed so dramatically in the United States over the years. What did managed care look like 10 years ago compared to how it looks today?

Add the functionality to its cash register : The Chocolate Delights Candy Company needs to add the following functionality to its cash register: When a customer is checking out, the cash register needs to store the required data pertaining to each item the customer is buying

User Account

All Pages