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.


Related Questions in computer science category