Reply
Old 06-23-2014, 06:06 PM   #1 (permalink)
 
Status: Junior Member
Posts: 13



Default data modeling problem.... createtables for a business

This is the information:

You have been hired to design a database for CD-Coop, a cooperative store on campus where customers can purchase used music CDs. You wish to keep track of all the purchases made by your customers. You also wish to record the different styles of music (Rap, Jazz, etc) and keep track of which customers prefer which styles, so that if a CD arrives in the customer's preferred style, you can contact the customer to let them know.


Assumptions

1. A customer may be entered into the database before any associated purchase is made



2.A CD will have one and only one style

3.Each physcial CD has a unique ID number. Therefore, two copies of the same CD will each have its own ID number

4.Each contact letter to a customer is for a single CD.

This is what i have so far...


One table for COSOMERS with a primary key called CostomerID
One table for PURCHASES with a primary key called PurchaseID
ONe table for MUSIC_STYLES with a primary key MusicID and the las table that i have is this
DC'S with the primary key CD-ID

Can someone tell me if is right or if is wrong how can i fix it.....
I also need some help Drawing the IE Crow's Foot E_R model of the tables.

Thanks...!!!!
kuax7 is offline   Reply With Quote
Old 06-23-2014, 06:06 PM   #2 (permalink)
 
Status: Senior Member
Posts: 604



Default data modeling problem.... createtables for a business

Your purchases table should also have customerID as a foreign key. and CD-ID as a foreign key. This will allow to track the customer and which cd the purchased.
Steve is offline   Reply With Quote
more..

Reply

Bookmarks

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Data Modeling can you he!!1? kuax7 Databases 0 06-22-2014 06:06 AM
Data modeling diagramming help? Kje Billing Coding 0 03-13-2014 11:05 PM
Data Modeling Techniques? Ann Databases 1 09-01-2013 02:06 AM
how can data modeling and other functions like this be done with an application? PrettyHot88 Programming 1 05-03-2013 10:02 PM
About programming, data modeling and softwares? MonkeyBusiness Developer/ Developers 0 01-24-2013 03:05 PM