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
NAMES CODE
TUAN 8_BTTL
Studiu Individual 1
Mywall
get first parent with a value
Demo
Loan table
https://www.hsbc.co.in/ways-to-bank/online-banking/9247/
Stuff code in sql
exp7