2. You are assigned to design a Hospital Management System for Klang Valley Medical Centre. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. You are assigned to design a Hospital Management System for Klang Valley Medical Centre. The following are requirements of the system: There are three types of employees in this hospital which are the physician (medical doctor), nurse and administrator. Unlike administrative staff, a physician and a nurse staff have special attributes. A physician has a qualification and an expert area. A nurse has a position and a ward_id where he or she is placed. A physician treats many patients and a patient can be treated by more than one physician. Each treatment has prescriptions. The prescription has a prescription_id, date, product_code, dosage and amount. A patient can be placed in a ward. A ward is serviced by several nurse staff. The ward information includes ward number, building, ward_type and a number of beds. List all entities with their attributes. Identify the primary key. (a) (b) Draw an Entity Relationship (ER) diagram to represent the given information. (8) (12) (Total : 20) 2. You are assigned to design a Hospital Management System for Klang Valley Medical Centre. The following are requirements of the system: There are three types of employees in this hospital which are the physician (medical doctor), nurse and administrator. Unlike administrative staff, a physician and a nurse staff have special attributes. A physician has a qualification and an expert area. A nurse has a position and a ward_id where he or she is placed. A physician treats many patients and a patient can be treated by more than one physician. Each treatment has prescriptions. The prescription has a prescription_id, date, product_code, dosage and amount. A patient can be placed in a ward. A ward is serviced by several nurse staff. The ward information includes ward number, building, ward_type and a number of beds. List all entities with their attributes. Identify the primary key. (a) (b) Draw an Entity Relationship (ER) diagram to represent the given information. (8) (12) (Total : 20)
Expert Answer:
Answer rating: 100% (QA)
From the given information here are the entities with their attributes For each entity Ill also identify a likely primary key 1 Physician Medical Doct... View the full answer
Related Book For
Understanding Cross Cultural Management
ISBN: 9781292015897
3rd Edition
Authors: Marie Joelle Browaeys, Roger Price
Posted Date:
Students also viewed these programming questions
-
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...
-
There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...
-
Consider the hydrogen atom, and assume that the proton, instead of being a point- source of the Coulomb field, is uniformly charged sphere of radius R ( < < ao), so that the Coulomb potential is now...
-
Maverick Wings, Inc. manufactures airplanes for use in stunt shows. Maverick's factory is highly automated, using the latest in robotic technology. To keep costs low, the company employs as few...
-
Aunt Rose set up an eBay story selling antiques. Almost immediately she discovered that nearly one-third of the inquiries and auction bids were from outside the United States. Byron (from question 3)...
-
In your audit of the Whitestable Company's December 31, 1999 financial statements, you become aware of the following controls or procedures over investments, debt, and equity: a. On June 15, 1999,...
-
Regional Airlines is establishing a new telephone system for handling flight reservations. During the 10:00 A.M. to 11:00 A.M. time period, calls to the reservation agent occur randomly at an average...
-
What is discretionary fiscal policy? What arecontractionary and expansionary fiscal policies and how they are used? Are these policieseconomic or political or both? Explain. Why might politicians be...
-
Using the method of composite areas, find the centroid of the area. Be sure to indicate each part number in the picture below. www.class4me.com/coursedata/statics/Formulas.pdf R100mm 100m 25mm...
-
The stockholders equity accounts of Whispering Winds Corp. on January 1, 2022, were as follows. Preferred Stock (7%, $100 par noncumulative, 6,000 shares authorized) $360,000 Common Stock ($4 stated...
-
What are the differences between data warehouses, BI, and data mining?
-
When evaluating vendor offerings, what are the key factors that will help your firm determine the best software product to acquire?
-
How do companies use an RFP when sourcing software? What are the key items that should be included in the RFP?
-
If you were advising a firm on developing an RFP, what would be some key suggestions you would make for improving the effectiveness of the RFP?
-
How are forms and reports similar, and how are they different?
-
fr' (t) = (t, et, sin(t) + 1) and r(0) = (1, 1, 1) then r(1) =? (rounding each component to 3 decimal points) Or(1) = (1.5, 2.718, 1.460) Or(1) = (0.5, 3.718, 1.460) Or(1) = (0.5, 3.718, 2.460) Or(1)...
-
What exactly is a prima facie duty? How does an ethic of prima facie duties differ from monistic and absolutist ethical theories?
-
For nearly 150 years, John Lewis has had a shop on London's Oxford Street. Customer 'footfall' is steady. The department store group's carefully nurtured and increasingly well-marketed reputation for...
-
The concept gives a range of eight cultural values that could affect five management skill areas. Can you suggest other cultural value ranges that could be applied? Are there other management skill...
-
A widespread inquiry into secret bank accounts and fictitious contracts across the European Commission has been launched. There is fear that the vast enterprise of looting that fraud investigators...
-
Repeat Example 3 .16 using Wagner theory. Try airspeeds higher than U = 50 .47; how similar are the time and frequency responses predicted by Wagner theory and Theodorsen theory at such airspeeds?...
-
Throughout Section 4.2, the pitching moment is calculated using the distance between the bound vortices and a datum (quarter chord or pitching axis). What differencewould it make if the pitching...
-
Repeat Example 3 .15 using Wagners model of Example 3 .12. How similar are the predictions of Theodorsens and Wagners theory? Data from Example 3 .15 Calculate the aerodynamic load responses of a...
Study smarter with the SolutionInn App