Slip 28 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Blood (blood_id, blood_group, cholesterol_level, storage) Donar (donar_id, name, address, gender, phone_no) Relation between Blood and Donar is Many to one. Constraint: Primary Key , Blood_group should not be null. Consider the above tables and execute the following queries: 1. List out Donar wise Blood_group. 2. Display cholesterol_level of blood which is given by ‘Mr. Mahandule’.
Solution:
0 Comments