INF3703 DATABASE II Assignment 2

INF3703 DATABASE II Assignment 2 (UNIQUE NUMBER: 899353) By I _ (name and surname) (ID number) hereby solemnly give my word that:  The project I am submitting today is my own work. Page | 1  I have not received assistance in the preparation of the project.  The project or any parts thereof do not correspond exactly with those of other learners or published/unpublished websites developed by a person other than myself. Should it be found that the statement you have made here were not truthful you will receive 0 (zero) for you project and disciplinary action will be taken against you. Signed _ on the 19 th day of June 2022 at _ (place). Table of Contents 1. OutCome1:................................................................................................................5 1.1. Describing the organisation situation..............................................................5 Page | 2 1.1.1. Vision............................................................................................................5 1.1.2. Mission..........................................................................................................5 1.1.3. Business Objectives....................................................................................6 1.1.4. The School organisation structure............................................................7 1.2. Possible Database systems (different from those listed above) that would be required to operate a primary school...................................................................8 1.3. Defining Problem and Constrains identification.............................................8 1.3.1. Challenges facing the organisations.........................................................8 1.3.2. Project constrains.......................................................................................8 I. Project objectives...............................................................................................9 II. Project Scope and boundaries......................................................................9 2. Outcome 2.................................................................................................................9 2.1. Information collected and processed..............................................................9 2.1.1. School start up business plan.................................................................10 2.1.2. Interviews with the Mrs X..........................................................................10 2.1.3. Primary School Market Analysis..............................................................10 2.1.4. The Primary schools in my area..............................................................11 2.1.5. Services of Primary schools in my area.................................................12 2.2. Business Rules.................................................................................................12 3. Outcome 3...............................................................................................................13 3.1. Database Design Approach.............................................................................13 3.2. Conceptual Diagram........................................................................................13 3.3. Logic Model.......................................................................................................14 3.4. Physical Model..................................................................................................17 Page | 3 4. Outcome 4:..............................................................................................................18 4.1. Formulate possible SQL statements for the database....................................18 4.2. Concept of concurrent control and the proposal of the most appropriate method for the designed database..............................................................................20 4.2.1. Concurrent control....................................................................................20 a. Concurrency control techniques....................................................................21 I. Concurrency control with Locking Methods....................................................21 II. Concurrency control with Time stamping methods.....................................22 III. Concurrency control with Optimistic methods.............................................22 4.2.2. Proposal of the appropriate Method for the designed database..........23 5. Outcome 5...............................................................................................................24 5.1. Develop a data warehouse model and provide a description that explains the data warehouse.......................................................................................................24 6. Question and Answers...........................................................................................25 6.1. Challenges encountered.....................................................................................25 6.2. How Can the assignment be improved.............................................................25 1. OutCome1: Page | 4 1.1. Describing the organisation situation School Name The Grace Number of Schools One school With 27 classes from grade 00 to grade 7). The classes can be increased every year as the new students enrols to the school Location Dawn Park, Boksburg, Gauteng Environment It is a private primary schools that is yet to be established and might need to operate in different areas across South Africa provinces. The school will accommodate all South African race and teach all subject in English