exam.sql

create database library;
use library;
create table books(
book_id int primary key,
book_name varchar(50),
title varchar(50),
year_of_published int,
member_id int, foreign key (member_id) references members(member_id)
);
create table members(
first_name varchar(50),
last_name varchar(50),
member_address varchar(50),
member_id int primary key,
member_phone_number int
);
create table loans(
loan_id int primary key,
borrowing_date date,
return_date date,
member_id int, foreign key (member_id) references members (member_id)
);
create table authors(
author_id int primary key,
author_name varchar(50),
location varchar(50),
author_number int,
book_id int, foreign key (book_id) references books(book_id)
);
select * from books;