Question: Computer Science Need urgently 1 s t Normal Form ( 1 NF ) In the Ice Cream Shop Example, our client would like to implement
Computer Science Need urgently
Normal Form NF
In the Ice Cream Shop Example, our client would like to implement
multiple Addresses for each Customer, and
multiple Category for each Product.
Using the AddressNum approach for multiple Addresses and the M:M relationship approach for multiple Categories.
Fill in the column names CName PKFK and Ref of the tables below, following the ID column as PK naming convention. Note that the addresses should have the appropriate columns, while each Customer still only has one Phone Number. We have excluded the OrderDetails table for this problem.
Ensure that the database design meets NF which includes NF and NF
Cells in the table below can be left blank.
You may or may not need to fill in all the column names CName Some columns may need to be moved to other tables.
Note: you should not create new entity and relationship attributes remember that not all columns were created from attributes, but all attributes become column
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
