Using the Specialty, Doctor, Patient, Appointment, Allergy, PatientAllergy, Medicine, and PatientMedicine relations created for Hospital System database in the Unit 5 Programming Assignment, 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.

Assignment Instructions:

• Provide all of the SQL statements required to create the relations
• Populate the relations with data (using SQL insert statements) by using information in below tables
• Issue a select statement for each relation to retrieve 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