Results 1 to 2 of 2
  1. #1
    nl49 is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2013
    Posts
    1

    Help Designing a database for a school assignment

    I need some help on designing a database for school....I'm not sure how many tables I would need. The instructions are:

    Design a database that will help Netflix.ca do the following (but not limited to)…



    1. Produce a list of all members and their account information including membership status (active, closed, suspended, etc), date the account was opened, contact information, the balance and the date the balance was updated. In case the account is closed, the date the account was closed is also required.
    2. Produce a list of all members, their activation codes and the device they are connecting with (e.g. Apple TV, Wii, PS3, XBox, etc).
    3. Produce a list of all member accounts
    4. Produce a list of all transactions including the account(s) affected, the date of transaction, and the movie titles affected.
    5. Produce a list of all movies by genre with description and rating.
    6. Produce a list of all movies and their popularity by genre with date and number of views.
    7. Produce a list of new releases.
    8. Produce a list of all ratings made by movie, date, and time.
    9. Produce a list of all viewer and critic reviews.


    How many tables should I produce? One for account information, movies and transactions? Or do I need a new table where ever it says list, so 9 tables in total? I'm very confused and any help would be much appreciated....

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a good starting point to help you understand the design of an RDBMS

    http://www.deeptraining.com/litwin/d...aseDesign.aspx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. School Transportation Database
    By SMOORELCC1 in forum Database Design
    Replies: 1
    Last Post: 01-18-2013, 12:43 AM
  2. Project Assignment Database
    By flsticks in forum Access
    Replies: 3
    Last Post: 08-10-2010, 10:54 AM
  3. School Enrollment Database
    By jpepin in forum Database Design
    Replies: 1
    Last Post: 04-08-2010, 05:23 PM
  4. Need help a school report database
    By learnac in forum Database Design
    Replies: 1
    Last Post: 01-28-2010, 09:14 PM
  5. Database Design for a School
    By FallingToaster in forum Database Design
    Replies: 2
    Last Post: 08-12-2009, 10:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums