100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 4 out of 10 pages.
Running Head: BIRCHWOOD LANE SCHOOLS PROPOSAL 1Final Project: Birchwood Lane Schools ProposalSouthern New Hampshire UniversityBusiness Case
BIRCHWOOD LANE SCHOOLS PROPOSAL DRAFT2In order to meet state and federal record-keeping requirements, Birchwood Lane Schools must update their processes to include electronic record-keeping. Currently, Birchwood Lane Schools is still utilizing the outdated paper method of record-keeping. As it stands today, all personal information of students and faculty is recorded on paper and filed away. With the current process, anyone could potentially access the personal identifying information of students.This outdated method poses a risk for identity theft for students while also wastes time, resources, and leaves too much room for error. A new record-keeping application must include all pertinent data for students and instructors. To complete this task in most efficient way a comprehensive database model will need to be developed. This model will allow for streamliningthe current process while also ensuring that all necessary data is included.The Birchwood Lane school administrators have provided the details on what information should be included in the new system. The following information must be included for students: full name, complete address, phone number, email, date of birth, enrollment date, tentative graduation date, courses completed, and courses currently enrolled. All information willhave to be constantly updated and will be characteristics for the entirety of the student body. As for the instructors, the following attributes are required: full name, complete address, phone, email, date of birth, date of hire, and assigned courses. The following data will also have to be loaded for courses: name, instructor, students enrolled, start and end date, as well as the category.This new DBMS could be a tool to simplify the lives of administration and teachers of the Birchwood Lane Schools by providing one platform for everyone to use and therefore share witheveryone across the board. The benefits of updating the record-keeping method are many. The first benefit is that of time savings. Teachers and administrators will have the benefit of recording all pertinent student
BIRCHWOOD LANE SCHOOLS PROPOSAL DRAFT3information into the system and being able to access it at any time. Another significant benefit is financial. After the initial setup, maintenance costs are low, and the cost of paper supplies should dwindle. The use of a relational database to maintain all student records will allow Birchwood Lane Schools to purchase servers that are cost-efficient and capable of handling the data necessary. A relational database would also enable the schools to record more information about students, classes, and schools beyond local, state, and federal guidelines. A relational database