Informations

Here is the SQL file used in this project:

• LibraryDB.sql

Here is Book Search tool with 10 Books (used c++) :

• booksearch.cpp

ER Model

Here is ER-Model for Database :

SQL Schema Example

-- Content of LibraryDB.sql

CREATE TABLE authors (
    author_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL ,
    birth_year INT(11)DEFAULT NULL ,
    death_year INT(11)DEFAULT NULL
);

CREATE TABLE books (
    book_id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    author_id INT,
    publication_year INT,
    genre VARCHAR(50),
    available_copies INT,
    FOREIGN KEY (author_id) REFERENCES authors(author_id)
);

CREATE TABLE users (
    user_id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password_hash VARCHAR(255)NOT NULL,
    full_name VARCHAR(100)NOT NULL,
    email VARCHAR(100) NOT NULL ,
    phone_number INT(15) DEFAULT NULL
);