Database Design ScenarioCurrently a school uses a non-computerized database system to store the following information about its students: class, last name, first name, guardian's name, address, student's date of birth , gender, home sports, emergency telephone number, postal name, list of subjects offered and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicate entries, some of which contain errors, and searching takes a long time. The school intends to introduce a relational database management system to overcome these problems. The current school data storage and retrieval system (the pre-computer database system)„h School staff, teachers and office staff are the users of the database.„h Database used to keep track of all details of students in the school.„h Large amounts of data are stored. An individual record is required for each student.„h There is a lot of duplication as details of the subjects offered by the school are duplicated on individual student records.„h The data is organized alphabetically on student names by year.„h The data are stored in numerous filing cabinets.Advantages„h quickly find a student's details if year and surname are known„h data is stored in a secure central location„h original material is stored in the student's folder.Disadvantages„h slow to find student details when surname and year are not known„h data storage takes up a lot of space„h a minimum number of employees can access documents at the same time„h data is duplicated.Development stages of computerized relational database systemThe new system of computerized relational database will be developed in the following phases:„h analysis„h design„h implementation„h maintenanceAnalysisIn this phase the current system is analyzed to determine the functions it performs and those it is unable to perform. Direct and indirect users of the new system are interviewed to determine what they require from the new system. The inputs of the new system, the processes it must perform, and the outputs of the system are clearly defined. A recommendation is made on the type of new system that will be needed to meet the identified needs. During the analysis phase, the following is determined:„h current storage space for student records must decrease„h an easily updateable backup of student records is required,"h a staff member must be responsible for system administration,"h unnecessary duplication of data must be avoided,"h all teaching staff, office staff and the principal must have access to the database at the same time: only read access is required