Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
ing the Specialty, Doctor, Patient, Appointment, Allergy, PatientAllergy, Medicine, and PatientMedicine relations created for the Hospital System database. Populate them with data using the following information in the tables. If your relations have additional attributes that are not included in the following table list, then add appropriate values to populate your relations with data.  Instructions:   Provide all of the SQL statements required to create the relations Populate the relations with data (using SQL insert statements) by using the information in the below tables Issue a select statement for each relation to retrieving data in relations Include both the select statement and the output of the select statement (using a screenshot of your database’s output) that shows the contents of each relation

ing the Specialty, Doctor, Patient, Appointment, Allergy, PatientAllergy, Medicine, and PatientMedicine relations created for the Hospital System database. Populate them with data using the following information in the tables. If your relations have additional attributes that are not included in the following table list, then add appropriate values to populate your relations with data.  Instructions:   Provide all of the SQL statements required to create the relations Populate the relations with data (using SQL insert statements) by using the information in the below tables Issue a select statement for each relation to retrieving data in relations Include both the select statement and the output of the select statement (using a screenshot of your database’s output) that shows the contents of each relation

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

Using the Specialty, Doctor, Patient, Appointment, Allergy, PatientAllergy, Medicine, and PatientMedicine relations created for the Hospital System database. Populate them with data using the following information in the tables. If your relations have additional attributes that are not included in the following table list, then add appropriate values to populate your relations with data. 

Instructions:

 

  • Provide all of the SQL statements required to create the relations
  • Populate the relations with data (using SQL insert statements) by using the information in the below tables
  • Issue a select statement for each relation to retrieving data in relations
  • Include both the select statement and the output of the select statement (using a screenshot of your database’s output) that shows the contents of each relation
  • Regards
