Birchwood Lane School Proposal
Allison McLeod
Milestone Three: Birchwood Lane Schools DBMS Proposal
IT 204
March 26, 2022
Birchwood Lane School Proposal
Birchwood Lane Schools have received state and federal guidelines stating that their
current information system, paper filing, must be updated into a database management system
The school system is in desperate need of an update and requires guidance on how to proceed
with the change. The Birchwood Lane Schools will need a database that allows staff, students,
and parents to access in real time to better track their students and enhance the education
experience. Currently the schools are using a paper filing system which is time consuming and
prone to human error.
Birchwood has identified the key requirements that will be needed to optimize the
performance of the DBMS for them. They will need three tables including a student table
including the student's full name, current address, phone, email, birthdate, enrollment date.
graduation date, past courses, and current courses. The instructor table will need to include the
following data, full name, full address, phone email, birthdate, hire date, past course taught, and
current courses. Finally, they will need a courses table that includes the following data, course
name, start date, end date, category, instructor assigned currently, enrolled students. Birchwood
understands that student and teachers' information can change.
Additionally, for better integration I would add in the tables a student ID, instructor ID
and course ID. These will allow the end users to easily pull the information and input students
and instructors into specific courses without having to input their names every time. These IDs
will be a unique identifier for the individuals and courses that will allow the end users to modify
and search faster and create a more productive work environment. As well, I will suggest
implementing security measures within the tables so the end users can apply restrictions that
prevent anyone from accessing certain data. Also, having a parent portal will allow parents and
instructors to communicate in real time.
Birchwood Lane School Proposal
Currently Birchwood is using a paper filing, anyone can access the information and
parents are unable to monitor the progression of their child in the course. The instructors can add
comments and grades. During my real world research, I found that having a parent portal
capability is extremely beneficial and strengthens the parent/instructor relationship. By
implementing this new DBMS Birchwood will not only comply with the state and federal
requirements but better the educational experience for all
I would recommend that Birchwood use Oracle, while using MySQL is a very reliable
and easy database to implement. Oracle allows for more complex features.
Below is my proposed relational database model:
Student
Student ID (Primary Key) FullName
FullAddress
Phone
Email
DateofBirth
Enrollment Date
Pastcourses
CurrentCourses
Instructor Instructor ID (Primary Key) FullNam