Question

create a view named course_student_details which has the following attributes. Student Id, first name , and course name which they have registered ​

Answer 1

Answer:

Course: Courseid, Coursename, Duration, Fees

Registration: Courseid, Studid, Doj

Student: Studid, Firstname, Lastname, Street, City, DOB

Explanation:

create view course_student_details as

select s.first_name, s.last_name, c.course_name

from students s

inner join registration r on r.stud_id = s.stud_id

inner join course c on c.course_id = r.course_id

Answer 2

Answer:

Create a view named course_student_details which has the following attributes. Student id, first name, and course name which they have registered.

Correct Answer is:

-----------------------------

create view course_student_deatils as

select s.FirstName,s.LAstName,c.CourseName from STUDENT s

inner join registration r on r.Studid=s.Studid

inner join course c on c.courseid=r.cousreid

Explanation: