Re: Newbie needs help with E/R model
From: Barry <barryw_at_databaseanswers.com>
Date: 7 Jun 2003 01:36:07 -0700
Message-ID: <55816d8a.0306070036.7eb76937_at_posting.google.com>
Date: 7 Jun 2003 01:36:07 -0700
Message-ID: <55816d8a.0306070036.7eb76937_at_posting.google.com>
rm1122333_at_yahoo.com (Rob) wrote in message news:<9d11b6b.0306052027.60762b58_at_posting.google.com>...
> I'm supposed to design a database for a movie rental shop using the
> Entity/Relationship model. Problem is, I have to use between 5 and 10
> entities, and between 10 and 20 relationships.
Here is a Data Model that might help :-
http://www.databaseanswers.com/data_models/video_rental_store/video_rental_dezign.htm
To add more Entities, there are two ways - either add more details for existing functions, or add more functions. For example, CRM or chasing bad payers, or Suppliers, or ...
Good luck.
Barry Williams
Principal Consultant
Database Answers
Received on Sat Jun 07 2003 - 10:36:07 CEST