General Parts and merchandise Lubby General Parts and merchandise imports 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.

You are required to do the following:-

Write an SQL code that will create a Lubby General Parts and merchandise database

Extract all tables with their corresponding attributes

Create the above tables and include at least 3 constraints per table

Insert 2 records per table

Normalization is a systematic approach of decomposing tables to eliminate data redundancy (repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. Design a simple table and demonstrate these anomalies.

Explain the major goals of ensuring database security.

Suggest any 5 physical and 5 electronic database security measures you can out in place to protect a database.

Identify the activities that you can perform during conceptual database design