-
Notifications
You must be signed in to change notification settings - Fork 0
/
tableSQL.txt
61 lines (47 loc) · 1.17 KB
/
tableSQL.txt
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
51
52
53
54
55
56
57
58
59
60
61
Creating Tables:-
--------------------
create database sb101project;
use sb101project;
-----Admin Table-----------
create table admin(
username varchar(50) unique not null,
password varchar(20) unique not null
);
------Faculty Table---------
create table faculty(
facultyId int primary key auto_increment,
facultyName varchar(50),
facultyAddress varchar(50),
mobile varchar(10),
email varchar(30),
username varchar(50),
password varchar(20)
);
---------Course Table-----------
create table course(
courseId int primary key auto_increment,
courseName varchar(20),
fee int,
courseDescription varchar(50)
);
---------Batch Table-------------
create table batch(
batchId int primary key auto_increment,
courseId int,
facultyId int,
numberOfStudents int,
batchStartDate date,
duration varchar(15),
foreign key (courseId) references course(courseId),
foreign key (facultyId) references faculty(facultyId)
);
----------CoursePlan table==========
create table coursePlan(
planId int primary key auto_increment,
batchId int,
daynumber int,
topic varchar(15),
status varchar(10),
foreign key (batchId) references batch(batchId)
);
------------------------------------------------------------