amer-sabah/bookshelf

bookshelf's Issues

As a Library owner, I want to return a borrowed book to the system so other customers can borrow it.

The use case description

Use case name: Return borrowed book

Brief description: Library owner return a borrowed book to the system.

Actor: Library owner

Preconditions: Customer borrowed a book.

Main flow:

1. Customer returns the book.
2. Library owner opens the borrowed books page
3. Owner selects the book.
4. Owner clicks return.
5. System update the book status.

Postcondition: The book can be borrowed.

Alternatives: None

Rest APIs

As a system admin, I want to inactivate library so that it user cannot use it.

library(id , library_name, location, image, owner_id)
system_admin (id , username, password)

As a system admin, I want to delete library so that it delete from system.

Required tables :
library(id , library_name, location, image, owner_id)
system_admin (id , username, password)

AS a customer, I should be able to rate each library in the system depending on the categories variety

Category (Rating, ……)

As a customer, I want to watch my books history so i can track the my history

As a library owner , I should be able to add book status to able the customer choose the available books

As a library owner , I want to search order history for user so i can track the user history

As a system admin, I want to add library so that it can view for users.

**Required tables :
library(id , library_name, location, image, owner_id)
system_admin (id , username, password)
**

As a customer, I want to search for a book so that i can buy or borrow it

Tables: Book, Category, Author
Attributes: Author -> PK: author_id, author_name
Book-> FK: author_id

AS a customer, I should be able to rate reading area in each library so that increase the customer satisfaction

Tables:
Reading area(Rate , Capacity, ....)

Security (Authentication and Authorization)

Login/Signup

Permissions

As a system admin, I want to search for a book so that i can delete books that out of stock.

Tables: Book
Attributes: Book-> number_of_Books

as a lib owner , i want to update number of books so that i organize buying and renting process .

As a customer, I want to borrow a book so that I can go to the library and take that book.

As a customer, I should be able to rate the book content.

Database schema & data scripts

Schema EDITED.txt

As a Library owner, I want to review any customer borrowing history.

As a customer, I want to choose a books that i need so i can buy it.

As a Lib owner, I want to delete book from book list so that user can't buy or borrow it.

Tables: Book

As a system admin, I want to delete books that out of stock.

Tables: Book
Attributes: number_of_Books.

As a Customer, I want to review my borrowing history.

As a system admin, I want to accept request to add library so that it can view for users.

Required tables :
library(id , library_name, location, image, owner_id)
system_admin (id , username, password)

As a customer, I want to watch book status so i can buy it if it is available

As a Lib owner, I want to search for a book so that i can see the book's rating.

Note: System admin and customer also can do it

Tables: Book
Attributes: Book-> book's_rate

Req:
Show the book rating in the stock management page

UX Navigation

As a library owner, I want to update library information so that it can view for users.

Required tables :
library(id , library_name, location, image, owner_id)
owner(id , username, password)

as a lib owner , i want to add book so that i will increase number of copies of that book

required tables:
owner(id ,username ,password) ,
library (id ,name ,location , owner_id )
book(id ,name)
books_in_library(library_id , book_id , number_of_copies)

AS a customer, I should be able to rate delivery service

AS a customer, I should be able to rate delivery service

As a Lib owner, I want to add book so that user can buy or borrow it

as a lib owner , i want to add new book after checking.

required tables:
owner(id ,username ,password) ,
library (id ,name ,location , owner_id )
book(id ,name)
books_in_library(library_id , book_id ,number of copies )

as lib owner , i want to delete book

required tables:
owner(id ,username ,password) ,
library (id ,name ,location , owner_id )
book(id ,name)
books_in_library(library_id , book_id ,number_of_copies )

As a customer, I want to buy a book

As a library owner, I want to add library information so that it add to system after admin accept it.

Required tables :
library(id , library_name, location, image, owner_id)
owner(id , username, password)

As a customer, I want to watch my books bag so i can change or complete my ordarding

AS a customer, I should be able to rate my purchased/borrowed books

Rating(book_id , Library_id , customer_id , rate , feedback)

As a library owner, I want to inactivate library so that it user cannot use it.

library(id , library_name, location, image, owner_id)
owner(id , username, password)

As a Lib owner, I want to add book so that user can buy or borrow it

Tables: Book, Category, Book'sCategory
Attributes: Book -> book_id, book_name, etc.
Category -> PK: Category_id, Category_name
Book'sCategory -> FK: book_id, FK: Category_id (Many-to-Many)

Req:

• Lib owner requests to add a new book with its details
• Admin will accept or reject the request

As a Lib owner, I want to update number of books in stock so that system admin can offer book for sale.

Tables: Book
Attributes: number_of_Books.

AS a customer, I should be able to give written feedback of books content so that guide other customers on choosing books

Book (Feedback, ……..)