Lubby General Parts and merchandiseimports different vehicles from different suppliers. Each vehicle is kept in a separate store. The vehicle include cars, Lorries, Buses, Tractors and Loaders. The classification of vehicles includes but is not limited to cars, Lorries, buses and tractors. Other data captured about an item is the country of manufacture/ origin. The General Manager of the company at any time may want to know the number of months the item has spent as company stock, the quantity in stock and the total weekly sales. The sales department requires to know the following details like make, color, cc capacity, seat capacity, model, price, quantity, weight in stock.
The accounts department need to know for any item sold – item code, item name, purchase price, sale price, profit or loss, cumulative profit or loss over a desired period.
However supplier number, name, address and contact person is captured for every supplier.

The purchase department is responsible for placing orders of goods when the quantity falls below re-order levels. Each item has its own re-order level. An order includes the item code, name, quantity required, supplier, mode of shipment, date of delivery. When the items are received the Stores department prepares a receipt note. The receipt note includes batch number, item code, name, quantity received, supplier, mode of shipment, date of delivery, staff receiving the items.

Data kept about a staff is the staff number (uniquely identifies the staff and identifies the department in which the staff works), name, sex, date of birth, marital status, next of keen, salary scale. There are four departments namely Administration, Purchase, Sales and Stores.

1. You are required to do the following:-
a. Write an SQL code that will create a Lubby General Parts and merchandisedatabase (2 marks)
b. Extract all tables with their corresponding attributes (3 marks)
c. Create the above tables and include at least 3 constraints per table (20 marks)
d. Insert 2 records per table