Question
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
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. The items are( sales order, order date, customer ID, customer name, customer address, customer city, customer state, customer zip, item ordered, item description, quantity ordered, price each, quantity shipped, date shipped).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started