Database normalization Essay Example

Database normalization Essay Example Database normalization Essay Database normalization Essay SMS allows users to store almost all of their schools information electronically, including information on students, employees, teaching methods etc. Most importantly, this information can be easily shared with authorized users, records can be easily searched, and reports can be easily generated. The School Management System (SMS) will replace the paper-based data collection and information exchange system among the various departments of a particular school. The School Management System provides an innovative solution for Todays school record-keeping challenges. School Management Software is a complete and customized solution for a school handling regular Management work. By going through the flow of application one can easily maintain its student detail, fees detail, Employee detail, Certificate details, exams and Transportation Detail. SMS has most of the facilities that a modern school requires to computerize its day-to-day jobs. It provides facilities to keep the records of student, fees, teaching and non-teaching staff with all their required details along with all required transaction handling. It has facilities to generate various types of reports. The school management software will give you opportunity to handle your responsibilities whether youre just starting or are an experienced professional. Background of the project: Nordic secondary school was built April ninny harasses city, the capital Of Somalia Nordic secondary school is located behind the gulags hotel and near the farmer colonial statehouse in the red sea area of harass access roads that lead to the entrance of the school are many but never toeless, two important roads come from both east and west of the school. Nordic secondary school consists of 13-classrooms, a library and two office-rooms and one room for the security guards. There is a can-teen for students a very large playground, ten separate toilets and two water tanks for the use of male and female students and staff members. To complement the structures, is a tall concrete, perimeter fence built around the whole complex. The large, steel entrance and exits gate is not meant to keep a way intruder but to create an appropriate environment that is conductive to learning/teaching atmosphere. The full capacity of the school is planned to provide learning space to 1100 students of both sexes, who are expected to undertake their secondary studies in two different shifts during the morning and afternoon. Graduates of Nordic Secondary School will be certified successful only when they pass the SEC (Somalia General Certificate of Education). Nordic School has the following admission rules: completion of grade 8 primary school and submission of testimonials from Somalia ministry Of education in regard. TO be accompanied by parents or responsible guardian, during registration and signing of necessary admission forms. Why we need School Management System? If you want to search a students record in 2 seconds, you need SMS. If you want to know which classroom is used by which class, you need SMS. If you want to know who is teaching whom, you need SMS. If you want to print students semester statement under a minute, you need SMS. If you want to print new semester information letter under a minute, you need SMS. If you want to view a class timetable in less than 5 seconds, you need SMS- If you want to know where your properties are and how much theyre worth, SMS. If you want to automatically send emails or short text messages to students parents if something happens, you need SMS And many more Problem statement: Nora din secondary school uses a manual system which can be difficult to manage schools information including information on students, employees, teaching methods etc. Storing documents and other information like reaching takes time that will reduce time consuming also it needs a lot of human activities and that will increase the employees of the school. Due to the increase of students recently, the administration of Nordic Secondary School faced a difficulty and disorganized work from registering students, student payments, staff registration, buss registration, following students exams, giving reports to the parents and students. This slowdown gives us the opportunity to realize the necessity of a new computerized system in order to reduce the errors, inefficient work, and irresistible work load from the employees and the school management. These problems that we mentioned above are the major problems that need to solve in any way that it can be solved we will try to solve part of them. Project Scope: This project will handle all the problems of the school in computerized system Student Management : Based on Students from Secondary level a) Student Personal Details b) Pass / Fail Entry Fee Management : Based on Day Wise and Fixed a) Fee Configuration b) Monthly Fees Collection Report Generation a) Reports about the students b) Reports about student like(student list by class wise , ,and same address etc) c) Report for the parents like ( student grades, exam results etc) d) Information can be easily shared with authorized users, records can be easily searched, and reports can be easily generated. ) Handling the admissions process f) Handling records of examinations, assessments, marks, grades and academic progression. We will try our best to present the information effectively. Goals and objectives of the project: This project is based on the RAIDS technology; the main objective of this project is to computerize the manual system reduce the time consumption. In othe r words we can say that our project has the following objectives:- Make the system computerize. Easy to get information like (registration, payment fees, exams, grade reports, and many other valuable information) Of a student. Reduce time consumption. Reduce error scope. All system managements are automated. Centralized database management. Easy operations for operator of the system. Storing documents and other information like searching is much easier. No paper work requirement. It will be easy to track expenses and verify every expense and where it comes from Validation rules can be used in order to ensure better verification. No need more stationary. All process can be done automatically as you enter data. You do not have to do the same task over and over again. There will be a centralized database which is suitable at the time Of decision making. We will try our best to present the information effectively. Resource requirement of the project: Hardware: Processor Processor Speed Hard Disk Space Ram Memory Operating System Windows Server MAD Semipro 533 MAZE 20 KGB (mm. ) 64 MBA software: Win 7/Vista/XP Database SSI Server 2005 Front end Visual Basic 2008 1 Literature Review: As we know there are so many project of school management system that solved the manual system into computerized system. Here are some of school management systems and what kinds of the problem are solved: 1: school management system software version 1. 2. 1: This software covers the major tasks of the school including information on students, employees, teaching methods etc; SMS allows users to store almost all of their schools information electronically. 2: school management system version 2. 4. 4: New reliable and fast school management software with the great customers support. Itll help you with your daily school management routines and deliver you from your paperwork. Standard Edition is free. 3: School Management System Version 3. This School Management System aimed to provide complete computerized operations in any school. Students can be managed, Attendance, Fees, Examination, Leaving modules. Staff records can be computerized Staff Salary > Leaving modules. Accounting module is integrated with all other modules to getting rid of transaction duplication. 4: E-school Management System: Is a com prehensive web-based School Management Software. It is designed for better interaction between students, teachers, parents management. This management software very gracefully handles all The requirements for easy school management. The software being web based can be accessed from any;OHare in the world, which enables the students, teachers, parents the management be in touch with each other at all times. 5: Online School Management system: This school software management system is available in a wide variety, in terms of size, capability and scope. These packages can meet the requirements of small institutions to huge universities very effectively. Even if a smaller system is purchased, it can be updated to a more efficient and modern version by purchasing add-on modules. Some of the most common functions performed by these awesome machines include- handling the recess of administration, effectively handling any student related inquiries, storing choices for different modes of teaching, enrolling new students, creating teacher and class schedules, providing statistical data, maintaining discipline records, keeping record of communication made with the students, recording examinations, assessing the marks, grading each student based on the marks, keeping track of academic progression, recording health status of students, communicating with the parents about the progress of their wards through a parent portal, providing individual education plan or any special education programmer, recording accounts, doing human resources and budgeting services, maintaining details of boarding house, and many more. This school management system software is different from all of this software which Can solve the internal and external of the school data and can easily re trievable any information including student details ,employee information ,teachers ,and all members of the school in other words we can say it is user friendly . System Analysis: System Analysis is the process of gathering and interpreting facts, diagnosing problems and using the job description to recommend improvements to the equines activities. The system analysis is performs this job. Analysis specifies what service should so. It is about understanding or to know the problem of the school, then we have to solving problems. Project methodology approach: The systems development life cycle (OSDL) is a conceptual model used in project management that describes the stages involved in an information system development project, from an initial feasibility study through maintenance of the completed application. The waterfall model which was the original OSDL method, the methodology that will be applied for implementing this system is waterfall method. We will use an interview to gather data and tools such as the data flow diagram and E-R diagrams to represent data flow of the system. Requirements Determination: We used an interview to know about the Nordic secondary school and how it works and the system of work that they use. Interview Questions: 1: What type of a system you use? 2: How work is done now in this manual system? 3: What are problem you faced with the existing system? 4: If your system is manual would you like to revolutionize computerized system? 5: What are the rules to follow for a joining the school? What is first step you take when new student transfer from another school? 7: How you record the student information? 8: What are the requirements of the new student? 9: How many books used to record the data of the school? 1 0: Is there any student does not pay a fee? The Eth os of Nordic School: Be fostering an environment conducive to a cadmic achievement on a God- Conscious basis, we aim for our students to: Be god loving and fearing. To achieve the highest academic standard integrated with strong morals values. Develop maintain report, obedience love towards his her parents, teachers elders. Condemn hypocrisy, revenge, tribalism, envy hatred of others. Attain work satisfaction through good morals avoiding materialistic pitfalls. Remain modest, truthful, forgiving form in good conduct. Be the master not the salve of ones desires. Be content in times of misfortune not be arrogant selfish during wealth. Obtain confidence understanding in the spiritual personal community aspects of development. Existing System Preliminary Analysis: manage schools information including information on students, teachers, etc. The Normal school Activities: Student registration: To register a student, the student should complete and attend the exam of 8 classes and come with a parent or responsible person. Student payment: Student must pay the fee be;en 1 _ 5 of every month otherwise student will be taken out from the class room and bus will not pick up the student, if the student have special payment arrangement student must see the school principle or the school (cashier) to reconfirm payment arrangement, Student pays the fee each month except the holiday and must take receipt. Employee salary: The employees take their salary from the responsible person. Registration book: When the student register a book there some way or instruction to follow up so that the student can take a book. General rules for Nordic School: 1 . Attend assembly and middy prayers promptly and participate appropriately. 2. Respect school property and property belonging to others. 3. Wear clean and tidy uniforms on all occasions. 4. Remain in the school grounds unless give permission by the principal. 5. Take pride in keeping your school clean. 6. Demonstrate proper adobe I. E. Politeness in every respect e. G: eating, dressing, speech, manner, behavior, etiquette. Problem with the current system: Searching different student record, employee details and other information are difficult and time consuming. The main problem faced by the employees is the difficulty to access the student record, employee details for various needs. For example if the parent needs to see the grade of a student he/she would have to go through all of exam record in that class one by one. This is a tedious (trouble) task employee feel De-motivated in repeating such tasks: Time-consuming: Nora din secondary school have many problems to get information like (registration, payment fees, exams, tests, grade reports, and many other liable information) of a student and other staff like teachers. Lack of immediate retrievals: The information is very difficult to retrieve and find particular information like:-To find out about the student record, the user has go through various registers, this results in inconvenience and wastage of time. Have to check many times: Data verification can become a strenuous task because data will have to be checked manually. Checking data manually can be very time consuming as well as boring so this adds to the fact that time is wasted and employees become De-motivated. To ensure that data is as accurate as possible the employees dealing with data verification has to go over their work over again this means that it causes repetition of work. Need of extra manual effort: Storing documents and other information like searching takes time that will reduce time consuming also it needs a lot of human activities and that will increase the employees of the school. Unnecessary costs are involved due to paper usage all tasks have to be done in paper so they are wasted unnecessarily due to the large scale repetition of work. If a mistake is made in any point of the existing manual system, all the work which was already done y hand has to be redone. This means that lager the amount of mistakes made larger the rate of the wastage of papers. Proposed System: The proposed system of Nora din Secondary School uses manual system and Provides detail general information about the employee details, The Administrator should report with the personal holding the necessary report required for the project the decision in making analysis about the students skills is a prime important before working in. It will be able to manage and control information about School in more user friendly way.