Skip to content

shinchancode/Mini-Project-SQL-LibraryManagement

Repository files navigation

❕ Mini-Project-SQL-LibraryManagement ❕

This is a repository for DBMS Lab Mini Project in Second year Information Technology of SPPU!
Do star ⭐ this Repository if you feel it helped & drop a follow!

💙 Happy Learning 💙

Library Management System

Created a library management system of a particular institution to make the books and magazines available to the teachers and students remotely. Library Management System is a system which maintains the information about the books present in the library, their authors, the members of library to whom books are issued, library staff and all. This is very difficult to organize manually. Maintenance of all this information manually is a very complex task. Owing to the advancement of technology, Library Management System makes the task relatively easy.

FILE ATTACHED:

Complete Project pdf file

File having - SQL Queries to create database

Test Queries pdf File attached

ER DIAGRAM

image

Relational Database Design Using ER-to-Relational Mapping

image

RELATIONSHIPS-CARDINALITY

o Student issues BOOKS

o Student returns BOOKS

o Employee updates BOOKS

o Student registers the updates

Connect with me:

codeSTACKr.com codeSTACKr | Twitter codeSTACKr | LinkedIn codeSTACKr | Instagram