Results 1 to 3 of 3

Thread: Car Rental ERD

  1. #1
    Join Date
    Sep 2003

    Car Rental ERD

    Last edited by selfhigh05; 10-03-03 at 18:32.

  2. #2
    Join Date
    Jun 2003

    Re: Car Rental ERD

    Originally posted by selfhigh05
    I need some guidance since the teacher is offering none. Thank you.
    If I were you I would start off writing use cases like:

    customer -> (rent vehicle) << include >> (drop-off vehicle), (pick-up vehicle), (make reservation)

    GNBranchStaff -> (make reservation)

    GV Admin -> (manage stock) << include >> (manage stock at drop-off), (manage stock at pick-up), (manage vehicle type availability)

    system -> (manage pool) << include >> (optimize availability)

    GV Admin -> (manage car yard stock) << include >> (ship vehicle to branch)

    and then write event flows, identify subsystems, identify components and finally identify DB tables.

    Here is an example:

    Good luck,

  3. #3
    Join Date
    Apr 2003
    London, England

    Re: Car Rental Data Model

    There is a Car Hire Data Model on my Database Answers which will give you a Kick-Start in the right direction :-

    A free Access Database is available.

    Barry Williams
    Principal Consultant
    Database Answers

Posting Permissions

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