mKDqdHAd

1DROP DATABASE IF EXISTS Library;
2
3CREATE DATABASE Library CHARSET 'utf8';
4
5USE Library;
6
7CREATE TABLE Books(
8	
9    Id INTEGER PRIMARY KEY AUTO_INCREMENT,
10	BookName VARCHAR(150) NOT NULL,
11    ReleaseYear YEAR(4) NOT NULL,
12	ISBN VARCHAR(20) NOT NULL
13    
14);
15
16CREATE TABLE Authors(
17
18	Id INTEGER PRIMARY KEY AUTO_INCREMENT,
19    Name VARCHAR(150) NOT NULL
20);
21
22CREATE TABLE AuthorsBooks(
23	Id INTEGER PRIMARY KEY AUTO_INCREMENT,
24    AuthorId INTEGER,
25    BookId INTEGER,
26    FOREIGN KEY (AuthorId) REFERENCES Authors(Id),
27    FOREIGN KEY (BookId) REFERENCES Books(Id)
28);
29
30INSERT INTO Books VALUES('Harry Potter',2002,'GK');
31INSERT INTO Books VALUES('The Runner',2012,'RB');
32INSERT INTO Books VALUES('The Little Prince',1990,'CB');
33INSERT INTO Books VALUES('Jane Eyre',1947,'CB');
34
35INSERT INTO Authors VALUES('Bozhidar Chilikov ');
36INSERT INTO Authors VALUES('Timotei Zahariev');
37INSERT INTO Authors VALUES('Marin Valentinov');
38INSERT INTO Authors VALUES('Marin Valentinov');