Slip 27 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Student (rollno, sname, class, timetable) Lab (LabNo, LabName, capacity, equipment) Relation between Student and Lab is Many to One. Constraint: Primary Key, capacity should not be null. Consider the above tables and execute the following queries: 1. Add column Phone_No with data type int in Student table. 2. Display lab wise capacity.

Solution:


Post a Comment

0 Comments