Snowflakes Bookstore is an emerging bookstore Their sales ar

Snowflakes Bookstore is an emerging bookstore. Their sales are increasing and they have many locations. One reason for their success has been the ability to process special book requests for hard to find books. This had been a manual process but due to increase in requests they must create a new tracking system to handle this process. They began to create the database and came up with the following Unnormalize Entity (See Below). They know this Entity has redundant data. They would like you to take this preliminary design and Normalize their Special Order Book Entity. Here is their unnormalized design Special Order Number Special Order Date Order taken by Employee number Order taken by Employee name Customer number Customer last name Customer First name Customer phone Customer address Special order Status Qty ordered Arrival date Book ISBN Book name Book publisher Book author Book publication year Store id Store name

Solution

Functional dependencies of attributes

Special Order number --> Special Order Date

--> Order taken by Employee Number

--> Order taken by Employee name

--> Special Order Status

--> Arrival Date

---> Qty Ordered

Customer Number --> Customer last name

--> Customer first name

--> Customer Phone

--> Customer address

Book ISBN --> Book name

--> Book publisher

--> Book author

--> Book publication year

Store id --> Store name   

based on the functional dependencies above we decompose the relation into 4 tables

Underlined attributes in the tables are their primary keys.