Assumed that ABC enterprise promotes their Stocks in a few campaigns. The data collected is shown...

Transcribed Image Text:

Assumed that ABC enterprise promotes their Stocks in a few campaigns. The data collected is shown in Table 2.1. Table 2.1. Campaign activities for stock Campaign conducted by ABC enterprise Campai Campaig StockNo StockDescr StockCateg Token gnNo nTitle ory (i) (ii) (iii) C3 C1 C2 C4 Deepavali P6863 Chinese New Year Christmas P1113 P7778 Hari Raya P5566 Acer Aspire Apple iPhone Apple MacBook Samsung Galaxy Laptop Pendrive Smartphone Key chain Laptop Pendrive Smartphone Key chain Discou nt (RM) 50.00 100.00 50.00 20.00 Construct dependency diagrams with the correct arrow(s) to illustrate functional dependencies for the data in Table 2.1 Formulate First Normal Form (INF), Second Normal Form (2NF), and Third Normal Form (3NF) in the normalization process for the data as shown in Table 2.1. Determine whether Boyce-Codd Normal Form (BCNF) exists in Table 2.1 with explanation. Assumed that ABC enterprise promotes their Stocks in a few campaigns. The data collected is shown in Table 2.1. Table 2.1. Campaign activities for stock Campaign conducted by ABC enterprise Campai Campaig StockNo StockDescr StockCateg Token gnNo nTitle ory (i) (ii) (iii) C3 C1 C2 C4 Deepavali P6863 Chinese New Year Christmas P1113 P7778 Hari Raya P5566 Acer Aspire Apple iPhone Apple MacBook Samsung Galaxy Laptop Pendrive Smartphone Key chain Laptop Pendrive Smartphone Key chain Discou nt (RM) 50.00 100.00 50.00 20.00 Construct dependency diagrams with the correct arrow(s) to illustrate functional dependencies for the data in Table 2.1 Formulate First Normal Form (INF), Second Normal Form (2NF), and Third Normal Form (3NF) in the normalization process for the data as shown in Table 2.1. Determine whether Boyce-Codd Normal Form (BCNF) exists in Table 2.1 with explanation.

Answer rating: 100% (QA)

The answer provided below has been developed in a clear stepbystep manner i dependency diagram for ... View the full answer