Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Dbms_20181cse0068
create table student(usn varchar(20) primary key ,sname varchar(20) not null,address varchar(20),gender varchar(10),phone int ) ; create table semsec(ssid int primary key, sem int, sec varchar(10)); create table class(usn varchar(20) , ssid int, foreign key(usn) references student(usn) on delete cascade, foreign key(ssid) references semsec(ssid) on delete cascade) ; create table subject(subcode varchar(10) primary key , title varchar(20) unique,sem int, credits int, ssid int, foreign key(ssid) references semsec(ssid) on delete cascade) ; insert into student values(1,'nithesh', 'Banglore','male', 1234); select *from student ; insert into student values(2,'hari','hyderabad', 'male', 1245); insert into student values(3,'sam','hyderabad', 'female', 4321); insert into student values(4,'yash','pune', 'female', 4561); insert into student values(5,'harika','rajankunte','female', 12678); select *from student ;
run
|
edit
|
history
|
help
0
28-02 3
tarefaum
1512081 QUAN LY DE TAI
BT SQL Project
hdudh
Cinema latinoamericano
sqript for print !00 numbers with out loop
arithmetic
New
ankit