Database Systems
( Grading rubric )
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
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.
( DEVELOP A LIBRARY MANAGEMENT SYSTEM DATABASE PROJECT )
• Upload code and report to this drop box.
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
(w
hen 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
ver
sion)
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 pr
oject. Etc.
•
Upload code and report to this drop box.
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.
• Upload code and report to this drop box.