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

using c++

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
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Data Recovery Approaches
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
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