Question

You will create an Microsoft Access School Management System Database that can be used to store, retrieve update and delete the staff/student.

Design an Access database to maintain information about school staff and students satisfying the following properties:

1. The staff should have the following: ID#, name, and classes they are teaching

2. The student should have the following: ID#, name, section, class

3. Create a module containing the section, subject and teacher information

4. Create a module containing student fee information

5. Create a module containing the instructors salary

6. Create a module with the classroom assignments (be mindful that each class/lab should not have the same information as another class)

Answer 1

Here is the design for the School database tables, In Microsoft Access Database management system: