Database Answers Newsstand in Times Square, New York (Click for Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Newsstands 
Back to the Data Model
A. The requirement is to design a Database for Newsstands
Question: There is a newsstand that sells reading material to its customers. 

The newsstand sells video tapes, books and magazines to its customers. 

A Customer may sign up for subscription to a magazine or a subscription for movie rentals. 

Customers have to pay a monthly bill for subscriptions to both magazines and Movies. 

Magazines and Videos come from a variety of venders. 

Venders have to ship magazines and videos to the newsstand. 

Venders use different shippers to deliver their merchandise.


Barry says the Things of Interest are :-
   A.1 Books
   A.2 Customers
   A.3 Magazines
   A,4 Movie Rentals
   A.5 Subscriptions
   A.6 Vendors
   A.7 Videos
   A.8 Others, to be determined

B. How are they related ?
   B.1 A Customer can rent zero, one or many Videos
   B.2 A Video can be rented by zero, one or many Customers.
   B.3 Others to be determined.


Barry Williams
February 22nd. 2011
Principal Consultant
Database Answers

 

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map