EXPERIMENT 1
Database Design – Library Management System
AIM: Design a database schema and draw the ER diagram for a Library Management System.
Theoretical Background
This experiment covers database design – library management system. Design a database schema and draw the ER diagram for a Library Management System.
SQL Preview
mysql>
ER Diagram Description
Entities: Student, Book, Transaction, Employee, Reports. A Student can borrow multiple Books (many-to-many
via Transaction). An Employee can issue multiple Books. Reports reference Transactions.
Relational Schema / Table Creation
-- Create and use database
CREATE DATABASE IF NOT EXISTS LibraryDB;
USE LibraryDB;
-- Student table
CREATE TABLE Student (
StudentID INT PRIMARY KEY AUTO_INCREMENT,
Name VARCHAR(100) NOT NULL,
Department VARCHAR(50),
Course VARCHAR(50),
-- ... (see full code in SQL Code tab)
