IT204 - Final Proposal - Running head BIRCHWOOD LANE...

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

Running head: BIRCHWOOD LANE SCHOOLS DBMS Final Project: Birchwood Lane Schools DBMS Proposal Catherine Garyson Southern New Hampshire University IT 204: Introduction to Data and Information Management
Running head: BIRCHWOOD LANE SCHOOLS DBMS Birchwood Lane Schools DBMS Proposal Birchwood Lane Schools is in need of a assistance to meet state and federal requirements for schools. Current state and federal requirements include an application system that records all student, course, and instructor data electronically. The best way to accomplish this task first requires a comprehensive database management system (DBMS) model to ensure all necessary data is included. Following thorough analysis of the needs of the Birchwood Lane School System, the following report includes recommendations to fully implement the system. Business Needs The administration has indicated the current data needs that must be included. For students, the following need to be included: full name, full address, phone, email, birthdate, enrollment date, graduation date, courses taken, and courses currently enrolled in. This information will need to be kept up to date and will all be attributes for the student entity. For the entity instructors, the following attributes are necessary: full name, full address, phone, email, birthdate, hire date, courses taught, and courses currently assigned. And finally, the following attributes 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 in order to pull up transcripts for students and to aid in scheduling of courses with the appropriate instructors. It is also necessary in order to properly maintain communication between schools and 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 additional attributes 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 up reports on each student, to see what courses they still need to take would allow a comprehensive
Running head: BIRCHWOOD LANE SCHOOLS DBMS academic learning plan to be stored and followed. Prospective colleges also seek out information from schools regarding students and the additional attributes would allow that information to be readily found and reported. It would also be useful for the database to contain unique IDs for students, courses, and teachers.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture