Map the logical data model provided to a directed graph using the graph mapping rules included in
Fantastic news! We've Found the answer you've been seeking!
Question:
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 omittedCreate 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
Expert Answer:
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
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these programming questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
make a stored procedure called projects_at_this_location that receives a location and returns the projects (if any) at that location as shown in the following sample run: (2 points) exec...
-
Supreme Door Company sells pre-hung doors to home builders. The doors are sold for $60 each. Variable costs are $42 per door, and fixed costs total $450,000 per year. The company is currently selling...
-
Father, age 67, owns 84% of the common shares of Opco. Mother owns 8%. The remaining 8% is owned by their son, age 22, who works full-time in the business with Father. Mother has no involvement in...
-
CMS is a claims processing company in Mobile, Alabama. Chastity Jones, a black woman, completed an online employment application for a customer service position with CMS. Jones interviewed with a...
-
A Del Hardware has four employees who are paid on an hourly basis plus time-and-a half for all hours worked in excess of 40 a week. Payroll data for the week ended March 15, 2010, are presentd below....
-
Arrow Hospitality prepares adjustments monthly and showed the following at September 3 0 , 2 0 2 3 : ARROW HOSPITALITY Trial Balances September 3 0 , 2 0 2 3 Unadjusted Adjusted Trial Balance...
-
A steel erector company has a Worker's Compensation classification code of 2234, or a premium of $67.67 per $100.00 labor. If the company has an EMR of 0.9, the company will pay $ ________________for...
-
The parallel plates in a capacitor, with a plate area of 9.10 cm and an air-filled separation of 2.60 mm, are charged by a 8.40 V battery. They are then disconnected from the battery and pulled apart...
-
The springs have constants k1 and k2 and the masses have positions x1 and x2. Assuming x1 and x2 are zero when the springs are unstretched, find the set of second order differential equations...
-
a. Describe any four (4) elements of fraud that are likely to be committed in a property insurance contract. (10 Marks) b. Explain why deductible is relevant to organizations such as UPSA and...
-
If someone were to throw an object vertically, and catch it as it returned back down, describe how the velocity vector of this object changes over this period?
-
A particle of rest energy 700 MeV decays in its rest frame into two identical particles of rest energy 250 MeV. What are the kinetic energies (in MeV), momenta (in MeV/c), and velocities(in units of...
-
Sione Ltd owns all of the shares of Joape Ltd. In relation to the following intragroup transactions, all parts of which are independent unless specified, prepare the consolidation worksheet adjusting...
-
The electric field due to a line charge is given by where l is a constant. Show that E is solenoidal. Show that it is also conservative. E =
-
Creating use cases when working with users is a recent development in systems analysis practice. Why is the trend today to employ use cases in user interviews or JAD sessions?
-
Of what value is the Gantt chart to the project manager? The PERT chart?
-
Should a use case be prepared for every item on the event-response list? Why or why not?
-
What are the three main types of assistance available to the general public for completing their tax forms?
-
Ask older friends or relatives about the cost of specific items (e.g., a gallon of gas, a cup of coffee, etc.) during their youth. Also inquire bout their average wages in the past. Compare the...
-
Develop and solve a future-value, a present-value, a future value of an annuity, and a present value of an annuity problem. Establish the three known variables in each problem and solve for the...
Study smarter with the SolutionInn App