Question: Complete and submit the assignment. Criteria: 1. 10 Marks for the students who show the results in online mode. 2. 8 Marks for the students

Complete and submit the assignment. Criteria: 1. 10 Marks for the students who show the results in online mode. 2. 8 Marks for the students who submit the assignment. The Task is as follows: Design the data base for a wholesale furniture company. The database has to allow to analyze the company's situation at least with respect to the Furniture, Customers and Time. Q1. The company needs to analyze: the furniture with respect to its i) type (chair, table, wardrobe, cabinet. . ), ii)category (kitchen, living room, bedroom, bathroom, office. ..) iii)material (wood, marble...) Q2. The company needs to analyze: the customers with respect to their i)location, by considering at least cities, regions and states. ii)The company is interested in learning at least the quantity, income and discount of its sales. Complete and submit the assignment. Criteria: 1. 10 Marks for the students who show the results in online mode. 2. 8 Marks for the students who submit the assignment. The Task is as follows: Design the data base for a wholesale furniture company. The database has to allow to analyze the company's situation at least with respect to the Furniture, Customers and Time. Q1. The company needs to analyze: the furniture with respect to its i) type (chair, table, wardrobe, cabinet. . ), ii)category (kitchen, living room, bedroom, bathroom, office. ..) iii)material (wood, marble...) Q2. The company needs to analyze: the customers with respect to their i)location, by considering at least cities, regions and states. ii)The company is interested in learning at least the quantity, income and discount of its sales
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
