Using a Relational Databases, Microsoft Access, design tables, enforce referential
integrity, add some suitable fictitious “Test” data to the tables, design and run queries to
generate meaningful information from the stored data.
Take screenshots of your database and arrange them in PowerPoint or Keynote file to
showcase your work. Export as a PDF.
Submit both the ACCDB and PDF file to Canvas ASG2.

A. Save your database file.
1. Save your database file with suitable filename, as shown above.
Note: MS Access databases, like all databases, need their files to be saved to disk,
before you can start doing any work on them.
B. Create Tables
1. Create tables (entities)
a. Minimum of 2 base (blue) tables (extra 2 base tables gains more marks)
b. Minimum of 1 intersection (yellow) table (extra 1 intersection table gains more marks)
c. Minimum of 2 supporting (red) tables (extra 2 support tables gains more marks)
2. Create fields (attributes)
a. Use CamelCase for the field names
b. Set fields to an appropriate data type
c. Set the appropriate field(s) as the PK for each table
d. Add comments to identify the FK(s) in each table
C. Enforce Referential Integrity
1. Add your tables to the Relationship Window
2. Joint the PK of the parent table to FK in the child table
3. Enforce Referential Integrity to create the 1:m join.
D. Add Test Data
1. Add some fictitious, but realistic, data to your tables.
a. Data must be realistic; avoid silly repetitive data values
b. Add as few data records as possible; just enough to create meaningful
information from queries;
avoid adding copious quantities of data records that are not used by another
tables (unused data records, prove nothing)
c. You may need to attempt Part E and then return to Part D to add more data to
make meaningful information.
d. You may wish to include “incorrect” business data and prove that your queries
can identify them. (Your database does not need to prevent nor correct errors)
E. Design and Run Queries
1. Using predominantly QBE (and possibly SQL in some places) create queries that
create meaningful information from the data stored in the tables. Marks are
awarded for:
a. Display selected fields from a table
b. Join data together from more than one table
c. Sort data by select fields
d. Filter data by selected fields
e. Perform a simple calculation
f. Generate a Count or Sum of values in select querie