Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Red face Help with Conceptual ERD

    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:
    Customer
    Movie
    Personal Device
    ID Number
    Time
    Rental

    That's pretty much all I've got...help? suggestions?
    Thanks so much!!

  2. #2
    Join Date
    Apr 2010
    Location
    London, England
    Posts
    24

    Data Models to help you

    Hi

    Take a look at these Data Models on my Database Answers Web Site which should give you some ideas :-
    Video Rental Stores - Video Rental Store

    CD Collections - CD Collection Data Model

    HTH

    Barry Williams
    London, England

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Barry

    The aim of a student's coursework is to teach them certain points about database design and how to think logically. Guiding them is fine, asking them questions that make them think is even better but handing them an answer on a plate is just plain wrong.

    Doing this means they miss the most basic part of their course - how to think. I'm guessing that the lecturer will easily spot which homework was done by 1st year students and which was done by a database professional. I'm also guessing that if two students hand in the same answer then questions will be raised. But the main issue is that each coursework is supposed to teach the student something and this student is going to learn nothing.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •