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...
-
Refer to Exercise 6.8. a. Calculate the mean. x, the variance, x and the standard deviation, x. b. Find the probability that the waiting time of a randomly selected patron will be within one standard...
-
Two brothers are planning to set up a computer repair business together. They need to decide whether to work in partnership or whether to form a limited liability company. From an accounting and...
-
What is the condition on efficiency for a machine to be self-locking ?
-
What is the rationale for accounting for nonexpendable endowment funds on a full, rather than a modied, accrual basis? Why is it important that depreciation be charged on long-term assets held as...
-
1- What is the significance of these three matrices regarding their relevance for strategic planning fpr southwest airlines? 2- Describe the key information for each and how information from each...
-
Consider the situation where you just received $10,000 pre-tax income this year and you are considering whether you should contribute part of the money to IRA or an annuity account, or just put the...
-
The following Trial Balance was extracted from the books of Aso Ltd for the year ended 30th September 2018: Dr Cr GH GH Stated Capital 185,280 Revaluation surplus @ 1/1/2018 25,000 Income Surplus @...
-
An investor owns 1,000 shares of CCC Company. Through a rights offering the investor receives rights and subsequently sells them in the market for $2 each. Brokerage fees were $50 in total. What...
-
Financial statement users should focus attention on each item showing a large percentage change from one year to the next." Is this statement correct? Why? What are common-size financial statements...
-
Company XYZ has a poison pill that gives each shareholder the right to purchase one additional share of stock at a 75% discount. If a hostile bidder purchases 20% or more of Company XYZ's shares, the...
-
TRAINING AT THE SPICES FACTORY Ana Maria is an employee at the Mak Long Spice Factory Sdn Bhd, in Butterworth, Penang. Ana Maria has five years of experience in Mak Long's Date Spice Division....
-
Write C++ program to find a largest value among three numbers. Correct the code. include using namespace std; int main [] { } for (int n=10; n>0; n--) { cout >> n < < ", ; Cout.print < < "FIRE!/n";...
-
List and evaluate the significance of the risk list as a database of risks affecting organisations.
-
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.
-
A positively charged particle creates the electric field shown in Figure 30. 20. When the kinks in the electric field lines reach the rod, what is the direction of the current induced in the rod?...
-
Suppose the current shown in Figure 30. 19 discharges the capacitor. What are the directions of \(\vec{E}\), \(\Delta \vec{E}\), and \(\vec{B}\) between the plates of the discharging capacitor? Data...
-
For the oscillating dipole of Figure 30. 14, sketch the electric field pattern at \(t=\frac{5}{4} T\). Data from Figure 30.14 0=1 t = T t=T 1=T O O D
Study smarter with the SolutionInn App