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

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

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Sql server 2012 query question

Create following tables with primary and foreign key relations.          

 

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.
Transcribed Image 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.
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.
Transcribed Image 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.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS