Database Application Development
You have been sub-contracted to design the database system for Southern Academy. Southern Academy is a
private tutorial service that runs evening classes for students. The main purpose of the classes is to give
additional tuition to students outside of their normal school hours, in preparation for their exams. Students are
classified by type which includes: Self Financed, Sponsored, Remedial or Referred. Students are assigned to
one or more classes. Each class is for a particular subject and exam. An exam is either Local or Global. A local
exam carries a School-based Assessment. Each class is assigned at least one teacher. A teacher may teach
more than one class. The subjects and levels a teacher is qualified to teach would be listed by the teacher’s
record. Each class is allocated a room in one of three buildings that Southern Academy currently rents. In the
future, they are hoping to expand their business to rent more buildings and therefore run more classes. For
each term, there is a fixed registration fee of $500. There are three terms in an academic year. The terms are
chronologically sequenced as follows: September to December, January to April and May to August of each
year. CAPE subjects cost $300; CXC subjects cost $200. Courses offered in the third term are offered at a
discount of 10% of the total tuition for that period. Students are allowed to take both CAPE and CXC subjects
within a single term. Requirements of the Coursework Marks are awarded for producing a working and properly
documented system that meets the requirements specified below. Furthermore, these marks are conditional on
the timely working demonstration provided by you. The requirements are: An entity relationship model for the
system A set of fully normalised tables for the system You may use Figure 1, 2 and 3 as a starting point for
normalisation. You may also add additional attributes where appropriate. A data dictionary for the system
Creation and population of the tables for the system, based on your normalisation outcome, using Oracle
SQL*P