Case Study

Entrepreneur and electronics enthusiast Mr$.$ John wants to launch an online store that specializes

in selling electronic devices and accessories. He plans to establish the "Gadget Emporium" online

marketplace to provide both private consumers and business organizations with a large selection

of electronic devices. Your job as a database designer is to help Mr$.$ John create and implement a

strong database system to support his new e$-$commerce endeavor. The proposed system should be

able to keep track of all customers, products and orders.

Create all four forms of Normalization $($UNF$,1$NF$,2$NF$,3$NF$)$ according to the above description.