Slip 3 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. 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”

Solution:



Post a Comment

0 Comments