Thread: Erd problem
View Single Post
Join Date: Jul 2007
Posts: 108
Reputation: Majestics is an unknown quantity at this point 
Solved Threads: 7
Majestics Majestics is offline Offline
Junior Poster

Erd problem

 
0
  #1
Nov 28th, 2008
 Apply all steps of conceptual and logical database design on the following requirements: 
The system should be able to store a customer’s name, address, and contact information and a book’s ISBN, publisher, authors, and title information. A customer should be able to purchase one or many books at a time. The system should store the purchase record of customers. It should give us the information in which shelf the book is lying by storing the shelf’s number, floor, and category information. Books are supplied by suppliers. They are stored in the stock. Number of books are deducted from the stock quantity as they are sold. Additional books are demanded from suppliers by looking at the stock record.

Problem : Is stock a separate entity or a attribute and where should i place stock record.

I guess Book but not sure exactly please i need help.
Reply With Quote