Any SQL users out there feeling bored..? Please help.

Discussion in 'BlackHat Lounge' started by oreilly2311, Nov 3, 2011.

  1. oreilly2311

    oreilly2311 Regular Member

    Joined:
    May 19, 2009
    Messages:
    220
    Likes Received:
    118
    So I need a simple database schema for a DVD database. Here is my criteria:

    - database has to allow storage of customer details (names, etc.)

    - customer preferences (favourite genres, actors, directors etc.)

    - a catalogue of films held in stock ready for rental or borrowed

    - a table cross-referencing the DVDs to the customers who have borrowed them

    - a list of main actors linked to the list of films, genres, directors (to allow searching by category) etc.

    Can anyone help??
     
  2. marusia

    marusia Senior Member

    Joined:
    Oct 25, 2010
    Messages:
    1,122
    Likes Received:
    2,325
    Ha! I had to build something JUST like this when I was in school for database admin. I <3 SQL. I'm at work right now, but give me a bit, and I'll see what I can remember.
     
  3. oreilly2311

    oreilly2311 Regular Member

    Joined:
    May 19, 2009
    Messages:
    220
    Likes Received:
    118
    Sounds good buddy! :)
     
  4. marusia

    marusia Senior Member

    Joined:
    Oct 25, 2010
    Messages:
    1,122
    Likes Received:
    2,325
  5. a_z_0_9

    a_z_0_9 Junior Member

    Joined:
    Jul 18, 2011
    Messages:
    111
    Likes Received:
    21
    Do you still need help with schema diagram, PM me i can help you
     
  6. dannyduberstein

    dannyduberstein Junior Member

    Joined:
    Nov 1, 2011
    Messages:
    192
    Likes Received:
    107
    hehe me too. My first guess was that this was a homework assignment!
     
  7. marusia

    marusia Senior Member

    Joined:
    Oct 25, 2010
    Messages:
    1,122
    Likes Received:
    2,325
    Yeah, my same thoughts. I still have that book.