Hospital Doctor Patient District Patient doctor Hospital name d name d id p_id p1 h_id Area d_id P_name c id D name p_id 1 NICD Latifabad No.3 1. Ahmed Khan Sobia c1 Karachi p1 1 2 Мaa Jee Latifabad...

Sql server 2012 query question

Create following tables with primary and foreign key relations.

Extracted text: Hospital Doctor Patient District Patient doctor Hospital name d name d id p_id p1 h_id Area d_id P_name c id D name p_id 1 NICD Latifabad No.3 1. Ahmed Khan Sobia c1 Karachi p1 1 2 Мaa Jee Latifabad No.2 2 Rashid Ahmed p2 Anusha c2 Hyderabad p2 1 Agha Khan Isra 3 Heerabad 3 Junaid p3 Faryal c3 Islambad p3 1 4 New Hyderabad 4 Deedar p4 Laviza p4 2 Boan Care Saddar 5 Danial p5 Hitesh p5 6 Kiran Phulleli 6 Raheem рб Nailesh p6 рб 2 7 LUMS Jamshoro 7 Akhter p7 p8 Geeta p7 8 Memon Safora 8 Waseem Arsa p8 3 Indus MA Jinnah 9 Shabeer p9 Ibrahim p9 10 Uncle Saria Garden 10 Waseem p10 Zafar p10 1 Arshad p11 p12 11 Zaid p11 12 Saleem Aafia p12 3 13 Rehan p13 Uzair p13 4 14 Rameez p14 Saqib p14 4 15 Rajesh p15 Anjum p15 4 16 Darwesh p16 Sami p16 5 p17 Zohaib p17 p18 Aamir p18 5 p19 Salman p19 p20 Sanjo p20 6.


Extracted text: Hospital_district h id doctor_hospital d_id h_id Doctor_district c_id d_id C_id 1. c3 1 c1 1 1 c3 2 c2 3 c1 3 c3 3 3 4 c1 4 c1 4 4 5 c3 5 c2 5 5 c3 c3 7 c2 7 c1 7 7 8 c2 c2 8 8 9 c1 c3 10 c2 10 c1 10 10 11 c2 11 1. 12 c3 12 1 13 c1 13 2. 14 c2 14 15 c3 15 3 16 c1 16 3 1. 10 3 8 4 7 6. 7 4 8. 2. 10 1.