About Our Project
The purpose of our database is to be able to retrieve student, employee and location information from one place instead of having paper copies of files. The majority of the student information is stored under the student table. It has everything from their name, birthdate, grade, address, emergency contact information, medical history and what program time they attend. Next, we have a table for employee information which includes their name, address, contact information, which location they work at and the grade level they are assigned to. Lastly, we have a table which stores the location information including the school name, address, special amenities, and the hours of operation for the program.
Employees now have the ability to easily enter new students and update current students information in the database, because of the forms we created. These forms also allow for the employees to access information and oversee their coworkers location. The forms are designed with employee's use in mind while our reports are for the managers at each location. The reports help to keep the manager informed of what students are at their location and to keep the before and after school program running smoothly. Therefore, this database is useful for the employees and managers to retrieve accessible information about the company.
Employees now have the ability to easily enter new students and update current students information in the database, because of the forms we created. These forms also allow for the employees to access information and oversee their coworkers location. The forms are designed with employee's use in mind while our reports are for the managers at each location. The reports help to keep the manager informed of what students are at their location and to keep the before and after school program running smoothly. Therefore, this database is useful for the employees and managers to retrieve accessible information about the company.