|
Back to the Data Model
The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
Vehicle Imports.
A. This is a Statement of the User Specifications.
A company imports different types of items from local and international suppliers.
The items are categorized as Vehicles, Hardware, Spare parts and Accessories.
Each category of items is kept in a separate store.
The classification of vehicles includes but is not limited to cars, lorries, buses and tractors.
Hardware items are classified as domestic hardware, industrial, medical and agricultural hardware.
Hardware such as electrical components may be for domestic or industrial use.
All spare parts and accessories that are stocked are for vehicles and, they are classified based on the
classification of vehicles i.e. spare parts for cars, for lorries, for buses etc.
Each item is given a unique identification code of 13 characters in the format CC-YR-BB-NNNN.
CC identifies the category, YR identifies the year in which the item was socked, BB is the batch number
in the respective year and NNNN is the number attached to that item in that specific batch.
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 of any item over a desired period range
(weeks, months, years).
The same job role might require to know the stock value selectively e.g. by product range(s), by batch range(s),
by year range(s).
The sales department requires to know the following details (based on desired filters/ ranges/ selections):-
Buses - make, seat capacity, cc capacity, number of axles, rate of fuel consumption, quantity in stock.
Cars - make, color, cc capacity, seat capacity, model, price, quantity in stock.
Loaders - make, cc capacity, weight, tonnage, quantity in stock.
Lorries - make, cc capacity, model, price, quantity in stock.
Tractors - make, cc capacity, weight, quantity 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.
Data is captured about local and international suppliers.
However supplier number, name, address and contact person is captured for every supplier.
For local suppliers PIN and VAT registration numbers, Bankers, Bank Account number(s), telephone number(s) are
also captured.
For foreign suppliers the properties country, city/town/location, email address are required.
All items are received in batches.
A batch has a unique identification number (Numeric �V Size 6), quantity in the batch, date of receipt, mode of
shipping (road, air, rail, sea), staff confirming the receipt.
Each item must be attached (belongs) to a specific batch.
The purchase department requires know the following details about all the items - supplier, country of manufacture,
cost price, mode of shipment.
The stores department may at any moment require details of any item in a any storage area.
Such details may include but not limited to quantities in stock, balance on a specific batch etc.
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.
A member of staff works for only one department.
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.
Extra data is kept about staff in the administration department.
This includes highest education level, number of children (the number of children determine the family allowance given),
residential address, mobile telephone numbers (maximum 3 numbers).
Any staff in the sales department may be employed on only one pf the following terms - contract, permanent employment,
probation or part-time employment.
B. The Things of Interest, ('THINGS'), include :-
B.1 Batches
B.2 Items
B.3 Vehicles
B.4 Others to be determined.
C. These THINGS are Related as follows :-
C.1 To be determined.
D. Other Characteristics of these THINGS include :-
D.1 To be determined.
E. Sample Data includes :-
E.1 To be determined.
F. Typical Enquiries include :-
F.1
|
  |
Barry Williams
November 28th. 2009
Principal Consultant
Database Answers
|
|