pp.sql

create database practise;
use practise;
create table students(
student_id int primary key,
`name` varchar(50),
email varchar(50)
);
create table courses(
course_id int primary key,
instructure varchar(50),
course_name varchar(50),
student_id int, foreign key(student_id) references students(student_id)
);
create table enrollment(
enroll_id int primary key,
student_id int, foreign key (student_id) references students(student_id),
course_id int, foreign key (course_id) references courses(course_id),
enroll_date varchar(50)
);
insert students values (1, 'tripti', 'tripti@gmail.com');
insert courses values (2, 'susma', 'math', 1);
insert enrollment values (3, 1, 2, '2012-05-12');

create view student_table as
select `name`, email, course_name, instructure, enroll_date
from students
join courses on students.student_id= courses.student_id
join enrollment on enrollment.course_id= courses.course_id;
select * from student_table;