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
1st Normal Form (1NF)
In the Ice Cream Shop Example, our client would like to implement
(1) multiple Addresses for each Customer, and
(2) 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), PK/FK, 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 3 NF , which includes 1 NF and 2 NF .
3
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).
Computer Science Need urgently 1 s t Normal Form

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 Finance Questions!