Structure Query Language Optimization

This project describes implementation of a library management system using SQL. We used the Entity-Relationship model to design a database that will store and organize the Library & Road Traffic Offence data. We have created the database using SQL and populated it with some sample data. The system can keep track of library cards, users, librarians, books, journals, and the relationships between them, track offenders, store information and calculate fee etc. Graphical user interface that allows users to access the system easily was used through the aid of filemaker. Pro DBMS.