Slip 4 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Patient (PCode, Name, Addr, Disease) Bed (Bed_No, RoomNo, loc) Relationship: - There is one-one relationship between patient and bed. Constraints: - Primary key, RoomNo must be greater than Bed_No, Addr should not be null. Consider the above tables and execute the following queries: 1. Display the details of patients who are from “Pimple Gurav”. 2. Delete the details of patient whose Bed_No is 1 and RoomNo is 105.

Solution:



Post a Comment

0 Comments