Map the logical data model provided to a directed graph using the graph mapping rules included in this module. Submit a graph diagram including the vertices, directed edges, association types and any attributes that are attached to edges $($attributes attached to vertices may be omitted$).$Create your response in a document

Transcribed Image Text:

Logical Data Model in Chen's Notation (Not Normalized) Here is a logical data model of the unnormalized schema in Chen's Notation. You can use this as a starting point for Assignment 3, but a less cluttered diagram appears below that should be easier to use for that purpose. Contact Type Code 000 Postal Address Contact ID Address Line (Address Line 2 City Name Contact ID State Province Code Country Code Postal Code C Contact Mechanism Email Contact ID Contact Usage Type Description disjoint complete Email Address Contact Usage Type Code 1000000 Telephone Contact ID m Country Code Area Code Phone Number Extension Number Contact Usage Device Type Code mc Party ID Party Type Description Party Type Code Given Name Middle Name) Family Name Birth Date Party ID Individual Party 1 disjoint complete Party ID с ||1| Is Customer Organization Is Employee Organization Name Org Unit ID Org Unit Type Code Org Unit Type Name Org Unit Name C Customer Manages mo Employee mc Customer ID Organizational Unit Effective Date (Termination Date Assigned To Work Group) 1 Employee ID Hire Date Is Supplier Termination Date Reports To Contains Pay Grade Code Pay Grade Name Supplier ID Effective Date C Supplier Receives Termination Date) Purchase Order mq Contains m Item Purchase Order ID Order Date Order Status Quantity Unit Price Item ID Item Description List Price Logical Data Model in Chen's Notation (Not Normalized) Here is a logical data model of the unnormalized schema in Chen's Notation. You can use this as a starting point for Assignment 3, but a less cluttered diagram appears below that should be easier to use for that purpose. Contact Type Code 000 Postal Address Contact ID Address Line (Address Line 2 City Name Contact ID State Province Code Country Code Postal Code C Contact Mechanism Email Contact ID Contact Usage Type Description disjoint complete Email Address Contact Usage Type Code 1000000 Telephone Contact ID m Country Code Area Code Phone Number Extension Number Contact Usage Device Type Code mc Party ID Party Type Description Party Type Code Given Name Middle Name) Family Name Birth Date Party ID Individual Party 1 disjoint complete Party ID с ||1| Is Customer Organization Is Employee Organization Name Org Unit ID Org Unit Type Code Org Unit Type Name Org Unit Name C Customer Manages mo Employee mc Customer ID Organizational Unit Effective Date (Termination Date Assigned To Work Group) 1 Employee ID Hire Date Is Supplier Termination Date Reports To Contains Pay Grade Code Pay Grade Name Supplier ID Effective Date C Supplier Receives Termination Date) Purchase Order mq Contains m Item Purchase Order ID Order Date Order Status Quantity Unit Price Item ID Item Description List Price

Answer rating: 100% (QA)

Directed Graph Mapping of the Logical Data Model Vertices Party Represents a participant in the system Individual Organization Employee Customer Supplier Contact Mechanism Represents a way to reach a ... View the full answer