Hi! So I am very new..and was hoping I could get some help
I am taking a Database Design course, and we are supposed to be creating a conceptual ERD for a simple DVD rental business using Crows's Foot Notation. It does not need to be normalized and cardinalities are not required in the diagram, though relationship connectivity are required.
I devised these business rules (hopefully they make sense and are actually valid):
-Each customer is assigned to one customer identification number.
-Each movie can be viewed on one or more devices
-A device can only play one movie at a time
-A movie is viewable for 72 hours once rental has begun.
-A customer can rent at max five movies a day
I think my entities are:
That's pretty much all I've got...help? suggestions?
Thanks so much!!