y8DndB1j

1DROP DATABASE IF EXISTS projekt_jg_mk;
2CREATE DATABASE projekt_jg_mk;
3USE projekt_jg_mk;
4
5CREATE TABLE Reservation_Status ( ID INT AUTO_INCREMENT, Name VARCHAR(4000) NOT NULL, PRIMARY KEY (ID));
6CREATE TABLE Rent_Status (ID INT AUTO_INCREMENT, Name VARCHAR(4000), PRIMARY KEY(ID));
7CREATE TABLE Library_Cards ( ID INT AUTO_INCREMENT, Card_Number VARCHAR(30), Owner_Last_Name VARCHAR(50), Owner_Phone_Number INT, PRIMARY KEY(ID));
8CREATE TABLE Authors ( ID INT AUTO_INCREMENT, First_Name VARCHAR(4000), Last_Name VARCHAR(4000), PRIMARY KEY(ID));
9------------------------------------------------------------
10--Tu wkleić kod reszty tabel i sunac to tworzenie tabeli
11CREATE TABLE Books(ID INT AUTO_INCREMENT, PRIMARY KEY(ID));    
12------------------------------------------------------------
13CREATE TABLE authors_books ( authors_id INT NOT NULL, books_id INT NOT NULL, FOREIGN KEY(authors_id) REFERENCES Authors(ID), FOREIGN KEY(books_id) REFERENCES Books(ID));
14CREATE TABLE Reservations ( ID INT AUTO_INCREMENT, Start_Date DATE, End_Date DATE, reservation_status_id INT NOT NULL, library_card_id INT NOT NULL, books_id INT NOT NULL, PRIMARY KEY(ID), FOREIGN KEY(reservation_status_id) REFERENCES reservation_status(ID), FOREIGN KEY(library_card_id) REFERENCES Library_cards(ID), FOREIGN KEY(books_id) REFERENCES books(ID));
15CREATE TABLE Rents ( ID INT AUTO_INCREMENT, Start_Date DATE, End_Date DATE, rent_status_id INT NOT NULL, library_cards_id INT NOT NULL, books_id INT NOT NULL, PRIMARY KEY(ID), FOREIGN KEY(rent_status_id) REFERENCES Rent_Status(ID), FOREIGN KEY(library_cards_id) REFERENCES Library_Cards(ID), FOREIGN KEY(books_id) REFERENCES Books(ID));
16
17INSERT INTO Authors(ID,First_Name,Last_Name) VALUES (NULL,"Adam","Mickiewicz");
18INSERT INTO Authors(ID,First_Name,Last_Name) VALUES (NULL,"Jan","Kochanowski");
19INSERT INTO Authors(ID,First_Name,Last_Name) VALUES (NULL,"Juliusz","Slowacki");
20INSERT INTO Authors(ID,First_Name,Last_Name) VALUES (NULL,"Stephen","King");
21SELECT * FROM Authors;