Specification Overview

Aim:

To implement part of a database application by first completing the database table 

definitions, then writing interactive SQL statements. 

Coursework Description

See Attached at Page 4.

Relationship to Formative Assessment

All SQL Labs build towards this exercise, with each lab helping you to perform 

Transactions of Interest that contribute to building this solution. Labs include 

expected query results so you can ensure you get correct answers and perform a 

form of self-assessment.

Summary of Deliverables

Part 1: A copy of your SQL data definition statements and test data should be 

produced and submitted electronically.

Part 2: Your SQL statements for each of the Transactions of Interest should be 

produced and submitted electronically together with evidence of testing for each 

statement on your own data and assessment data. There will be two documents –

one with your own data and one with the assessment data using the assessment 

template. The Assessment Template file issued nearer the submission time (48 hours
prior to  submission deadline). 

Resources

The necessary materials are in the lecture notes/lab materials. Links to relevant 

PosgreSQL help pages are in the lecture slides. Recommended books in reading list 

are also useful.

Assessment criteria 

• Good use of SQL data definition language to complete the table definitions;

• Good use of SQL data manipulation language to write interactive queries; 

• Ability to interpret project specification correctly and accurately. This may 

include a little bit of independent thinking on what may make a table/report 

look good;

• Correct functionality and output as required by each requirement; 

• Neatly presented work with correct program output in the assessment 

template; Sufficiency and completeness of Submitted code and tests data. 

Plagiarism, Collusion, and Contract Cheating

The University takes academic integrity very seriously. You must not commit 

plagiarism, collusion, or contract cheating in your submitted work. Our Policy on 

Plagiarism, Collusion, and Contract Cheating explains:

• what is meant by the terms ‘plagiarism’, ‘collusion’, and ‘contract cheating’

• how to avoid plagiarism, collusion, and contract cheating

• using a proof reader