Consider a hospital information system with the following characteristics: A patient can either be a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider a hospital information system with the following characteristics: • A patient can either be a resident who is admitted to the hospital or an out-patient who comes to the hospital for an out-patient clinic For both types of patient we will need to hold the patient's name, telephone number, address, date of birth and the patient's family doctor (GP) • For a resident patient we will need to hold the ward name in which the patient is currently residing, the admission date of the patient, and also information about any operations that the patient has had The operation information will have to include the date and time of the operation, the doctor (assume one) who carried out the operation plus the theatre where the operation took place For both GPs and hospital doctors we will need to hold the doctor's name and telephone number; in addition we will need to hold the GP's address and the hospital doctor's specialism code (for example, he or she may specialize in ENT problems relating to ear, nose and throat) – assume one per hospital doctor For out-patients we will need to hold information about the outpatients' appointments: the appointment date and time and the hospital doctor who attended to the patient Study the case given above and draw a complete entity-relationship diagram (ERD). Hint: Decomposing any many-to-many relationships, indicate constraints (eg. unique identifier, arcs etc.), make any assumptions that you need to make about optional/mandatory relationships and write description to support your design. Note: Please draw the ERD using crow-foot notation. Consider a hospital information system with the following characteristics: • A patient can either be a resident who is admitted to the hospital or an out-patient who comes to the hospital for an out-patient clinic For both types of patient we will need to hold the patient's name, telephone number, address, date of birth and the patient's family doctor (GP) • For a resident patient we will need to hold the ward name in which the patient is currently residing, the admission date of the patient, and also information about any operations that the patient has had The operation information will have to include the date and time of the operation, the doctor (assume one) who carried out the operation plus the theatre where the operation took place For both GPs and hospital doctors we will need to hold the doctor's name and telephone number; in addition we will need to hold the GP's address and the hospital doctor's specialism code (for example, he or she may specialize in ENT problems relating to ear, nose and throat) – assume one per hospital doctor For out-patients we will need to hold information about the outpatients' appointments: the appointment date and time and the hospital doctor who attended to the patient Study the case given above and draw a complete entity-relationship diagram (ERD). Hint: Decomposing any many-to-many relationships, indicate constraints (eg. unique identifier, arcs etc.), make any assumptions that you need to make about optional/mandatory relationships and write description to support your design. Note: Please draw the ERD using crow-foot notation.
Expert Answer:
Answer rating: 100% (QA)
Description about diagram attached below an Entity relationship diagram has been attached as ... View the full answer
Related Book For
Value at Risk The New Benchmark for Managing Financial Risk
ISBN: 978-0071464956
3rd edition
Authors: Philippe Jorion
Posted Date:
Students also viewed these operating system questions
-
Consider a disk with the following characteristics (these are not parameters of any particular disk unit): block size B=512 bytes, interblock gap size G=128 bytes, number of blocks per track=20,...
-
Consider a demand-paging system with the following time-measured utilizations: CPU utilization 20% Paging disk 97.7% Other I/O devices 5% Which (if any) of the following will (probably) improve CPU...
-
Consider a memory system with the following parameters: Tc = 100 ns Cc = 0.01 cents > bit Tm = 1,200 ns Cm = 0.001 cents > bit a. What is the cost of 1 MByte of main memory? b. What is the cost of 1...
-
Midland Corporation has a net income of $19 million and 4 million shares outstanding. Its common stock is currently selling for $48 per share. Midland plans to sell common stock to set up a major new...
-
Suppose that b > a > 0. Prove that a > 0. Prove that"> (1+)"*dx = b a. lim
-
Three cables are used to support a container as shown. Determine the angle formed by cables AB and AD.
-
Describe the responsibilities and the various agencies within the DHHS.
-
Abbey Park was organized on April 1, 2016, by Trudy Crawford. Trudy is a good manager but a poor accountant. From the trial balance prepared by a part-time bookkeeper Trudy prepared the following...
-
Discuss the complexities involved in international financial management, including foreign exchange risk management, global capital budgeting, and cross-border investment strategies.
-
Tires for Less is a franchise of tire stores throughout the greater Northwest. It has projected the following unit sales per tire and costs of tires for the coming year: The company policy is to have...
-
What are the major competitive issues General Electric faces when managing cooperative strategies?
-
What mechanisms underlie the phenomenon of emergent properties in complex ecological systems, and how do these properties manifest at different scales of organization, from individuals to ecosystems?
-
discuss the concept of ecosystem services in the context of human well-being and sustainable development, highlighting the economic valuation and trade-offs associated with their preservation?
-
Quentin Tarantino is a film director. In 2018, Quentin writes a script for a horror film called "The Rats". In the film, giant rats in New Zealand attack people. The rats grow bigger in size with the...
-
Design a Bayesian network bank loan credit system which takes as input details about the customer (banking history, income, years in job, etc.) and details of a proposed loan to the customer (type of...
-
Zippidy Lighters Limited has been manufacturing cigarette lighters for sixty years at its plant located in the Kinkville Industrial Park. The manufacturing plant has fifty-eight non-unionized...
-
Image caption Sibling Company Issued $670,000 par value, 10-year bonds at 105 on January 1, 20X3, which Mega Corporation purchased. The coupon rate on the bonds is 9 percent. Interest payments are...
-
Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...
-
Some file systems allow disk storage to be allocated at different levels of granularity. For instance, a file system could allocate 4 KB of disk space as a single 4-KB block or as eight 512-byte...
-
Typically, at the completion of a device I/O, a single interrupt is raised and appropriately handled by the host processor. In certain settings, 96 Chapter 13 I/O Systems however, the code that is to...
-
Consider a system consisting of four resources of the same type that are shared by three processes, each of which needs at most two resources. Show that the system is deadlock-free.
-
Management is considering three alternatives to satisfy an urgent need. Each of the alternatives will completely satisfy the need, so no combinations have to be considered. The first costs, operating...
-
Consider the following cash flow profile, and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/ year. a. Determine the MIRR for this project. b. Is this project economically...
Study smarter with the SolutionInn App