1. Directions for the Problems. The exam consists of three problems. Draw a conceptual data model to model the scenario in each problem. Use the model constructs (e.g., the material on the E-R model and the enhanced E-R model) from chapters 2 and 3 as appropriate and follow the modeling conventions used in the example problems in the online lessons. Do not use the modeling conventions shown in Figure 2-22 of the Hoffer textbook which illustrate a data model in Visio notation. Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models.

Charleston Counsulting Services employs two types of Consultants: Salaried Consultants and Contract Consultants. Attributes of Salaried Consultants include ConsultantID, ConsultantName (composed of FirstName, MiddleInitial, and LastName), Address (composed of StreetAddress, City, State, and ZipCode), DataOfBirth, Age, AreasOfExpertise, and Salary. Many SalariedConsultants have more than one area of expertise. Attributes of ContractConsultant include ConsultantID, ConsultantName (composed of FirstName, MiddleInitial, and LastName), Address (composed of StreetAddress, City, State, and ZipCode), DateOfBirth, Age, AreasOfExpertise, and HourlyCompensation. Many ContractConsultants have more than one area of expertise. Consultants are either SalariedConsultants or ContractConsultants, but not both. There are no other types of Consultants. Consultants are assigned to Client Engagements. Attributes of Client Engagements include ClientEngagementID and Description. Consultants can be assigned to many Client Engagements and must be assigned to at least one Client Engagement. Client Engagements have at least one Consultant assigned and may have many Consultants assigned. The DateOfEngagement is tracked for each Consultant assigned to a Client Engagement.