Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following schema Doctor (id, name, specialization) Patient (id, name, age, gender) Checkup (checkupid, doc_id, p_id, diagnosis, fee, comments) If we try to delete

Consider the following schema Doctor (id, name, specialization) Patient (id, name, age, gender) Checkup (checkupid, doc_id, p_id, diagnosis, fee, comments) If we try to delete the doctor information from doctor table, it should not allow to delete if that doctor has a record in checkup table. 1) Write a Sql statement to create table checkup. 2) List the name of patients who are diagnosed with pneumonia.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Theory And Applications 27th Australasian Database Conference Adc 20 Sydney Nsw September 28 29 20 Proceedings Lncs 9877

Authors: Muhammad Aamir Cheema ,Wenjie Zhang ,Lijun Chang

1st Edition

3319469215, 978-3319469218

More Books

Students also viewed these Databases questions