Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Creating tables in sql server
Demo
Exam_Final
MyWall
testing-2
SQL Server - DateFirst Example
test22
Test Link samll Data
Student
TRANSACTIONS