Question

Use the following tables given below and write queries for the below situations
Student(StudentId, Name, Branch, Institute)
Exam(CourseNo, Course Name, Dateof Exam)
Appeared(StudentId, CourseNo)
(a) List the details of exam conducted for course number 8 or 12.
(b) List the StudentId, his name and the course in which he appeared for exam.
(c) List the name of all the students who study in "Satyam" institute
(d)Find total number of student registered in the course number 4.
(e) List the course name, date on which exam was conducted and names of the all the students who appeared in that exam.
(f) List the course number and name of the course whose exam is to be held on 12/2/2012
(g) List the details of the exam whose course number is 8 or 10 and date of exam is 2/2/2012
(h) List the branch of student whose name starts with alphabet A.
(i) Delete all the records of ABC Institute.

Answer 1

Explanation:

hivvhiihvihivhvhiivhviovyhvihov

Answer 2

heya mate

option i)Delete all the records of ABC Institute