SQL-DAY-2/SQL_Query.txt at main · Deepakmuthu21/SQL-DAY-2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
create table course (
course_id int primary key,
course_name varchar(30)
);


create table score (
score_id int primary key,
score varchar(30)
);

create table batch (
batch_id int primary key,
batch_name varchar(30),
no_of_students int
);


create table tsak (
task_id int primary key,
course_id int,
no_of_task int,
task_completion int,
foreign key(course_id) references course(course_id)
);

create table mentor (
mentor_id int primary key,
course_id int,
batch_id int,
mentor_name varchar(30),
rating int,
foreign key(batch_id) references batch(batch_id),

foreign key(course_id) references course(course_id)
);
create table learner (
learner_id int primary key,
learner_name varchar(30),
course_id int,
batch_id int,
task_id int,

foreign key(task_id) references tsak(task_id),


foreign key(batch_id) references batch(batch_id),

foreign key(course_id) references course(course_id)
);