CC4057 Course Study DB

Tasks

• Construct a data model for the persistent data
• Specify a data dictionary for the database
• Implement a database
• Populate the database with test data
• Design database queries
• Implement forms for entering data into the database
• Implement reports for presenting information stored in the database
• Write a report to present the work

Requirements

1. Model

• The model must be relational with at least 4 different relations (tables)
• Each relation must be identified using suitable primary key
• The relations must be described using suitable attributes (columns)
• The attributes could be constrained using suitable constraints (i.e., unique, not null, equal/not equal to, greater/smaller than, later/earlier than, etc.)
• The relations could be interlinked using suitable pairing of foreign keys/unique keys
• The model must be illustrated using suitable diagram (i.e., entity-relationship diagram or data diagram produced using a graphical editor or directly using MS Access)

2.Data Dictionary

• The data dictionary must specify the entire schema of the database
• Each table specification must describe its columns using information about the name, data type and constraints as well as its role in the table (i,e., primary key, unique key, foreign key, indexed field, hashed field, etc.)
• The data dictionary must be presented in a suitable format (you can draw a table using Word or other editors, or you can take a screenshot in Design View of Access)

3.Database

• The database must be stored in a single MS Access file named using combination of the code of the name of the student and the Student ID (i.e., johnA123456789)
• The database must include both the database tables of the database and the database forms and database reports created by the student

4.Test data

• Each table in the database must include at least 5 records of data in it

5. Queries

• Each student must design at least one query for entering data and implement at least one form for entering data into one table

6.Database forms

• Each student must design at least one query for storing data and implement at least one form for entering data into one or more tables

7.Database reports

• Each student must design at least one query for retrieving information from one or more tables and implement at least one report for presenting it

8.Written Report

• Each student must prepare one written report to present the data model, data dictionary and database implementation as well as to test database data and the implementation of the database forms and reports
• The report must include a reflection on the work
• The report must be named using the ID of the student (i.e, 123456789.pdf)