Question

Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data typesandConstraints.​

Student (rno,sname,address,class) Subject (subno,subname)

Relationship:-StudentandSubjectarerelatedwithmany-to-manyrelationshipwithattribute 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 classwise.
2. Display the marks of students subjectwise.

Answer 1

Answer:

ulztjlFJLztTufYeYlatualear7ayksylsluc