Slip 14 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Student (stud_reg_no, stud_name, class) Competition (cno, cname, ctype) Relation between Student and Competition is Many to Many with rank and year as descriptive attribute. Constraint: Primary key, class must be( “FY,SY,TY”). Consider the above tables and execute the following queries: 1. Count total no students class wise. 2. Delete the details of student who has participated in “Mehandi” competation.
Solution:
0 Comments