Coursework
The important characteristic of the coursework is that it consists of a single exercise which links together most of the material taught about database systems. The students must design and build a database, adding a Java application at the end and produce a well structured report.
The exercise breaks down into the following parts:
- Design The student must produce an ER diagram of the database
- Implementation The ER diagram must be turned into a set of tables stored in Oracle.
- Querying There must be a set of queries exercising SQL to the fullest, some of which are usable as views.
- Other aspects There must be a set of user roles and associated privileges. There must also be a small set of useful indexes.
- Report The report starts with an introduction suitable for a non-technical customer and produce appendixes listing the data and the work described above.