AIMS AND OBJECTIVES:
to convert the ER/EER model into a relational data model;
to implement a relational database system (using ORACLE12g).
This is an individual Assignment. You are not permitted to work as a group when writing this
Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives
the impression that the work is your own. The Department of Computer Science and Computer
Engineering treats plagiarism very seriously. When it is detected, penalties are strictly imposed.
No extensions will be given: Penalties are applied to late assignments (5% of total assignment mark
given is deducted per day, accepted up to 5 days after the due date only). If there are circumstances
that prevent the assignment being submitted on time, an application for special consideration may be
made. See the departmental Student Handbook for details. Note that delays caused by computer
downtime cannot be accepted as a valid reason for a late submission without penalty. Students must
plan their work to allow for both scheduled and unscheduled downtime.
This assignment is to be submitted in soft-copy (.pdf, .txt or .sql) formats using the
submission link on LMS by 10:00am Monday September 23rd, 2019. The submission
link can be found under “Assignment 1 –Part 2” on the subject’s LMS page.
NOTE: This assignment must be typed and no hand-writing is allowed.
The transformation steps from the EER Model shown in Appendix A to final tables (Task 1);
Make sure to show each step of the transformation, and the final transformation tables;
The DDL implementation for the ‘Natural Therapy Centre Database System’ tables from Task 1
(create table statements), and the required insert statements (Task 2a and 2b respectively).
Students are referred to the Department of Computer Science and Computer Engineering’s Handbook
and policy documents with regard to plagiarism and assignment return, and also to the document on
‘Academic Misconduct’ in the subject learning guide.