Answer to Question #260479 in Databases | SQL | Oracle | MS Access for thugger

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:

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.

c) The main mandate of the store is to sell clothes and other dressing accessories. Each clothing product has a

d) List new stock received on a given date (order by branch

Answer 1

create table location(
   location_ID NOT NULL,
   address(town/city) NOT NULL,
   contact_number NOT NULL,
   business_type DATE,
   PRIMARY KEY (location_id )
)

create table employee(
   location NOT NULL,
   first_name NOT NULL,
   title NOT NULL,
   address(city/town) NOT NULL,
   contact number NOT NULL,
   rate NOT NULL,
   MODE(fulltime or part time),
   
   PRIMARY KEY (contact number )
)

create table cloth_descr(   unique_ID NOT NULL,
   description NOT NULL,
   category(shirt, dress, trousers etc) NOT NULL, 
   gender (clothes for woman or man) NOT NULL,
   manufacturer NOT NULL,
   manufacturer ID NOT NULL,
   cost price NOT NULL,
   sales price NOT NULL
   PRIMARY KEY(unique_ID )
)

create table further_descr(
   sizes NOT NULL,
   color NOT NULL)