Please enable JavaScript.

Coggle requires JavaScript to display documents.

BookBird :books: :bird: - Coggle Diagram

- - - - Includes reviews on Audiobooks
      - Displays information about book such as author, release date and page count
      - Able to read a sample of the books (such as one chapter) for the user to decide whether to buy the book
    - - Audio narration of written book
      - Sign-in option to Amazon for user to access app on many devices
    - - Able to keep a wishlist of books to read later
      - Small section in home screen to explore new books
      - Option for user to "shelf" books or to organize them to their preference
- - - - Time-rich
      - May like more children's genres (action, feel-good stories, comics)
      - May be willing to read books with larger page counts
    - - May not be interested in books due to not finding it enjoyable
      - Time-rich
    - - May like more mature topics (drama, romance, mystery etc.)
      - Would want to finish books quickly
      - Time poor
- - - - Users able to use passwords to protect their account (Safety)
      - Have common icons in the same place in the app (Effectiveness, Learnability)
      - While a book is being searched, suggestions of the book will be displayed for book search using the LIKE operator of SQL coding (Effectiveness, Accessibility, Utility)
      - Ability to change language settings (Accessiblity, Effectiveness, Learnability)
      - Using a filter to find specific books based on user preferences (accessibility, effectiveness, utility)
      - Using common icons already used in other apps (utility, learnability)
      - VoiceOver compatible, increasing accessibility for visually impaired people (accessibility, utility, learnability)
    - - Explore Screens
        
        Users able to search books based on preferences by using a filter, which will organise books in terms of genre, page length, price and review score for the user to easily find a book to read
      - Book Screen
        
        Title, description, rating, publisher and page length and genre of a book will be displayed for the user to learn about the book and decide whether to read it or not
      - Settings Screen
        
        Access to accessibility settings such as font size change, language settings, colourblind filter, dark mode etc.
      - Reading Screen
        
        Purchased books and books on Wishlist will be shown in this list for user's convenience
      - Goals screen
        
        Users will be rewarded for reading a set amount of pages everyday by the system of points
  - - - Search filters for finding books (using SQL)
        
        Searching for movies by title by using a WHERE statement
        
        Suggesting books for users based on similar words using a LIKE statement and the % wildcard (If person wants to type "Matrix", he/she types "Matr__" and suggestion for matrix will pop up)
        
        Searching by genre by using user's input to search for specific genres
        
        Searching by page count of title by finding titles with page counts lesser than user input
        
        Using ORDER BY statement to find highly rated books from review score
        
        Searching by price of title by finding titles with page counts lesser than user input
      - Goal Screen
        
        Creating a goal for the user to follow (Notification to appear everyday if user allows)
    - - Keynote
      - Language: SQL, Swift
    - - SELECT rating from from reviewInformation WHERE rating > (INPUT) GROUP BY rating asc;
        
        Provides books with a rating above a certain number (3+ stars, 4+ stars
      - SELECT title from Book Information where title LIKE '(INPUT)'%;
        
        In a search that has half the name of the book, the results will show the complete title/s
      - SELECT page count from bookInformation WHERE page count < (INPUT) GROUP BY page count desc;
        
        Provides books with a page count lesser than the user inputs, orders by descending order
      - SELECT price from priceInformation WHERE price < (INPUT) GROUP BY price desc;
        
        Provides with books that are under a price of user's input to provide with a book that's in a user's budget
      - SELECT genre from bookInformation WHERE genre = (INPUT);
        
        Provides user results of books only with specific genres in accordance to user input
  - - - Price
      - Voters
      - Currency
      - Rating
      - Description
      - Author
      - Title
      - publisher
      - genres
      - page_count
      - ISBN
      - published_date
      - language
    - - SQLite database
      - bookInformation
      - genre_information
      - wishlist
      - user_information
    - - books.csv
        
        Pros
        
        Extensive information on reviews
        
        Cons
        
        Mostly information of reviews and ratings, no other relevant information such as description and genres
      - books2.csv
        
        Pros
        
        Addition of genres and price
        
        Extensive description of book
        
        Cons
        
        Duplication of publishers
        
        Typos in dataset
        
        Dataset columns are numbered however the column for the numbers are not titled