Question: drow the EER for this below Entities and Attributes Contact Attributes: ContactID ( PK ) , Name, Salutation, JobTitle, Employer, ManagerID, SecretaryID, Address ( Home

drow the EER for this below
Entities and Attributes
Contact
Attributes: ContactID (PK), Name, Salutation, JobTitle, Employer, ManagerID, SecretaryID, Address (Home, Office, Mailing), Phone (Home, Office, Cellular, Fax, Secretary), Email (Primary, Secondary), PersonalComments
InteractionEvent
Attributes: EventID (PK), ContactID (FK), EventType (Phone, Email, Postal), EventDate, Comments
Company
Attributes: CompanyID (PK), CompanyName
Relationships
Contact - Employer Relationship
Relationship: A Contact is employed by one Company, and a Company can have multiple Contacts.
Contact - Manager/Subordinate Relationship
Relationship: A Contact can manage multiple subordinates, and each subordinate has one manager.
Contact - Secretary Relationship
Relationship: A Contact can have one secretary, and a secretary can assist multiple Contacts.
Contact - InteractionEvent Relationship
Relationship: A Contact can have multiple InteractionEvents, and each InteractionEvent is associated with one Contact.
Diagram Description
The conceptual data model would visualize the following:
Entities: Contact, Company, InteractionEvent.
Relationships: Associative lines between entities with labels indicating relationships (e.g., "Has," "Belong").
Attributes: Key attributes for each entity and relationships are represented within entity boxes or near relationship lines.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!