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 relationsPopulate the relations with data (using SQL insert statements) by using the information in the below tablesIssue a select statement for each relation to retrieving data in relationsInclude 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

Creating table and discribed chart of every tabel Solution:_create table appointment( slot…

Answered: , Allergy, PatientAllergy, Medicine,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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

Expert Solution