Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following responses, consider the simplified entity relationship diagram (ERD) below that serves as a conceptual model for data relationships in a simple hospital
For the following responses, consider the simplified entity relationship diagram (ERD) below that serves as a conceptual model for data relationships in a simple hospital database. (3 parts 25pts ) a. For the diagram above, interpret how all the main five entities are related. Where are there one-to-many relationships? Many-tomany relationships? (10pts.) b. There are some notable design problems in the relationships of the ERD shown here. Identify at least one issue and explain how it can be resolved. (5pts.) c. You are asked to use this ERD as a starting point to develop a full hospital database. Hospital management has asked you to continue identifying critical entities on which data can be stored. Name TWO additional entities that might be heipful to add to this ERD and explain why they are important. Note: Simply naming the entities and explaining the rationale for adding them is sufficient. You do NOT need to design any new ERDs with these two entities. (10pts.) In class, we introduced the idea of a Balanced Scorecard and its major uses. More recently, the idea of a Sustainability Scorecard strategy is getting attention as a competing approach. Please carry out research on Sustainability Scorecards and provide an overview of their purpose. What are TWO differences and TWO similarities between Balanced Scorecard and Sustainability Scorecards? Select a real company from your home city and explain what recommendations you would offer to implement a Sustainability Scorecard model. What opportunities and challenges would you envision given the unique industry and locale of your example company? Why? (1 part - 20pts)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started