Part I: Convert the Shipping Manifest in Table 4-5 (below, not in our text) into a entity relationship diagram in 3NF.

Notes Your database should be a generic database that will work for new data going forward, not just the example data that is in the figure. Use your understanding of the world to make decisions. Assume the most typical case.Note that for the problems from our text the author chose to draw the rows as columns and columns as rows.Follow the rules that we learned in class, including but not limited to:Use dash or solid lines for weak and strong entities.We can no longer use many-to-many relationships or ternary relationships.Include connectivities (tick marks and circles)Include verbs on relationships only when there is more than one relationship between the same two entities.You must use Visio to draw your diagrams.Formatting NotesDo not include to much extra verbiage around your problem. This includes things like notes, the problem itself, or long explanations of the choice you made. If you do include extras make sure you use formatting to make it easy for me to find your answer.Be sure to minimize the number of times that relationship lines cross each other. This makes the diagram difficult to read. With diagrams with ten or less entities it is generally possible to rearrange the diagram so that no lines cross.Each diagram should be complete. Do not include any this line continues on the other diagram references.To give yourself more space you can decrease the margins in MS Word to 1/4".Your homework should be submitted as a single MS Word document. Use the snipping tool in MS Windows to create an image of your Visio diagram to paste into your MS Word document.Don't forget to mark your primary keys and foreign keys in Visio with the PK and FK icons.

TABLE 4-5 Shipping Manifest Shipment ID: Origin: Destination Ship Number 01/10/2012 Shipment Date 00-0001 Boston Brazil 39 01/14/2012 Expected Arrival: 002-15 Henry Moore TOTALWEIGHT Captain Item Number Type Description Weight Quantity 500 100 50,000 Concrete Form Steel Beam 3223 BM 3297 BM 87 2,000 174,000 Shipment Total: 224,000