Slip 23 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. Student (rno,sname,address,class) Subject (subno,subname) Relationship: - Student and Subject are related with many-to-many relationship with attribute marks and status. Constraints: - Primary Key, class must be fy,sy,ty. Consider the above tables and execute the following queries: 1. List the names of student class wise. 2. Display the marks of students subject wise.

Solution:

Post a Comment

0 Comments