1)) Birchwood Lanes School will maintain personal records for all students and teachers, as well as course curricula. A new database management system can organize the data of all entities. The system will also be able to save students' academic information in respect to their course and instructor. The system should also have a feature that prevents certain users from accessing specific data. For example, a student may be allowed to examine their grades but not make changes to them. This also applies to academics, who will only have access to the data associated with the positions to which they have been appointed. The system should include the following.

Personal information for students and faculty members. (date of birth, emergency contact information, address, and medical records)

Student academic information (class schedule, grades, and attendance)

Faculty positions (office personnel, professors, and counselors)

It could also include parents having access to student records to review grades, performance, and attendance. A new database system is an effective way to keep track of records. It can improve the efficiency of managing a large student body by allowing them to rapidly resolve any course-related issues. The technology will allow teachers to control their course material, as well as the office to handle faculty performance reviews. Useful ways include many-to-many and one-to-many. This could cover the limits that users will face.