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%...
-
What is meant by capitation fees? When should they be recognized as revenues?
-
A sound wave is modeled by Where pn(t) = 1 / n sin (524n Ï t), t represent the time (in seconds). (a) Find the sine components pn(t) and use a graphing utility to graph the components. Then...
-
Which of the following events will not appear in the cash flows from financing activities section of the statement of cash flow? a. Borrowing cash from a bank b. Issuance of stock in exchange for...
-
Ogden Furniture, Co., purchased land, paying $70,000 cash plus a $300,000 note payable. In addition, Ogden paid delinquent property tax of $2,500, title insurance costing $2,000, and $8,000 to level...
-
Should activities on the critical path be outsourced ? Why or why not ?
-
An accounting entry is required, with one exception: the annual change in employee pay rates, Trans. Document ? Dec. Flowchart Description Received customer purchase order No. 53426 (Doc. No. 4) from...
-
Ms. Walsh invested $18,000 in two accounts, one yielding 7% interest and the other yielding 9%. If she received a total of $1,400 in interest at the end of the year how much K did she invest in each...
-
Assume that CAPM applies. Suppose that you know that the Stock of a company called " We thank you all for your patience" has a beta equal to 0 . 7 and a risk premium equal to 1 4 % . The risk - free...
-
Wildhorse Manufacturing Company uses a job order cost system and keeps perpetual inventory records. June 1 Purchased raw materials for $24,400 on account. 8 Raw materials requisitioned by production:...
-
Provide an implementation plan which would address the following issues: What are the key challenges of implementation that you will face? Which groups is likely to be most affected by your suggested...
-
Required information [The following information applies to the questions displayed below.] In January, Tongo, Incorporated, a branding consultant, had the following transactions. a. Received $18,400...
-
A ball screw coupled directly to a dc servomotor is used to drive one of the table axes of a CNC milling machine. The screw has 4 threads/cm. The optical encoder attached to the screw emits 120...
-
The fixed and variable costs can then be used to forecast the total cost at any level of activity. 1. The high-low method has the enormous advantage of simplicity. 2. It is easy to understand and...
-
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...
-
In the short run, equilibrium output is determined where marginal revenue equals marginal _________. The price is set equal to the _________ the consumer will pay for this amount.
-
Barriers to entry do not protect monopolistic competitive firms in the _________ run. Economic profits will _________ new firms to the industry. Similarly, firms will leave when there are economic...
-
When price is greater than average total costs, the monopolistic competitive firm will make an economic _________.
Study smarter with the SolutionInn App