Assignment: Database Systems
DEVELOP A LIBRARY MANAGEMENT SYSTEM DATABASE PROJECT.
We need to use MySQL and for GUI Interface for input and output we can you any platform.
A student and faculty can issue books. Different limits for the number of books a student and teacher can issue. Also, the number of days will be distinct in the case of students and teachers for issue any book. Each book will have different ID. Also, each book of the same name and same author (but the number of copies) will have different ID. Entry of all the book will be done, who issue that book and when and also duration. Detail of Fine(when the book is not returned at a time) is also stored.
Deliverables:
• Copy of code
• Report:
o Title page (project name, semester, course, instructor name)
o Project description (include list of programming languages, tools, etc. used and its version)
o ER/EER diagrams
o Print screens of interfaces/forms (screenshots of GUI full and empty)
o Print screens of tables of MySQL
o Print screens of reports (screenshots of GUI used for output with data)
o List of queries (for example, list all, list book names, etc.)
o Conclusion. Reflect on your experience completing this project as an individual.
The good and the bad. Time spent. Tools, programming languages, etc. you learnt on your own to complete the project. Etc.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.