Question

Draw an ER diagram using the IDEF1X Notation and ERWIN for the following two applications. .If you discover that the following narrative is incomplete, make up reasonable explanations to complete the description. State clearly your assumptions. Your assumptions should not contradict the assumptions stated in the narrative.

1.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:

Employee: IDNumber, Full Name, Office Location, Telephone Number, Department, and Position.

Employee’s Schedule: Date, Start Time, End Time, and Task .

Room: Building Number, Room Number, and Capacity.

Room Schedule: Date, Start Time, End Time, and Status.

Committee: Title, Chair’s Name , Chair’sIDNumber, and Members.

Committee Meeting: Meeting Number, Date, Start Time, and End Time.

Answer 1