COMP 72105 – Database Administration
Capstone Project Part 1 – Database Design (10%)
DUE DATE: Friday Nov 6, 2020
For the following case study specifications, construct a database schema (table / field
definitions, with primary / foreign keys clearly denoted).
After you have constructed your schema, use MS Access to create the appropriate tables, fields
and relationships …
1. For each table, specify appropriate field data types / sizes.
2. Set appropriate primary keys.
3. Create relationships between entities as appropriate.
4. Add the data from the reports above. Every piece of data outlined in the reports should be
represented somewhere in the database.
The Carrefour Department Store uses a database to keep
track of their inventory, suppliers and employees.
Use the following reports to give you clues about the design and
structure of the database tables.
