Question

Consider the following entities and their relationships. Create a RDB in 3 NF with

appropriate data types and Constraints.

[15 Marks]



Hospital (hno ,hname , city, Est_year, addr)

Doctor (dno , dname , addr, Speciality)

The relationship between Hospital and Doctor is one - to – Many

Constraints: - Primary Key, Est_year should be greater than 1990.

Consider the above tables and execute the following queries:

1. Delete addr column from Hospital table.

2. Display doctor name, Hospital name and specialty of doctors from “Pune City”​

Answer 1

Answer:

I wil‍♂️ just a reminder to you and