var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help Converting Excel Flat File into Relational Database
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.
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.