95%(37)35 out of 37 people found this document helpful
This preview shows page 1 - 4 out of 9 pages.
Rahm, SarahIT 204: INTRO TO INFO AND DATA MANAGEMENT | FALL 2016Database ProposalIMPLEMENTATION PLAN
I.Case Needs Analysis In order to properly design a functional database for Birchwood Lane Schools the following demographic data will be needed from the students, instructors and courses:Student data: Student identification number, full name, birthdate, address, phone number, email, enrollment date, expected graduation date, courses previously taken, courses currently enrolled. In addition to demographic data, additional data regarding special programs (504, At Risk status, SPED…etc) and parent contact information will be beneficial to complete the student profile and allow specific reports to be run to identify students who should be receiving government mandated accommodations. By having a database of courses previously taken and currently enrolled for each student, Birchwood Lane Schools could effectively map out a 4 year graduation plan for high school students to ensure graduation requirements are achieved. Instructor data: Instructor identification number, full name, address, phone number, email, birthdate, hire date, courses previously taught and courses currently assigned. As is the case with the student demographic data, the instructor data is necessary for contact purposes in the event ofan emergency. Having record of the courses previously taught and currently assigned will also ensure the instructors are assigned in the correct departments according to their certifications. This would require including the additional data of instructor certification title and expiration dates, to ensure the district is compliant with teaching regulations. Course data: Course identification number, course name, course category (department), semester being taught, instructor, students. Additional information would include pre-requisite courses, available seats, seats used, room assignments. The course data would be the backbone ofa scheduling system and with thfe inclusion of available seats, the database would eliminate the
possibility of overcrowding classes. The room assignments would also ensure there would be no