Descriptions: ASSIGNMENT $-$ GROUP $(30\%)$

Learning Objectives

The aims of this course are to enable students to:

$$ Identify various database concepts, such as what is database, its users, components and its environments.

$$ Design database, using modeling Entity Relationship Diagram and normalization.

Date Assigned:

Week $2$

Due Date:

Week $7$

Objectives:

This assignment will enable the students to design a database for a given case scenario.

Cover Sheet:

As attached.

Learning Outcome:

Analyze, design a database solution to a specified commercial need.

Guideline

Refer to the assignment guideline given for the required information.

IMPORTANT NOTE:

This is a GROUP ASSIGNMENT, which consists of not more than FOUR $(4)$ members in one group. Each group is required to conduct study on the following given scenario and propose a database solution for it$.$

Specification:

A library management system consists with all the basic as well as some innovative features for managing library books in loan and inventory control system. It consists of a large database of various books available in the library. It also lists various books which has been issued$/$loaned to the respective readers$/$borrowers$.$ The system keeps track of all the books readily available and also the books that have been issued to various readers$/$borrowers for the time period for which the books have been issued. The system also handles books purchasing$/$ordering database. If the reader needs to purchase a book, he can order the book and request for home delivery by just submitting an online form. Borrowers usually tend to forget the date to return their library books, so this system would remind them before the due date of any borrowed books through email and the system will calculates fine depending on the expiry date. Thus this innovative library management system provides enhanced library functionality for this modern world.

Features of the system:$-$

$$ Admin login: The system will be under sole control of the admin. Admin can add or remove books from the system and also maintains records of the book available and issued in the library. The admin can even update the books details if required.

$$ User login: User has to first create an account in the system to gain access. User can explore and search for the books he wants. Each registered user can only borrow up to $3$ books and also place order for the books.

$5$

$$ Tracking the user record: The system can track the period for which the book has been issued to user and calculates fine if the book is not returned on time.

$$ Quantity Update$-$ The quantity is updated by the system depending on the quantity ordered.

$$ Fine calculation: If the user is unable to return the book, the system automatically calculates the fine that the user has to pay for subsequent days. $[$The system will charge RM$1$ for each day after the due date of the book$]$

$$ View date info$-$ The user can view the date when he has issued the book as well as the due date of the book and can view fine to be paid that is calculated by the system.

$$ Online search and order form: The user may order the book online. The system provides a search option where user can order online.

$$ Credit card payment: User can make payment via credit card.

Requirements

$1)$ Create the Schema, Database and Web$-$based system to support the modern Library Management System.

$2)$ Each group is required to develop website for the above system as a solution $($you do not need to create a working system, only the interfaces of the webpages, which consists of the required functionalities$).$

$3)$ Apart of developing a website, each of the group also need to come out with a report, which consists of the following sections: