Data Analysis Essay Example | Topics and Well Written Essays - 2500 words

Data Analysis - Essay Example Every order contains one or more products; therefore, the association between the Purchase order class and Line product class is one or more. However, every product in Purchase order refers to only one product in Product. Therefore, the association between the Line product class and Product class is one to one. There will only one payment detail for every purchase order; therefore, the association between the Purchase order class and Payment detail class will be one to one. Figure 2 shows the relational model (Entity relationship diagram) for National Treasure Online Shop. Additional attributes as password, and email are included in Customer entity assuming that customer will register on website when he/she will make purchase first time so that for the next time the customer will only need to login for making any purchase with the website. PK and FK show the Primary key and foreign key in entity. Figure 3 shows the output of Query 1 that displays the list of product categories for National Treasure Online Shop. When Query 1 is executed, it displays the list of product categories that is Cards, Calendars, Books, and Diaries. This is the first thing that customer visiting on the website is presented on the website home page. Figure 4 shows the output of Query 2 that displays the list of product with product categories for National Treasure Online Shop. This query will be useful for displaying the product list based on product categories. Figure 5 shows the list of the customer visited the National Treasure Online Shop. Query 5 will display the list of the entire customer who had purchased any products or registered to the website as a customer. This query will be useful for selecting customer for any promotional offers or contests. Figure 7 shows the lists of product for any particular order that customer have made with National Treasure Online Shop. Query 5 will display the