City Library

When the user first enters the site they are greeted by a welcome page with 2 login fields and a link to a sign up page. The user can log in with either an admin account or a member account. When logged in the user taken to the welcome page, and from there the user can do a a variety of operations. For a member, they can search for a document in our database, either a book, dvd, or a journal. Once they search a user can reserve the document, and a member can reserve up to 5 documents at a given time. A member can also return a document and are charged a fine of 50 cents per day over 3 days. Moving on, the admins have the same capabilities as memebrs and more. Admin's can insert a new document and search the status (if the document is checked out) of a document. The admin also has several links to reports on different statistics. For example, an admin can see the top ten most frequent borrowers or the top ten most borrowed books.

The City Library was created as a school project in my Introduction to Database Systems course at Lake Forest College. In this project I was tasked to design a database with a graphical user interface using PHP, MySQL, and HTML. This project taught me how to create Enhanced Entity-Relationship diagram, convert that to a Relational data model, and finally create a fully functioning database using MySQL. I used HTML and CSS to create a coherent graphical user interface and then used PHP to allow the user to interact with the database. Though this project has been turned in, it is by no means finished. For example, the first thing I will add is a more enticing interface. While it has the functionality needed it is not as styled as I would like it to be. I will accomplish that using HTML and CSS. Next, I will add an encryption system to the users login details. As of now, the users details are plainly stored in the database.