F8 F9 F10 F12 Scroll The following is the data for surgeries performed by three
ID: 3601938 • Letter: F
Question
F8 F9 F10 F12 Scroll The following is the data for surgeries performed by three surgeons. Use this data to answer the questions below 6. Surgeon Number S-1011 Surzeon Name: Tony Smith Patiant Num | Patiant Name . Date Surgery Code Surgery Time 100 Gilian White 12-Apr-37 10.00 SRG-10 Tonsil Removal Surgery 13-Apr-17 1200 SRG-15 Endoscopic Sinus Sureery Surgeon Number: 5-1012 Surgeon Name: Helen Pearsorn Patiant Num Patiant Name Appoint Surgery Date Time Surgery Code .To "Mackay-12-May-171 1000+-SRG-10 TonsilRemovalSupery P-108 P-108 Tom Mackay 14 May 17 1000 SRG-33 Turbinate Reduction Surgeon Number: S-1013 Surgeon Name Robin Goti Patiant Num Patiant Name Sunpery Code Surgery Date 10-Jun-171 -105ill Bell P-110 John Porta 12-n-17 600 SRG 15 18:00! SRG-10-Tonsil Removal Supery Sinus Surpery a. Put this data in a table that is in the INF. Identify the Primary Key for this table. b. Draw the dependency diagram for the INF table you created in part a.Explanation / Answer
a) Put the data in this table i.e. 1NF and identify the primary key
Ans: combination of Surgeon number, Patient Num and surgery code become as primary key because one patient may have muliple surgery from differnt- differnt surgeon.
B) Draw the dependency diagram
Ans B) By looking into above any patient goes for surgery, it should know Surgeon name and surgery name based on this table will be created.
This become our primary key Surgeon Number Patient Num Surgery code Surgeon name Patient Name Appointment date Appointment Time Surgery S-1011 P-100 SRG-10 Tony Smith Gillan White 12-Apr-17 10:00 Tonsil remover Surgery S-1011 P-105 SRG-15 Tony Smith Jill Bell 13-Apr-17 12:00 Endoscopic sinus surgery S-1012 P-108 SRG-10 Helen Pearson Tom Mackay 12-May-17 10:00 Tonsil remover Surgery S-1012 P-108 SRG-13 Helen Pearson Tom Mackay 14-May-17 10:00 Turbinate remover surgery S-1013 P-105 SRG-10 Robin Goti Jill Bell 10-Jun-17 18:00 Tonsil remover Surgery S-1014 P-110 SRG-15 Robin Goti John Porta 12-Jun-17 16:00 Endoscopic sinus surgeryRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.