Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

create a 3NF entity relationship data model based on the scenario presented below Read the following paragraph and create a data model for the business

create a 3NF entity relationship data model based on the scenario presented below

Read the following paragraph and create a data model for the business under discussion. My partner and I own an independent record store. Well, I guess record store is really the wrong term these days since we really dont sell a lot of records anymore. We sell mostly CDs, but also some tapes. And yes, we do stock vinyl records, too. Regardless of format (that is, CD, tape, or record), we sell long-playing albums as well as singles. Every item we sell is priced, and we keep track of the number of each individual title in stock on a daily basis. We like to track sales by both title and recording artist. The sales information by title needs to be tallied weekly to send to external ratings services so they can compile their best-seller charts. We often get customers who ask us to find certain songs for them. For singles, this is fairly easy because the title of the single is the title of the song. Some singles have multiple songs on them, though. Albums, on the other hand, comprise multiple songs. We need the ability to search for titles by song to let customers know which titles (both singles and albums) contain the songs they are looking for.

please make a vizio ER diagram based on it

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_2

Step: 3

blur-text-image_3

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

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

Identify the nine clusters in the analytics ecosystem.

Answered: 1 week ago