Assignment 1 University Library System In this assignment you are going to implement your own version of university library system,The system will have two different sides , the first one is to help the librarian to do his job and the other side for admin to manage every one permissions in the system , so You should provide the following features in your system:  Admin view o Add/remove Students o Add/remove librarian o Add/remove other admins  Librarian view o Add/Delete books o Issue/Return books o View books o View Issued books o Log in /log out o Search for the book(id/name)  Simple backend for your system , You could use a file each row should represent item o Books File should be something like: Id , Book Name, Author Name, Available quantity, Issued Quantity 1,Oliver Twist, Charles Dickens,98,2 In the previous the first row was the name of each column , you can do that or handle it in your code , id =1 , Book Name =Oliver Twist ..Etc.  Tables needed o Books  Id  Book Name  Author Name  Available quantity  Issued quantity o Issued Books  Procedure ID  Book ID(Represent the book from Books table)   Student ID(Represent the Student from Students table)  Returned(True/False) o Students  Student ID  Student name  Student Birthday  Email  Mobile number o Librarians  Librarian id  Librarian name  Librarian password o Admins  Admin id  Admin name  Admin password  Technical requirements to check o No ID in any table should be repeated o When the librarian issue book to a student you should check the following  if the student is students table  if the book name or id in books table , if there are more than one book with the same , choose the first one.  if the available quantity >0  if the previous was true  You should decrease the available quantity in Books table  You should increase the issued quantity in Books table  You should add a record with the id of the student and book and returned = False in issued books o If a student Return a book You must do the opposite of the above but you don't delete the record from issued books, you should just change returned from returned =False to True o check if the name of student /admin/librarian /author is only characters o check if the student mobile number is number o No log in with a wrong password o Search for a book by id should return one book o Search for a book by name should return all the books with the same name o All of the implementation must follow objected oriented design o All of the classes attributes must be private and accessed by setter and getters

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Assignment 1 University Library System
In this assignment you are going to implement your own version of university library system,The system will have two different sides , the first one is to help the librarian to do his job and the other side for admin to manage every one permissions in the system , so You should provide the following features in your system:
 Admin view
o Add/remove Students
o Add/remove librarian
o Add/remove other admins  Librarian view
o Add/Delete books
o Issue/Return books
o View books
o View Issued books
o Log in /log out
o Search for the book(id/name)
 Simple backend for your system , You could use a file each row should represent item o Books File should be something like:
Id , Book Name, Author Name, Available quantity, Issued Quantity 1,Oliver Twist, Charles Dickens,98,2
In the previous the first row was the name of each column , you can do that or
handle it in your code , id =1 , Book Name =Oliver Twist ..Etc.  Tables needed
o Books
 Id
 Book Name
 Author Name
 Available quantity
 Issued quantity
o Issued Books
 Procedure ID
 Book ID(Represent the book from Books table)

  Student ID(Represent the Student from Students table)
 Returned(True/False) o Students
 Student ID
 Student name
 Student Birthday  Email
 Mobile number
o Librarians
 Librarian id
 Librarian name
 Librarian password o Admins
 Admin id
 Admin name
 Admin password
 Technical requirements to check
o No ID in any table should be repeated
o When the librarian issue book to a student you should check the following
 if the student is students table
 if the book name or id in books table , if there are more than one book
with the same , choose the first one.
 if the available quantity >0
 if the previous was true
 You should decrease the available quantity in Books table
 You should increase the issued quantity in Books table
 You should add a record with the id of the student and book and
returned = False in issued books
o If a student Return a book You must do the opposite of the above but you don't
delete the record from issued books, you should just change returned from
returned =False to True
o check if the name of student /admin/librarian /author is only characters
o check if the student mobile number is number
o No log in with a wrong password
o Search for a book by id should return one book
o Search for a book by name should return all the books with the same name
o All of the implementation must follow objected oriented design
o All of the classes attributes must be private and accessed by setter and getters

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Introduction to Template
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education