Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Logical Data Model in Chen's Notation (Not Normalized) Here is a logical data model of the unnormalized

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

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

Step by Step Solution

3.32 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

Vertices Org Unit Type Code Name Org Unit Code Name Org Unit Type Code Contact Mechanism ID Contact ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth

5th edition

978-1118057629, 1118057627, 978-111880817

More Books

Students also viewed these Programming questions