Library Management System Database Design 📚

📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=yldrIdoXiYk
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?video=yldrIdoXiYk

In this video, you can watch how I create a database design for a library management system.

A library management system, in this example, is an application for managing books, library members, the books the members borrow, and fines that are involved.

We'll start with a set of requirements, and slowly design the tables. We'll add primary and foreign keys, relate the tables to each other, and modify the tables as we go.

We'll end up with a final ERD (Entity Relationship Diagram) for this application.

Whether you want to see an example of the process of designing a database, or are curious about library management systems, or want to know more about database design, this video should be useful for you.

Timestamps:
00:00 Introduction
00:22 What is a library management system?
00:50 Our requirements list
02:08 Adding attributes to book
03:16 Adding attributes to author
04:10 Joining table
05:12 Add the member table
05:26 Add the loan table
07:08 Add the reservation table
7:47 Enhance the fine table
08:03 Add the fine payment table
09:45 Add lookup tables

Links:
Many to Many relationship video: https://www.youtube.com/watch?v=1eUn6lsZ7c4
Image of the final ERD: https://dbshostedfiles.s3-us-west-2.amazonaws.com/dbs/library_erd_final.png
SQL script to create these tables: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/library_management_create.sql

This SQL file will create the tables according to the design at the end of the video. It does not contain any data, but you can use the INSERT statements to add data.
The file also uses MySQL data types. If you want to run this on SQL Server, and you get errors, it's likely due to incorrect data types. This can be fixed by updating the data types to those that are found on the database.