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