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@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 - 03:36:07 CDT