Results 1 to 4 of 4
  1. #1
    racheliza79 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    7

    Assistance with normalizing tables

    Hello!



    I'm a (online) student with NO experience when it comes to databases. I just need a little push in the right direction here.

    I have to normalize these tables, and I'm almost positive that the first 3 are in 3rd normal form, but I can't quite get a handle on the last table.

    PARTS INVENTORY PURCHASES
    Transaction ID
    Purchase Date
    Purchase Price
    Quantity

    PARTS INVENTORY ISSUES
    Transaction ID
    Issue Date
    Purchase Price
    Quantity

    PARTS CATALOGUE
    ID
    Description
    Type
    Manufacturer
    Quantity On Hand
    Reorder Point
    Reorder Quantity

    Parts Purchasing History
    Transaction ID
    Catalogue ID
    Quantity Purchased
    Manufacturer ID
    Order Quantity
    Price
    Shipping
    Tax
    FOB

    Thanks for any assistance!!
    Rachel

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you might have to display relationships rachel. btw, how many problems can we look forward to solving? I believe this is the second set of tables you've posted here. How far through class are you?

  3. #3
    racheliza79 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    7
    This is it, thank goodness!

  4. #4
    Join Date
    Apr 2010
    Posts
    21
    Issues and purchases are not normalised

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

Similar Threads

  1. Normalizing a table
    By racheliza79 in forum Database Design
    Replies: 3
    Last Post: 08-20-2010, 08:40 PM
  2. Assistance on DB Design required - please
    By Optimus_1 in forum Database Design
    Replies: 13
    Last Post: 07-05-2010, 04:38 PM
  3. Need Assistance with Forms
    By JDA2005 in forum Forms
    Replies: 5
    Last Post: 06-30-2009, 03:37 PM
  4. Query Assistance Needed
    By elotromanuel in forum Queries
    Replies: 1
    Last Post: 03-17-2009, 09:31 PM
  5. Normalization Assistance for Tables Please??
    By webmaniac in forum Database Design
    Replies: 10
    Last Post: 09-02-2006, 05:56 AM

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