Results 1 to 3 of 3
  1. #1
    thecritter99 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    1

    Question Stuck with relationships

    Hi there,



    I am creating a movie rental database in Access that will work in a similar way to Netflix or Lovefilm, where rentals are not charged by individual rentals, but as part of a subscription where a user can rent a certain amount of DVDs at once. It's been a while since I've used Access and I'm not finding it that easy getting back into it. By the way, this database will be used to power some ASP in a website (of which I have never done before, so I want to make sure it is correct before going any further!)

    I have set up all the tables I want to create, but I am unsure of whether the relationships are set up correctly and whether I have done it in the most efficient way. I haven't yet entered data in the database, but I have a feeling that I have not set up the relationships correctly for the tables in the red box. Can someone check my relationships for me and if there are some problems, suggest the way to resolve them? I know if they're not right now, then it can have major implications!!

    Thanks in advance!

    Here's the screenshot: http://dl.dropbox.com/u/43666839/Mov...ationships.png

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    create some test data - both valid and invalid. test the model. and repeat

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If you are still having issues or are uncertain of your structures, these videos may be useful.

    You might wish to watch these free videos, that are available to anyone with access to the internet. There are other videos, these are just a sample.

    http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

    http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

    http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

    http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

    http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

    http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

    http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

    http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

    You can go back and watch these as often as you want.

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

Similar Threads

  1. I am stuck!
    By asaloba in forum Database Design
    Replies: 9
    Last Post: 02-29-2012, 12:47 PM
  2. stuck on the best way to do this
    By token_remedie in forum Queries
    Replies: 1
    Last Post: 09-22-2011, 10:19 PM
  3. Can anyone help please... I am stuck
    By Casper2012 in forum Forms
    Replies: 7
    Last Post: 08-15-2011, 11:27 AM
  4. Relationships/Joins/Forms STUCK
    By cooper in forum Forms
    Replies: 4
    Last Post: 08-04-2011, 02:21 PM
  5. Help I am stuck
    By Darkglasses in forum Database Design
    Replies: 10
    Last Post: 03-04-2011, 09:10 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