Result:

Student:

Then write queries for the following :
1. Display the tables ,Student , Course and Result.
Deliverables :
1. Relational Schema
2. Screen shot of create queries.
3. Screen shot of insert queries
4. Screen shot of the query written for displaying tables.
5. Screen shot of tables created.
6. .sql file.
 
 
 
 

Given the following ERD: course >CNAME VARCHAR (6) >CNO CHAR(2) Indexes HI student SNAME VARCHAR (6) SNO CHAR(2) Indexes H result ?SNO CHAR(2) CNO CHAR(2) GRADE INT Indexes