Hi Everyone, Hope you all had a great New Year.
I have been tasked to convert an Excel Flat file into a Relational Database (sort off) to keep track of Shipments. The headings are already provided (Please see the attached excel file for more info)
I'm a beginner on this subject. So I began grouping the headings first into sort of a related fields and the idea is to create a table base on the groupings and linked them together in Access (Relationship)
This is what I have come up so far Normalizing the headings.
EXPORTER
-----------------------------------
-ExporterID
-Name
CUSTOMER
-----------------------------------
-CustomerID
-Region
-Country
-PO Number
-Bill of Lading
SHIPMENT
------------------------------------
-ShipmentID
-CustomerID
-ExporterID
-ContainerID
-Destination
-ETD
-Term
-ETA
-Period
CONTAINER
------------------------------------
-CointainerID
-Batch No
-Number of Palletes
-Net Weight
-Gross Weight
-Volume (Cubic Meter)
-Container Type
-Pieces
My question is did i normalize it right? If not i would really appreciate your input on these.
By the way it might be worth mentioning this. When i was looking at the Data on the Excel file. I have noticed that the Batch Number and Container columns have more Data on it. Meaning the Shipment on that day did not only contains more Batches of Item, but also has more Containers.
I am really hoping someone here can kindly help me putting this together. Thank you so much in Advance.
Bookmarks