Results 1 to 2 of 2
  1. #1
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86

    Is there a better way to organize this data?


    Here's the working example: This is a Database for tracking information about packages at a post office.

    There's a table for the Customers (A customer can be a sender or a receiver)
    There's a table for information about the packages, which point to a receiver and a sender.

    However, the issue here is that there can be many packages for the same receiver/sender, with almost identical data.

    For example, let's assume that at this post office, all the customers (senders) are mass producers of ONE good. Now to further exacerbate things, let's also assume that every receiver of goods from each individual shipper is unique. The issue here then, is that each sender is linked with only one receiver, and all the package info is identical. So in the package table you would have hundreds of package entries that are identical other than fields like date/time.

    if there was a producer of wooden carved bears, the packaging info would be the same everytime, the only thing different would be the date/time and maybe a few other fields (like: Was the package Received/Sent properly?) .What is the best way to organize the database to reduce redundancy?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the tPackage table:
    PackID, Contents wt,
    321, Wood Bear, 12

    the tCustomer table:
    CustID, Name, address, ....
    456, Bob Smith, ....
    789, John Wick...


    the tDelivery table:
    PackID, SenderID, ReceiverID, SendDate,
    321, 456, 789

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

Similar Threads

  1. Replies: 2
    Last Post: 11-06-2016, 09:23 AM
  2. Replies: 1
    Last Post: 07-11-2014, 01:31 PM
  3. How to organize queries?
    By adacpt in forum Access
    Replies: 3
    Last Post: 01-22-2012, 09:10 PM
  4. Basic How-to-Organize ?s
    By flwrgrl in forum Access
    Replies: 3
    Last Post: 04-28-2011, 02:22 PM
  5. Replies: 1
    Last Post: 04-12-2011, 06:45 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