The database should accommodate all relevant data without loss of information.
computer science
Description
Coursework Part 1 Specification – Test and Trace Datab
This Coursework is an individual piece of work. All Coursework will be screened for evidence of
Academic Misconduct (e.g. Collusion and Plagiarism).
Scenario
You have been assigned to create a database to support a programmed of testing for the Covid-19 virus and tracing
contacts of infected people. The requirements are that:
• The database should accommodate all relevant data without loss of information.
• The database should follow the principles of database design. In particular, all tables should be in third normal form. A comprehensive set of integrity and domain constraints should be applied.
• The database should be populated with all of the sample data given below.
• To test the proper functioning of the database, a few SQL queries need to be written. Detailed requirements
for these are given below.
