Milestone Three.docx - 1 IT 204 Milestone 3 IT 204...

This preview shows page 1 - 4 out of 5 pages.

1IT 204 Milestone 3IT 204 Milestone 3Brittney JaraSouthern New Hampshire University
2IT 204 Milestone 3RequirementsBirchwood Lane School currently uses a very manual method to record all student data. Birdwood Lane School has been tasked with setting up a database that can manage all of their data electronically, instead of on paper. Not only is this required at state and federal level but willprovide many benefits to Birchwood Lane School. An application will have to be developed to house all student, instructor, and course data. A Gap Analysis will also have to be performed to understand Birchwood’s current position and what their end goal is. A database management system (DBMS) will be implemented to meet their requirements and goals. Business Case and Gap Analysis InformationBirchwood Lane School currently has a manual process for recording all student data; everything is recorded on paper and kept in files. The following data is recorded in each student file: name, address, phone number, email, date of birth, enrollment date, graduation date, coursestaken, and courses currently enrolled in. The following data is recorded in each teacher file: name, address, phone number, email, date of birth, hire date, courses taught, and courses currently assigned to. The following is recorded for each course data: course name, course start date, course end date, course category, instructor, and student listing. All this data is stored in filing cabinets in paper files. The files are not stored in a secure room, leaving Birchwood at risk of losing information. By keeping paper files, there is also a big risk for human error and consume a lot of time managing the files (putting files together, completing necessary paperwork, etc.). Finally, in the event a file or any data goes missing or is destroyed, there is no way to recover the data.
3IT 204 Milestone 3Birdwood transitioning to a paperless system will provide them with many benefits. A DBMS will have a positive financial impact on Birdwood Lane School. Using a relational database allows for low costing servers that are strong enough to contain the amount informationthat is required. Having the ability to store massive amounts of data will provide Birchwood withthe capability to search for information within a short amount of time instead of shuffling through files for a file. This reduces the amount of time and money spent on employees sifting and sorting through a large number of files looking for one piece of information. All data will be secured and separated from one another, so there is no chance of data being misfiled. Business Case and Gap Analysis Additional InformationShould Birchwood decide that additional information needs to be added to the database, this can be done at any time. The information would allow Birchwood to produce and find data in a more efficient and effective way. This information can consist of student medical records, student future course planning, and test results/data for future educational requirements. The current manual process requires that all information is recorded on paper and stored in files that need to be sorted, filed, and labeled accordingly. With a DBMS, the labels can be edited at any time by using an SQL setup. Keeping track of any and all additional information will be fundamental for the future of Birchwood Lane School. As years go on, Birchwood can run reports of all data to determine if any further information is needed or if any clean-up is required.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture