database design :: essays research papers

Database DesignScenarioCurrently a naturalize uses a non-computerised informationbase system to store the following information round its students roll class, byname, first name, guardians name, address, students date of birth, gender, sport house, emergency-contact telephone number, mailing name, hark of subjects offered, and subjects in which the student is enrolled. The system takes up a large hail of space, has many duplicated entries some of these with mistakes and it is time consuming to search. The school intends to introduce a relational-database management system to overcome these problems.Current school data memory board and retrieval system (the pre-computer database system)h School round, t each(prenominal)ers and office staff ar the users of the database.h Database used to track all details of students in the school.h Large amounts of data are stored. An individual record is ask for each student. h Lots of duplication exists as details of subjects offered by t he school are duplicated on individual student records.h Data is organize in alphabetical order on student names in spite of appearance twelvemonths.h Data is stored in a number of filing cabinets.Advantagesh quick to find details of a student if year and surname are knownh data is stored in a fundamental secure locationh original source material is stored in the student file.Disadvantagesh slow to find details of students when surname and year are not knownh data storage takes up a lot of roomh minimal number of staff can access records at one timeh data is duplicated.Stages of development of the computerised relational database system The hot computerised relational database system leave alone be developed in the following stagesh analysish designh implementationh maintenanceAnalysisIn this stage the veritable system is analysed to determine the functions it performs and those that it is unable to perform. Direct and collateral users of the new system are interviewed to dete rmine what they require from the new system. The inputs to the new system, the processes it is to perform and the outputs from the system are clearly defined. A recommendation is make about the type of new system that will be required to meet the identified contains.During the analysis stage, the following is determinedh current storage space of student records needs to decreaseh an good update-able backup of student records is required, h one staff member is to be responsible for the administration of the system, h unnecessary duplication of data is to be avoided, h all teaching staff, office staff and the Principal need to have access to the database simultaneously - read access only is required