Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    2

    Help me on creating simple database

    I have to do this for school project.

    Describe simple database, with at least 6 tables, at least one one-to-many realtion and at least one many-to-many realtion.

    Basiclym I nead some sort of diagram with tables, table fields and relations. It has to be something related with transport or traffic.

    Ideas, anyone?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    yes
    why not try and think up an example of your own.
    come back here if you are struggling
    but at least make an effort to do your own coursework, before looking for help
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2010
    Posts
    2
    i have something about public transit bus system.

    Tables would be vehicles, garages, drivers, bus lines and one table which connects vehicles, drivers, and bus lines.
    Garage - vehicle is one-to-many,
    vehicle - bus lines is many-to many, etc.

    I need one more table, and I cant think of anything else.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    fares?
    stops?
    routes?
    schedules?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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