Skip to content

A Database Management System Course Project containing all the features, SQL scripts and options to serve as a DBMS for State Town Library 🚀

License

Notifications You must be signed in to change notification settings

Fashad-Ahmed/Library-Management-System

Repository files navigation

LIBRARY MANAGEMENT SYSTEM 🐱‍👤

A Database Management System Course Project containing all the features, SQL scripts, and options to serve as a DBMS for State Town Library 🚀

Project Members:

Introduction:

Our system is based on library management and book-keeping system. This project “Library Management System” contains data relevant to the books present in the library, which can be lent to the customers and details maintained by the staff. Along with the management of the system, we are also maintaining the records of issue statuses and publishers of the books.

Mission Objective:

The goal of the venture is to give ease in plausibility to both staff and clients. As per this particular interest loaning of books was finished by making enrollment of the client in a branch so that might follow the information applicable to the client as well as to the actual branch. In the interim, clients can produce an issuance status subsequent to getting a book to monitor it. Moreover, the staff is empowered to keep up with and update the situation with every one of the books in the library.

ERD:

ERD

NORMALIZED RELATIONAL SCHEMA:

RelationalSchema

DATBASE USED:

  • Oracle Live SQL (In first sprint only)
  • MySQL (Complete and Final version stands on it)

LANGUAGE:

  • SQL

TOOLS:

  • MySQL Command Line Client
  • MySQL Workbench

TABLES:

1

2

3

4

5

6PNG

7

8

9

USER PRIVILAGES & ROLE GRANTS:

Create user proof

user proof 2

grantPrev

grantstorole(Owner)

roletoFashad

schemaInUser

NOTE:

contributions welcome
The brief description of Project is presented in Project Report .pdf and Visually aided in .ppt

About

A Database Management System Course Project containing all the features, SQL scripts and options to serve as a DBMS for State Town Library 🚀

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published