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 ManagerSubordinate 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 eg "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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
