95%(91)86 out of 91 people found this document helpful
This preview shows page 1 - 4 out of 9 pages.
Running head: BIRCHWOOD LANE SCHOOLS DBMSFinal Project:Birchwood Lane Schools DBMS ProposalCatherine GarysonSouthern New Hampshire UniversityIT 204: Introduction to Data and Information Management
Running head: BIRCHWOOD LANE SCHOOLS DBMSBirchwood Lane Schools DBMS ProposalBirchwood Lane Schools is in need of a assistance to meet state and federal requirementsfor schools. Current state and federal requirements include an application system that records allstudent, course, and instructor data electronically. The best way to accomplish this task firstrequires a comprehensive database management system (DBMS) model to ensure all necessarydata is included. Following thorough analysis of the needs of the Birchwood Lane SchoolSystem, the following report includes recommendations to fully implement the system.Business NeedsThe administration has indicated the current data needs that must be included. Forstudents, the following need to be included: full name, full address, phone, email, birthdate,enrollment date, graduation date, courses taken, and courses currently enrolled in. Thisinformation will need to be kept up to date and will all be attributes for the student entity. For theentity instructors, the following attributes are necessary: full name, full address, phone, email,birthdate, hire date, courses taught, and courses currently assigned. And finally, the followingattributes are needed for the course data entity: course name, course start date, course end date,course category, instructor, and students. This information must be included in the records inorder to pull up transcripts for students and to aid in scheduling of courses with the appropriateinstructors. It is also necessary in order to properly maintain communication between schoolsand students, as well as between colleges that may be seeking information regarding students.In order to avoid needing to further alter the system in the future, there are additionalattributes that would be beneficial to include. For students, cumulative grade point average,courses needed, and clubs/sports would allow further benefits to the school. When pulling upreports on each student, to see what courses they still need to take would allow a comprehensive
Running head: BIRCHWOOD LANE SCHOOLS DBMSacademic learning plan to be stored and followed. Prospective colleges also seek out informationfrom schools regarding students and the additional attributes would allow that information to bereadily found and reported. It would also be useful for the database to contain unique IDs forstudents, courses, and teachers.