Go back to

Database Tables

The Proposed system comprises of tables. they include:
CUSTOMER, SALE, EMPLOYEE, STOCK, SUPPLIER, ORDER,
ORDERED ITEM, STOCK SUPPLIED, INVOICE, INVOICE LINE, PROMOTION TITLE.
The following Data Dictionary identifies each table with its diverse yet related attributes.
The contents of the are described. This is further broken down into its
type, Format, the range(optional).
If the attribute is required it is indicated by a Y (Yes) or left blank if the answer is No.
The Primary Keys (PK) and Foreign keys are identified and as a result,
the reference Table linking both tables is identified. click on the link below to see the data dictionary!