Question

The software maintains and manages information related to employees, rooms, committees, and committee meetings of a company. The information
include at least the following data:

1. Employee: IDNumber, Full Name, Office Location, Telephone Number, Department, and Position.
2. Employee’s Schedule: Date, Start Time, End Time, and Task .
3. Room: Building Number, Room Number, and Capacity.
4. Room Schedule: Date, Start Time, End Time, and Status.
5. Committee: Title, Chair’s Name , Chair’sIDNumber, and Members.
6. Committee Meeting: Meeting Number, Date, Start Time, and End Time.

Answer 1

The software maintains and manages information related to employees, rooms, committees, and committee meetings of a company

Explanation:

• Below is the ER diagram to represent the employee database.
• It shows the relationship between the various sectors.