Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Lab assessment 2
create table student(sid integer primary key, sname varchar(15), department varchar(10), dob date); create table author(author_name varchar(10), age int not null, phone_no int unique); create table books(bid int primary key, title varchar(15), price float , author_name varchar(10)); create table borrow(sid integer,bid int, primary key(sid,bid), foreign key (sid) references student (sid) on delete cascade on update cascade, foreign key (bid) references books(bid) on delete cascade on update cascade);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Empresa
While Loop in SQL Server for Multiple Entries
Hack_this
TO find max marks of students
Sample
mc170403050
SO_20171230_SqlServer
group_concat in sql-server
28-02
Task1
Please log in to post a comment.