Programming Assign. Unit 7 draft

docx

School

University of the People *

*We aren’t endorsed by this school

Course

2203

Subject

Medicine

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by EarlRockAlpaca7

Populating the Relations with Data Specialty Relation: Select statement: Output: SpecialtyNumber SpecialtyName S1 Dermatology S2 Psychiatry S3 Oncology S4 Cardiology S5 Urology S6 Pediatrics Doctor Relation:

Select statement: Output: DoctorID Name Phone SpecialtyNumber Supervisor D1 Doctor Karen 555-1212 S6 NULL D2 Doctor John 555-2934 S2 D1 D3 Doctor Robert 555-6723 S6 D1 D4 Doctor David 555-1745 S4 D1 D5 Doctor Mary 555-6565 S5 D1 D6 Doctor Linda 555-4889 S1 D1 D7 Doctor Susan 555-4581 S3 D1 D8 Doctor Zeynep 555-7891 S4 D1 D9 Doctor Mat 555-7791 S1 D1 Patient Relation: sqlCopy code INSERT INTO Patient (PatientID, DoctorID, Name, Phone, Email, Address, AddedDate) VALUES ('P1', 'D2', 'Patient Dana', '444-1212', 'P1@email.com', '123 Home St.', '02/01/2019'), ('P2', 'D7', 'Patient Harry', '444-2934', 'P2@email.com', '3435 Main St.', '7/13/2011'), ('P

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Programming Assign. Unit 7 draft

Related Documents