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