Answer to Question #257537 in Databases | SQL | Oracle | MS Access for Agy

Question #257537

Case Study Due to COVID-19 regulations Bohlale Clothing has decided to implement an online system to manage purchasing, inventory and sales of its products. You have been requested to create a functional database to ensure that the following information is captured: a) Bohlale Clothing is located in a number of malls such as Maseru Mall, Pioneer Mall, Sefika etc . Each location is identified by its location ID, address town/city, contact number and business type Business Type can be either a store or a warehouse. b) Bohlale employs many employees on different position, where each employee has a location, first name, surname, title (salesman, buyer, receiver, and manager), address city/town contact number, fulltime or part time and rate.

Expert's answer

The ER diagram of the above mentioned requirement is listed below -