Question: please answer and explain both 5. (35 points) The figure illustrates the Maria (33) Manager-Subordinate relationship of 3/4 5/6 a company where each employee has

please answer and explain both

5. (35 points) The figure illustrates the Maria (33) Manager-Subordinate relationship of 3/4 5/6 a company where each employee has a non-unique name and unique 2-digit Kim (21) Matt (#23) Beth (24) employee ID (e.g., #10). For instance, vindt the arrow from Jim (#10) to Kim (#21) indicates that "Jim reports to Kim". Jim (#10) Kim (W11) Mary (913) Beth (414) Maria (#16) Further, the date on each arrow indicates the assignment date of the manager-subordinate relationship. Then, a) (10 points) Draw an E/R diagram that can capture ALL information of the figure, including assignment dates. Your cardinality/modality must be precise according to the figure. b) (25 points) Convert your E/R diagram into relational tables, and fill the tables using the information on the figure in detail (i.c., table names, attribute names, and TUPLES in them, and primary keys)

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 Databases Questions!

5. (35 points) The figure illustrates the Maria (33) Manager-Subordinate relationship of a company where each employee has a M 5/6 non-unique name and unique 2-digit Kim (#21] Matt (23) Beth (24)...

MNG3701/101/3/2016 Tutorial Letter 101/3/2016 Strategic Planning MNG3701 Semesters 1 and 2 Department of Business Management IMPORTANT INFORMATION: Please activate your myUnisa and myLife email...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Files 12:56 PM Mon May 16 25% Unit+2+workbook Q . . . Home Insert Draw Layout Review View Calibri Bold (Body) 36 B I U aAv A v Unit 2-Supply and Demand Name: HR: LAW OF SUPPLY Use the space below to...

Lesson 12: Regression NAME Lab Assignment Answer the following questions showing all work. For questions that require Minitab Express, include the appropriate output (copy + paste) along with an...

Please help answer figure 2 on page 45 in attached document See Job Order Costing Material (1).pdf . Thank you!!! 39 JOB ORDER COSTING: A SIMULATION AND VEHICLE FOR CONCEPTUAL DISCUSSION Rochelle K....

Can you please complete Figure 5 on the document. 39 JOB ORDER COSTING: A SIMULATION AND VEHICLE FOR CONCEPTUAL DISCUSSION Rochelle K. Greenberg, Florida State University Arnold Schneider, Georgia...

Hi Professor, I have one project for capstone, you just see that and need to compress as much as 40 - 50 papers. No need to discuss detailed. 1. Executive Summary 2. Industry Analysis 3. Detailed...

I need help with this tax return problem. PLEASE, the correct tax return forms MUST be used, which can be found on irs.gov. I would need thorough work on this assignment. Thank you for the help!...

I'm having issues with the itemized deductions section - I am coming up with $22,778 when the answer should be $23,238. Can you assist me? INDIVIDUAL TAX RETURN PROBLEM 5 Required: Use the following...

Calande Corporation purchased five new assets at the beginning of its accounting period. The cost, salvage value, and estimated useful lives of these assets are Required: Use a computer spreadsheet...

Determine the molecular formula of the compound with an empirical formula of CH and a formula mass of 78.110 u.

Gold slips as the dollar and Treasury yields tick higher - how does that affect international finance

please dont use chat gpt or other AI c . 7 9 1 .

Explain the purpose of the Project Charter and its relationship to Management Approval for a Project.

What is Change Control and how does it operate?

How do Data Requirements relate to Functional Requirements?