Create view of Student ID,firstname,coursename

Question

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

It contains 3 tables

Course: Courseid, Coursename, Duration, Fees
Registration: Courseid, Studid, Doj
Student: Studid, Firstname, Lastname, Street, City, DOB

Are you trying to solve your homework here? Have you even tried something? — Ergi Nushi
– Ergi Nushi, Commented Apr 10, 2020 at 10:17
I tired the program but while I try to type it in the question it shows like this. "Your post appears to contain code that is not properly formatted as code. Please indent all code by 4 spaces using the code toolbar button or the CTRL+K keyboard shortcut. For more editing help, click the [?] toolbar icon." — user13267091
– user13267091, Commented Apr 10, 2020 at 10:20

GMB · Accepted Answer · 2020-04-10 10:08:45Z

-1

It seems like you want joins:

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

answered Apr 10, 2020 at 10:08

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create view of Student ID,firstname,coursename

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related