The assignment comprises designing and prototyping part of a database systems application. Students should form themselves into groups of up to 4 members and pass details of the members of their group to the course leader.
In implementing their designs students will use the ORACLE Product SQL*PLUS
The list of products to be handed in on or by the hand-in date is as follows:
a) The database design(entity relationship model plus supporting narratives including any assumptions made)
b) A relational schema which comprises listings of table definitions clearly identifying primary and foreign keys.