Question: why the data modeling looks like this, and why there are two identifying lines connected to the person label You have just joined a firm

why the data modeling looks like this, and why there are two identifying lines connected to the person label

You have just joined a firm that follows a matrix structure and discover that you now have three bosses. One of your bosses has many people working for her, and many of these people also work for other bosses. She knows that the organization has a problem keeping track of the many boss-employee relationships. Thus, she has assigned you to draw a data model so she can assign someone else to develop the database.

person personID firstName la stName dob role title Indexes TH TH Report superiorID subordinatel D KdateBegin

person personID firstName la stName dob role title Indexes TH TH Report superiorID subordinatel D KdateBegin Indexes

Step by Step Solution

★★★★★

3.52 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The data model depicted here is used to represent the relationships between employees persons and their reporting structure within an organization tha... View full answer

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!

Thunderstruck Energy is a North American oil company. Its current cost of debt is 7.43%, and the 10-year U.S. Treasury Yield is 3%. The expected return of the Market is 13.38%. The company's...

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...

You have just joined a firm that follows a matrix structure and discover that you now have three bosses. One of your bosses has many people working for her, and many of these people also work for...

Read: Magids, Scott, Alan Zorfas, and Daniel Leemon (2015). "The New Science of Consumer Emotions," HBR , November 1.1. The article makes much of quantifying consumer emotions for analysis. Howthe...

Applied Mathematics and Computation 95 (1998) 181192 Love dynamics: The case of linear couples Sergio Rinaldi 1 Centro Teoria dei Sistemi, CNR, Politecnico di Milano, Via Ponzio 34/5, 20133 Milan,...

Instructions are highlighted Issues in Accounting Education Vol. 15, No. 2 May 2000 Budgeting and Performance Evaluation at the Berkshire Toy Company Dean Crawford and Eleanor G. Henry ABSTRACT: This...

Chapter 2 - Planning Project Communication IN THIS CHAPTER Struggling with Proper Project Communication Planning Preventing Common Communication Problems Creating a Project Communication Plan...

1. a. Briefly outline the B/B1 case situation and primary points/issues presented in the case. b. List all the Becton-Dickinson Company strategic goals identified in the cases. 2. Compare BDs...

Jupiter Notebook We have covered some of the limitations of single layer neural networks in class, but they are still powerful learning systems that provide a good way to begin learning about how to...

1. Prepare an explanation of Porter's Five Forces model and of Porter's broad-based organisational strategies for Helen. 2. Prepare a statement from Helen setting out how she sees the forces...

The table below represents the probability distribution for machine breakdowns in a day of operation. Number of breakdowns Probability . Interval of Random Numbers 0 0.20 1-20 1 . 0.30 21-50 2 0.35...

An open - top box is to be made from a 1 2 inch by 4 2 inch piece of playic by removing a square from each corner of the plastic and folding up the flaps on each side. What should be the length of...

Compound P, which absorbs light at 305 nm, was titrated with X, which does not absorb at this wavelength. The product, PX, also absorbs at 305 nm. Absorbance was measured in a 1.000-cm cell, and the...

The Blair Museum Association, a nonprofit organization, had the following transactions for the year ended December 31, 2020. 1. Cash contributions to the Association for the year included (a)...

Flow over a rectangular plate produces an average wall shear stress of 1.2 pascals. Calculate the friction drag in units of N. The plate dimensions are 1.5 m by 2.0 m. The plate is inclined at 20...

Suppose you are part of a trade expedition and there are 15 people in your party (including yourself). Your final destination lies across the desert, and so you must hire out camels to carry all of...

Passive and active solar energy systems are becoming viable options to home builders as installation and operating costs decrease. Laminated solar modules utilize high-quality, single-crystal,...

What is the primary function of cost classification?A. To facilitate cost control and decision-makingB. To ensure compliance with tax regulationsC. To determine the amount of tax to be paidD. To...

What is a DFD? Why do systems analysts use DFDs?

Explain Lucass model of implementation success.

Discuss with a systems analyst the role of conceptual data modeling in the overall systems analysis and design of information systems at his or her company. How, and by whom, is conceptual data...

Larson and Amos have decided to form a partnership. They have agreed that Larson is to invest $150,000 and that Amos is to invest $50,000. Larson is to devote one-half time to the business, and Amos...

Funk, George, and Lafayette LLP had equity balances on January 1, 2015, as follows: David Funk .......................... $160,050 Nathan George .......................87,600 Princess Lafayette...

On June 3, 2015, the firm of Adams, Watkis, and Cooper decided to liquidate its partner- ship. The partners have capital balances of $14,000, $84,000, and $118,000, respectively. The cash balance is...