Question: Given the table list below and common assumptions, in which normal form is this list? The asterisks ( * ) indicate primary keys Customer (

Given the table list below and common assumptions, in which normal form is this list? The asterisks (*) indicate primary keys
Customer(*customerid, firstname, lastname, Address, City, State, zipcode)
Sale("saleid, saledate, customerid)
Saleitems("saleid,*itemid, Quantity)
Item(*itemid, Description, listprice, quantityonhand)
3NF
2NF
1NF
None of the answers are correct
4NF
 Given the table list below and common assumptions, in which normal

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!