Ask Operation Management Expert

Draw an Enhanced Entity-Relationship (EER) diagram based on the following business environment.

The US Department of Education (DoE) wants to develop a database that, over time, will allow it to match students graduating from its high schools and universities with the kinds of job opportunities that there are in each US state. In order to do this, it has decided to maintain data about the companies headquartered in each state, the universities in each state, and the high schools in each state.

For each state, the DoE wants to store the name of its capital city, the current governor, the population, and the area in square miles.For each company in a state, it will include the company name, city, president, and main phone number. For each company there will be a list of jobs including the name of the job and the number of such positions the company has in its HQ state. For each job there will be a list of skill names.

Also, for each state, the DoE wants to store information about every high school in the state, including the high school name, the city it’s in, and the number of students attending it. The DoE wants to track the teachers in its high schools. Each teacher has a unique teacher number, name, and a list of subjects they are qualified to teach. Some teachers, particularly those with scarce specialties, teach in more than one high school (but always in the same state). For each high school that a teacher teaches in, the DoE wants to know the percentage of time that a teacher teaches there and the year that the teacher began teaching there.

For each university in each state, the DoE wants to keep track of the university’s personnel and its buildings. Each university employee (full-time professors, administrators, and adjunct (part-time) professors) has a unique employee number, name, and phone number. Data about full-time professors include the name of their department and their date-of-birth. Also, the DoE wants to keep track of the degrees that each professor has earned, including the degree type (BS, MS, PhD, etc.), the university at which it was earned, and the year it was earned.) For each administrator, the state wants to know their title, annual salary, and the year they assumed their current administrative position. For each adjunct professor, all that is needed is their salary per course taught. A university employee can only be in one of these three positions and there are no other positions possible. For each university building, the DoE wants to know its name, address, and size in square feet.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92605782

Have any Question?


Related Questions in Operation Management

Conflictdefine functional versus dysfunctional conflict in

Conflict Define functional versus dysfunctional conflict in a work group and explain how you can increase functional conflict and decrease dysfunctional conflict. Develop a response that includes examples and evidence to ...

For this assignment you will need to find 2 articles in

For this assignment, you will need to find 2 articles in business that can help describe what are IT strategic initiative being undertaken by an organization are like. Choose a different organization for each of the arti ...

Coping with problems joe is a little nervous he has just

Coping With Problems Joe is a little nervous. He has just been transferred from another plant to take over a production line. Production is down and there is a serious problem with absenteeism. To make matters worse, the ...

Over 30 years ago michael porter identified a holistic

Over 30 years ago Michael Porter identified a holistic approach to understanding how competitive forces shape strategy. He posited that the only way to truly insulate an organization from underlying economic volatility i ...

You are the contracting officer for an air-to-ground

You are the contracting officer for an air-to-ground missile development program. A contract for pre-production models of the missile was awarded by your predecessor and the contractor is behind schedule. In a program me ...

The ikea case provides an excellent opportunity to apply

The IKEA case provides an excellent opportunity to apply strategic management concepts to a large privately-held company that is expanding into India. IKEA is a Netherlands-based Swedish company with a presence in 44 cou ...

Can you answer for me the following questions about social

Can you answer for me the following questions about social loafing and the three main causes of free-riding. 1. Give a description of the phenomenon of social loafing. 2. Give a description of the phenomenon of free-ridi ...

1 analyzing the bridgestonefirestone and ford motor company

1. Analyzing the Bridgestone/Firestone and Ford motor company, is it sufficient to use the ISO/QS 9000 standards as the main basis of vendor/product selection? 2. What position to these cars company ( 1. Volkswagen, 2. F ...

Research the effect of primary and secondary seat belt laws

Research the effect of primary and secondary seat belt laws on the occurrence of motor-vehicle injuries and fatalities. Explain how epidemiologic studies influenced the development of current seat belt laws. Describe how ...

Please provide a brief paragrap of the key takaways from

Please provide a brief paragrap of the key takaways from each of the following topics: Designing Clear Visuals in business reports Designing Successful Documents and Websites Writing Winning Proposals

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As