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

Question

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: c) The main mandate of the store is to sell clothes and other dressing accessories. Each clothing product has a unique ID, description, category (shirt, dress, trousers etc), gender (clothes for woman or man), manufacturer ID, cost price and sales price. d) Clothing in Bohlale store have varies sizes and colors. The store requires information on the size in which the clothing item is manufactured together with the color.

Answer 1

The database can consist of the following tables:

1. location(locationID, address, contact)
2. employee(employeeID, firstName, lastName, employeeType, address, rate)
3. title(titleID, titleName)