Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2011
    Posts
    1

    Unanswered: Help Converting Excel Flat File into Relational Database

    Hi All,

    I have been tasked to convert an Excel Flat File into a relational database. I am sort of beginner (i guess) as I have only done this a couple of times when I was in College.

    So I started grouping each related heading from the Excel Sheet and convert them into tables.

    Can someone kindly tell me if my normalisation and relationship is in line with my goal.

    Goal(s)

    Be able to query the database with the following criteria:

    -How many containers was used in a shipment
    -What batches of items was loaded into what container

    Here is the current relationship I have. See image below. Any input will be gladly appreciated. If you want to test my DB I am more than happy attached it for you.

    Thanks very much in advance.
    Attached Thumbnails Attached Thumbnails RelationShip.JPG  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •