This assignment focuses on Database Application Development. Paper details: 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.

Database Application Development.

Paper details: 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.

Database Application Development.

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.

Database Application Development.

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: q An entity relationship model for the system A set of fully normalized tables for the system · You may use Figure 1, 2 and 3 as a starting point for normalization.  https://youtu.be/2NZSa1rch3U

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 normalization outcome, using Oracle SQL*Plus.

Additional Files