1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    219
    Likes Received:
    117
    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,320
    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:
    219
    Likes Received:
    117
    Sounds good buddy! :)
     
  4. marusia

    marusia Senior Member

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

    a_z_0_9 Junior Member

    Joined:
    Jul 18, 2011
    Messages:
    110
    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:
    189
    Likes Received:
    105
    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,320
    Yeah, my same thoughts. I still have that book.