Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

More Books

Students also viewed these Databases questions