I am looking for a case study of a Departmental store

Tweet

Case Study Department Store The managing director of a large department store asks you to develop a database system for his business. He explains that the department store which is located in a ten-floor building in Manchester Arndale Centre has many different departments and each department is located on a floor of this building. The only way to get in touch with the employees of each department is by using the phone since each department has its own phone line. Each department employs a number of people and each employee has a manager who is also located within the same department. Each employee is represented using his employee number, name, and the department he works for. There might be many layers of management in some departments since these can employ a large number of people. The department manager is the person who is charge of the management of the department and he/she is reporting directly to the managing director. For each department we would like to keep information about its name, floor and its phone number and of course, its employees and managers. Items are located in departments so their sales should be recorded for each department. Each sale is given a unique identifier and we also keep the quantity and overall price of the sale. For each item the data kept are its name, type and color. We can assume that the name is unique for each item. We would also like to keep information about the deliveries of items. We would like to identify each delivery using a unique identifier and also know the quantity of a specific item included in a specific delivery. Since each delivery is related to a supplier, we need also to know the supplier name and the supplier number. The same item can be supplied by different suppliers and also the same item can be sold by different departments. We do not keep any other data neither we are interested in adding other less useful information. For simplicity, we can also assume that a sale and a delivery always include only one item.