Database Systems CMP4010B

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.

iuww520iuww520iuww520iuww520iuww520iuww520iuww520iuww520

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.