Question

3. Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints.
[25 Marks]
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.

Answer 1

Answer:

brainlist please don't let them know what you think about it true that I have a great day of school