Redemption MP v1

Page 1 / 3

Project Overview: This project is similar to DLSU's WEBOPAC. Redemption MP is open to all groups who want to replace their current MP grade. Whichever is higher will be followed in choosing your final MP grade. Groups who are interested should follow the prerequisites of the project before they will be qualified to defend their project. Prerequisite(s): Fill-up the form in https://sites.google.com/site/21112introdb/redemption-mp Demo Day Requirements: A Copy your Relational Model of your DB Due Date: Peding demo date: grade consultation day during consultation time ** Demo date may change depeding on the number of interested groups. Grading: Grade ceiling: 86 / 100 (3.5) General evaluation criteria for the database system: • Completeness of Software Functions • Correctness of Implementation and SQLqueries • User Interface Design • Overall Executability Unlike in regular MP demo, you will no longer be allowed to debug your system once your MP demo has started. You may choose to make the system web-based or application-based. Note that regardless of platform, this will not merit and points. Problem Description: A newly founded school has decided that it's high time that they create their own library. It aims to allow students to have a nice place to study and borrow books that they need. Because of this, DLSUCCS Inc. has decided to help the said school in forming the library by creating the system for them. As employees of DLSU-CCS Inc., your group has been chosen to develop the system for the library. In order for students to borrow a book, they must first submit an application form containing their basic details. The form contains the user's complete name (first name, middle name, last name), date of birth (day, month, year), address (lot number, street, region, country), email address and gender.

Redemption MP v1

Page 2 / 3

Additionally, the students should also provide their username and password which will be used to view a user's library activities and allow the library to keep track of the books as well. Once they have successfully registered, the users are now allowed to borrow books in the library. While borrowing, students are only allowed to borrow a maximum of 3 books at a time. Obviously, once a particular book has been borrowed, students are no longer allowed to borrow the book unless it has already been returned. When a student borrows a copy of a book, the system should record the date when the book was borrowed, the student who lend the book, the librarian who encoded the lending of the book and its due date as well (due date is always 7 days after the book has been borrowed). When returning a book, the system should record the returned date, the student who lend the book and the librarian who received the book. Books that are not returned on or before the due date are called overdue books. A student will be charged 20 pesos per overdue date per book upon returning of the borrowed overdue books. A student can also reserve for books wherein they may claim the book 2 days after it has been returned otherwise the reservation will be forfeited. Students may do a compounded searches (Combinations of book title, author and/or genre) or simple searches in the system such as book title, author, or genre alone. Results by default should be arranged according to its title, but the students may also opt to sort the books according to its title, author or genre or year. Librarians on the other hand are responsible for encoding the details of the book into the system. Moreoever, they are also reponsible for keeping track of the book activities as well. The same information as the students' should be also stored in the system for each librarian. An existing librarian is the one resposible for creating another librarian's account. They are also allowed to browse the activities of the books recorded in the system. A book can have lots of copies and each copy is given a unique identifier. Additionally, A book is identified through its call number aside from the call number, the librarian should input the book's author, title, call number, year of published and genre. A book can have many genres. In order to increase productivity and lessen the errors in encoding the needed data, book genres are saved in the system. Librarians are allowed to input new genres in case the genre of a particular book does not exists. Genre names are editable. Eventaually, a book copy's condition will deteriorate and will require refurbishing. Hence, a librarian should change a book copy's status to “Refurbish” and will not be available in the circulation. Aside from the basic needs of a typical library, DLSU-CCS Inc. also wants to provide some intelligence in the system. Once a librarian signs-in to the system the librarians should be able to see the borrowers and the number of books they have borrowed given a month of a year, the top 10 current borrowers of all time and the top 10 most borrowed books in the library of all time per genre and the top 10 most read author. On the student's side, they may browse through the previous details of the books they have already borrowed, their current reservations and the status of the book copy reserved. Below is a list of functions of to guide you in achieving your tasks: • Data Manipulation ◦ User Account Registration ◦ User Account Management ▪ Edit User Account Details ▪ Delete User Account

Redemption MP v1

Page 3 / 3

◦ Contents Management ▪ Add New Books / Copies ▪ Edit Book Details •

Data Retrieval ◦ Viewing of data and information through: ▪ Keyword Search ▪ Queries and Reports ▪ Domain Intelligence

•

Note: The ff. should be available for viewing immediate or upon user request. The result should be arranged and / or filtered accoring to some criteria. It is part of your task to determine the infomration to be included in the lists and reports, including the formatting and layout. Make sure your reports / messages / functions of your system is user-centric. ◦ List of Books ◦ List of Users ◦ View Book Reservations of (Borrower) ◦ View Reserved Books (Librarian) ◦ Per User's History ◦ Per Book's History ◦ User's Activity History ◦ Browse for book acitivies for a specific period ◦ Top 10's: ▪ User ▪ Book