School: University of the People
Moodle ID: C110223808
CS 2203-01 Databases 1 - AY2026-T2
Assignment: Unit 4 – Structured Query Language (SQL)
University: University of the People
Instructor: Sugam Saini.
Library Database System – SQL Implementation.
Managing data efficiently is essential for any library, especially when tracking books,
members, and borrowing activities. For this project, I designed a simple but functional
database schema using SQL. The database includes three main entities: Books, Members,
and Loans. Each table captures key information required to support daily operations such
as adding new books, registering members, and recording loans.
The Books table stores details like ISBN, Title, Author, Genre, and Quantity. This makes
it possible to monitor which books are available and how many copies remain. The
Members table keeps track of the people who use the library, including their MemberID,
Name, Email, and Phone. The Loans table acts as a link between books and members by
recording who borrowed what, along with the loan and return dates. Together, these
tables create a simple relational structure that supports basic library functions.
Below is the SQL script used to implement the schema and operations. Comments are
included to explain the purpose of each part.
SQL Script
This design keeps the database simple, avoids redundancy, and supports common library
tasks. By using primary keys and foreign keys, the database maintains consistency
between the tables. The SQL queries demonstrate how data can be inserted, retrieved,
updated, and deleted. Overall, this structure provides a practical foundation for a small
library system and can be expanded later if more features are needed.
References
Vidhya, S., et al. Database Management Systems. University of the People Library.
Coronel, C., & Morris, S. (2016). Database Systems: Design, Implementation, &
Management. Cengage Learning.