SpecialtyNumberSpecialtyName Appointment Medicine Relation S1 Dermatology S2 Psychiatry AppointmentiD Patientio DoctoriD AppointmentDate BloodPressure Weight TreatmentNotes Oncalogy A1 P1 D2 07/01/2019 BC 80 65 Dream to success Cartdialogy Uralogy S4 A2 P13 D4 01/04/2019 77 Good heart rate MedicinelD MedicineName A3 P11 D9 03/22/2019 82 95 Many spats S6 Pediatrics A4 P7 D4 02/01/2020 85 74 Fast heart rate M1 Ativan AS P9 DS 04/13/2019 75 56 Reports checked M2 Ibuprofen Omeprazale AG P3 D6 11/12/2019 81 96 Sun light spats Doctor Relation A7 P10 D7 01/29/2020 80 87 Early treatment AB P9 D5 O8/12/2019 86 92 Much better M3 DoctoriD Name A9 D4 75 75 Good heart rate Phone SpecialtyNumber Supervisor P14 05/18/2019 M4 Metoprolol A10 Pa D3 11/10/2019 76 79 New teeth D1 Doctor Karen555-1212 S6 Dactor John A11 P11 D9 06/22/2019 78 71 Much better M5 Azithromycin D2 555-2934 S2 D1 A12 P2 D7 02/21/2020 82 Early treatment D3 Doctor Robert 555-6723 S6 01 A13 P4 D2 M6 Codeine 08/17/2019 06/27/2019 81 101 Bad dreams Doctor David 5s5-1745 DS D4 54 01 Doctor Mary 555-6565 S5 D1 A14 PG D6 79 49 Sun light spats D6 Doctor Linda 555-4889 S1 D1 A15 P10 D7 07/29/2020 80 83 Early treatment A16 P7 D4 OB/01/2020 78 79 Good heart rate PatientMedicine D7 Doctor Susan 555-4581 01 ES D8 Doctor Zeynep 555-7091 54 01 D9 Doctor Mat 555-7791 S1 D1 Allergy Relation AppointmentiD MedicineiD Patient Relation AllergyiD AllergyName A15 M1 AL1 Drug AL2 Food A2 M6 PatientiD DoctoriD Name Phone Email Address AddedDate AL3 Skin 444-1212 | P1@email.com 123 Hame St. 02/01/2019 3435 Main St. 7/13/2011 P1 D2 Patient Dana AB M3 P2 D7 Patient Harry 444-2934 P2@email.com AL4 Asthma Rhinitis 444-6723 PI@email.com 2176 Baker St 176 Right St 435 Main St. ALS P3 D6 Patient Karl 5/10/2009 AG M3 444-1745 P4@email.com Patient Marry 444-6565 PS@email.com 444-4889 P6@email.com Patient Susan 444-4581 | P7@email.com P4 D2 Patient Sid 6/20/2010 A15 M2 PS DE 5/18/2014 PatientAllergy Relation PG D6 Patient Kim 34 Home St. 3/15/2018 A10 MG P7 D4 65 Water St. 9/07/2011 AllergyiD PatientiD P8 Da Patient Sam 444-7891 PO@email.com 23 Hill Drive 11/23/2010 A10 M2 AL4 P1 Patient Peter 444-7791 P9@email.com 123-1212 P100email.com 123-2934 P11@email.com P9 DS 12 River St. 02/01/2006 AL2 P13 A4 MS P10 D7 Patient Nick 335 Bay St. 7/13/2011 AL3 P11 P11 D9 Patient Kyle 216 Baker St. 5/10/2016 P7 A3 MS AL4 Patient Garcia 123-6723 P12@email.com 176 Right St. P12 D9 6/20/2010 ALS P9 P13 D4 Patient Alicia 123-1745 P13@email.com 823 Left St. 5/18/2015 A1 M2 P14 D4 Patient Dan 123-6565 P14@email.com 534 High St. 3/15/2010 ALT P3
Transcribed Image Text:SpecialtyNumberSpecialtyName Appointment Medicine Relation S1 Dermatology S2 Psychiatry AppointmentiD Patientio DoctoriD AppointmentDate BloodPressure Weight TreatmentNotes Oncalogy A1 P1 D2 07/01/2019 BC 80 65 Dream to success Cartdialogy Uralogy S4 A2 P13 D4 01/04/2019 77 Good heart rate MedicinelD MedicineName A3 P11 D9 03/22/2019 82 95 Many spats S6 Pediatrics A4 P7 D4 02/01/2020 85 74 Fast heart rate M1 Ativan AS P9 DS 04/13/2019 75 56 Reports checked M2 Ibuprofen Omeprazale AG P3 D6 11/12/2019 81 96 Sun light spats Doctor Relation A7 P10 D7 01/29/2020 80 87 Early treatment AB P9 D5 O8/12/2019 86 92 Much better M3 DoctoriD Name A9 D4 75 75 Good heart rate Phone SpecialtyNumber Supervisor P14 05/18/2019 M4 Metoprolol A10 Pa D3 11/10/2019 76 79 New teeth D1 Doctor Karen555-1212 S6 Dactor John A11 P11 D9 06/22/2019 78 71 Much better M5 Azithromycin D2 555-2934 S2 D1 A12 P2 D7 02/21/2020 82 Early treatment D3 Doctor Robert 555-6723 S6 01 A13 P4 D2 M6 Codeine 08/17/2019 06/27/2019 81 101 Bad dreams Doctor David 5s5-1745 DS D4 54 01 Doctor Mary 555-6565 S5 D1 A14 PG D6 79 49 Sun light spats D6 Doctor Linda 555-4889 S1 D1 A15 P10 D7 07/29/2020 80 83 Early treatment A16 P7 D4 OB/01/2020 78 79 Good heart rate PatientMedicine D7 Doctor Susan 555-4581 01 ES D8 Doctor Zeynep 555-7091 54 01 D9 Doctor Mat 555-7791 S1 D1 Allergy Relation AppointmentiD MedicineiD Patient Relation AllergyiD AllergyName A15 M1 AL1 Drug AL2 Food A2 M6 PatientiD DoctoriD Name Phone Email Address AddedDate AL3 Skin 444-1212 | P1@email.com 123 Hame St. 02/01/2019 3435 Main St. 7/13/2011 P1 D2 Patient Dana AB M3 P2 D7 Patient Harry 444-2934 P2@email.com AL4 Asthma Rhinitis 444-6723 PI@email.com 2176 Baker St 176 Right St 435 Main St. ALS P3 D6 Patient Karl 5/10/2009 AG M3 444-1745 P4@email.com Patient Marry 444-6565 PS@email.com 444-4889 P6@email.com Patient Susan 444-4581 | P7@email.com P4 D2 Patient Sid 6/20/2010 A15 M2 PS DE 5/18/2014 PatientAllergy Relation PG D6 Patient Kim 34 Home St. 3/15/2018 A10 MG P7 D4 65 Water St. 9/07/2011 AllergyiD PatientiD P8 Da Patient Sam 444-7891 PO@email.com 23 Hill Drive 11/23/2010 A10 M2 AL4 P1 Patient Peter 444-7791 P9@email.com 123-1212 P100email.com 123-2934 P11@email.com P9 DS 12 River St. 02/01/2006 AL2 P13 A4 MS P10 D7 Patient Nick 335 Bay St. 7/13/2011 AL3 P11 P11 D9 Patient Kyle 216 Baker St. 5/10/2016 P7 A3 MS AL4 Patient Garcia 123-6723 P12@email.com 176 Right St. P12 D9 6/20/2010 ALS P9 P13 D4 Patient Alicia 123-1745 P13@email.com 823 Left St. 5/18/2015 A1 M2 P14 D4 Patient Dan 123-6565 P14@email.com 534 High St. 3/15/2010 ALT P3
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps with 15 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
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