N&N Hospital is facing problems in its data organization. As database analyst, you have to normalize...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
N&N Hospital is facing problems in its data organization. As database analyst, you have to normalize following N&N Hospital data up to 4NF. Elaborate each step you perform with logic and state clearly any other VALID assumption that you make. Department Designation Charges Patient Id Doc Name Address Phone Patient CNIC Phone Room Room Bed Per hour No. Name No. Туре No. no. D1 Dr. Nadeem Abc 123 0333-123, Neurology 042-123 Professor 5000 P1 Kahlid Ahmed 12345-1 042-1 12345-2| 042-2 N R2 Normal B1 P5 P7 12345-3 042-3 Mehmood 12345-4 042-4 12345-3 042-3 12345-6 042-5 12345-7 | 042-6 12345-1 042-1 12345-9 | 042-8 12346-0 042-9 Anum Nill Dr.Nadeem Kb13 0334-124, Orthopedic Professor 0300-123 D2 5000 P4 P7 R2 R4 Normal B1 Two Anum B5 P9 Khawar bed B7 Dr.Erum 0321-123 ENT/ Neurology Ak123 3000 Astt. Professor D4 P10 Tanweer Nill Nll Khalid R5 Special B8 Nill Special B9 P1 D5 Dr.Hafeez Nd123 0321-124 Astt. 3000 P12 Sohail NI Skin/ Orthopedic Professor P13 Ahmed R6 N&N Hospital is facing problems in its data organization. As database analyst, you have to normalize following N&N Hospital data up to 4NF. Elaborate each step you perform with logic and state clearly any other VALID assumption that you make. Department Designation Charges Patient Id Doc Name Address Phone Patient CNIC Phone Room Room Bed Per hour No. Name No. Туре No. no. D1 Dr. Nadeem Abc 123 0333-123, Neurology 042-123 Professor 5000 P1 Kahlid Ahmed 12345-1 042-1 12345-2| 042-2 N R2 Normal B1 P5 P7 12345-3 042-3 Mehmood 12345-4 042-4 12345-3 042-3 12345-6 042-5 12345-7 | 042-6 12345-1 042-1 12345-9 | 042-8 12346-0 042-9 Anum Nill Dr.Nadeem Kb13 0334-124, Orthopedic Professor 0300-123 D2 5000 P4 P7 R2 R4 Normal B1 Two Anum B5 P9 Khawar bed B7 Dr.Erum 0321-123 ENT/ Neurology Ak123 3000 Astt. Professor D4 P10 Tanweer Nill Nll Khalid R5 Special B8 Nill Special B9 P1 D5 Dr.Hafeez Nd123 0321-124 Astt. 3000 P12 Sohail NI Skin/ Orthopedic Professor P13 Ahmed R6
Expert Answer:
Related Book For
Cost Accounting Foundations and Evolutions
ISBN: 978-1111971724
9th edition
Authors: Michael R. Kinney, Cecily A. Raiborn
Posted Date:
Students also viewed these databases questions
-
In Exercises 7 and 8 of Chapter 4 you worked with data on sales for a line of skiwear that is produced by HeathCo Industries. Barbara Lynch, product manager for the skiwear, has the responsibility of...
-
You are an analyst in a state Department of Parks and Recreation. The state is famous for Dizzy Vista Mountain, which has a fabulous view of an eagle's nesting area. You are asked to analyze a...
-
Each matrix i n Problems 1 to 3 corresponds to one of the linear transformations in Problem 54. Match each matrix with the corresponding image from Fig. 5. 1.9. 1. 2. 3. 0 and 0 0
-
1. The two taxes paid on most purchases are the amount of each tax is % and and the % respectively. 2. Use the "10% + 5%" method of estimating total cost. Estimated Rounded Cost Item Cost 10% 5%...
-
Answer the following questions based on Tables 5P-1 and 5P-2. a. What is the quantity demanded at $10? What is the quantity supplied at $10? b. What is the quantity demanded at $25? What is the...
-
Refer to the bond details in Problem 14-2A, except assume that the bonds are issued at a price of $4,895,980. Required 1. Prepare the January 1, 2017, journal entry to record the bonds' issuance. 2....
-
Why are fires important in savannas?
-
The following misstatements are included in the accounting records of Westgate Manufacturing Company. 1. The accounts payable clerk prepares a monthly check to Story Supply Company for the amount of...
-
How do emerging technologies, such as genomic sequencing and remote sensing, facilitate the integration of ecological and population-level data to inform conservation planning and management...
-
Suppose that consumption depends on the level of real money balances (on the grounds that real money balances are part of wealth). Show that if real money balances depend on the nominal interest...
-
(a) In the circuit shown in Figure Q1-1, determine the unknown node voltages V1, V2, through the following steps. i. Use nodal analysis to calculate vi, v2 and vx. [14] ii. Calculate the power...
-
Look around carefully, paying close attention to any objects that you have never noticed, and/or objects that make you feel uncomfortable. Could one of them be a Tsukuyomi? Next, sit down with your...
-
Produce a persuasive report for a company of your choice, with arguments for why they should produce a sustainability report. You will be expected to Prepare a 2500 words persuasive report addressed...
-
oday's exchange rate between British pounds and US dollars is 1:1.29, meaning 1 pound is worth 1.29 dollars. For simplicity, we say the exchange rate between pound and dollar is 1.29. Consider a...
-
Question 1 (1 point) Listen A long-term care resident is to take 15 mL of a medication 3 times a day. How many teaspoons (tsp) will this patient need for a 3 day supply of this medication based on...
-
Just by having money doesn't make a country rich. It's whatthe country can produce that makes a country rich. Inflation/deflation is all around us. Have you notice any price changes in the everyday...
-
pythoncode with steps explained for exam note sheet please show step bystep scratch work for procesd, on conputer is ideal. thanks. i willgive a thumbs up 1 numbers \( =[1,2,3,4,5] \) 2 operation \(...
-
Hotel Majestic is interested in estimating fixed and variable costs so that the company can make more accurate projections of costs and profit. The hotel is in a resort area that is particularly busy...
-
The following 2013 information is available for Leffingwell Industries: average assets invested $ 8,200,000; sales, $ 31,400,000; and expenses, $ 27,600,000. a. Calculate return on investment. (Round...
-
When Dominos Pizza began operations in 1960, it had a 30 Minutes or Its Free campaign. In making that promise, the company set a standard time to prepare and deliver a pizza. In 1993, Dominos...
-
For 2013, Riguilio Inc. set predetermined variable and fixed overhead rates, respectively, at $ 6.50 and $ 9.35 based on an expected monthly capacity of 4,000 machine hours. Each unit of product...
-
Define a closely held corporation.
-
Explain the role played by a board of directors of a corporation.
-
Explain how corporations provide limited liability to their owners.
Study smarter with the SolutionInn App