subject

The next page shows a shipment manifest for an antique store. Please complete the following:. 1. Draw one relation based on the manifest
2. Identify the primary keys as well as functional dependencies
3. Determine if this is in 1st normal form
4. Determine if the relation is in 2nd normal form. If not, normalize
5. Determine if the relation from step 4 is in 3rd normal form. If not, normalize Please submit drawings for each step to show the progression towards a solution.
Please submit drawings for each step to show the progression towards a solution.
Anthony's Artistic Antiques
Order Manifest
Order ID: 382133-22 Order_Date: 09/20/2019
Customer Name: Sam Potnick Customer ID: C212301
7 Village Way Customer Phone: (508) 655-2121
Natick, MA 01703
SalesReplD: R372 Fullfillment_Sp_ID: F21934
SalesRepName: Leona James Fullfillment_Sp_Name: Henry Smith
Fullfillment Ctr ID: FC233
FC_City: Boston
FC_State: MA
Item NO Description Price Pick Date PickStaffID PickStaff Name ShipDate
34212 1910 Sewing Machine $450.00 09/20/2019 P2138 Jane Herbert 09/21/2019
45212 2004 Red Sox Bat $892.21 09/21/2019 P2312 Big Papi 09/22/2019

ansver
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 06:30, messyquestions
Plz 40 points what are raster vectors? a bitmap image a vector file a type of printing press a small projector
Answers: 1
image
Computers and Technology, 24.06.2019 00:30, Auttyrain3929
Afiling system in which an intermediary source of reference, such as a file card, must be consulted to locate specific files is called a(n) system. a. shelf filing b. direct filing c. indirect filing d. shingling
Answers: 1
image
Computers and Technology, 24.06.2019 07:20, djs1002
Ingrid started speaking about her slide presentation. when she clicked to th"third slide, which had just a picture of an elephant, she forgot what she wassupposed to talk about. what could ingrid do to avoid this situation in thefuture? oa. print handouts for her audience. ob. add presenter's notes to each slide. oc. add a video to each slide. od. save her slide presentation to a flash drive
Answers: 2
image
Computers and Technology, 24.06.2019 13:00, CarlosParker99
Think of a spreadsheet as a giant calculator spread of paper chart data collector
Answers: 2
You know the right answer?
The next page shows a shipment manifest for an antique store. Please complete the following:. 1. Dr...

Questions in other subjects: