Refer to Figure 2-3 (CSV File as Viewed in Microsoft Excel) in the Kale and Jones book.Customers place orders which can include a number of different items being ordered.Items have a unique identifier which is ItemID, which in this display is shown as Item Ordered.For GBI, each item has a unit price.As shown in the figure, partial orders can be shipped and then the remainder shipped later as necessary.Identify the tables needed for a 3NF relational database.For each table identify the primary key with an underline and any foreign keys with italics.

As an example:STUDENT (STUDENT_ID, STUDENT_LAST_NAME_,ADVISOR_ID)