Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Seriously! Music is a new music information service under development. While other companies sell music in various forms and media, Seriously! Music seeks to be

Seriously! Music is a new music information service under development. While other companies sell music in various forms and media, Seriously! Music seeks to be the one source users will turn to when they want in-depth information about songs, artists, musicians, genres, and other aspects of music. Specifically, the company would like you to create the segment of its database that deals with songs, albums, artists, musicians, genres, and record companies. The company wants a variety of information, starting first and foremost with the songs (or music pieces). The company also wants to track the artists singing the songs (or playing the music piece). An artist may be a group of individual musicians or might be a single musician with respect to a song. (For example, Eric Clapton is a musician and artist in his own right but was also a member of the artist groups Cream and the Yardbirds.) A song or work may or may not be classified into a one genre but a given song might appear in more than one genre (e.g., blues and alternative music). A song may or may not be part of a larger collection of songs (album), and might or might not be associated with a recording label (record company). A song may appear on more than one album (e.g., on an original album and then on a "Greatest Hits" album). And although an album is connected to at least one artist, it is possible for an album to be associated with multiple artists (e.g., "Greatest Hits of the 1990s"). Sample data illustrative of the above is provided on a separate Excel spreadsheet. [NOTE: This is a large spreadsheet. It is given only as a sample to help you get started. Your project requires far fewer rows of data. See Deliverable II below.] There are several deliverables for this capstone project, each of which counts as a separate component of the capstone grade. Each deliverable must be submitted in order to get the maximum grade. Include your name on all deliverables e.g., using the comments in SQL or as a text box on Visio. The deliverables are as follows: DELIVERABLE I: Create the ERD [VISIO] with entities and relationships (e.g., 1:1, 1:M). Show strong/weak (solid vs. dotted line) and whether optional or mandatory. The diagram must include ALL of the attributes you plan to include in Deliverable II

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

Managing Your Information How To Design And Create A Textual Database On Your Microcomputer

Authors: Tenopir, Carol, Lundeen, Gerald

1st Edition

1555700233, 9781555700232

More Books

Students also viewed these Databases questions

Question

1. Who will you assemble on the team?

Answered: 1 week ago

Question

Did the team members feel that their work mattered

Answered: 1 week ago