Dec 20, 2021 Uncategorized

WhatABook Assignment at an Affordable Cost

WhatABook Requirements Scenario WhatABook, a small used book store has decided to expand their presence by offering customers a solution they can install on their personal computers. WhatABook would like to establish a console application that allows customers to browse their in-store book listing, add books to their Wishlist, and view store hours and locations. Right now, they only have one location, but the owner, Hugo Dopsen, is emphatic about expanding. Hugo would like the new applications interface to be as simplistic as possible. Most of their users will be middle aged customers with minimal computer experience. Customers will need to register for a free account by providing their email address, first, and last name. The program should support options for viewing a list of their in-store books, adding books to their Wishlist, and viewing store hours and locations. Business Rules ● a User can have many Wishlist books ● many Book(s) can be added to a User(s) Wishlist ● many Book(s) can be added to one Wishlist ● WhatABook has many Book(s) ● many Book(s) are owned by WhatABook ● WhatABook can have many Location(s) User Interface Requirements ● Menu ○ 1. View Books ○ 2. View Store Locations ○ 3. My Account ■ Prompt the user to enter a user_id ● 1, 2, or 3 ● Note: before a user can access their account, they must enter a valid user_id. ■ Wishlist Menu ● 1. Wishlist ● 2. Add Book ○ Display the the available books ■ The output will show the book_id, book_name, author, and details ○ Prompt the user to select a book to add to their wishlist ■ To add a book to the users Wishlist, the insert statement will need the book_id and user_id ● 3. Main Menu ○ This option takes users back to the main menu ○ 4. Exit Program ■ Exits the program Database Guidance WhatABook Requirements ● You do not need to create a table for WhatABook because the database will only support one company and it is inferred that Book(s) are owned by WhatABook ● You will need to create a separate table for WhatABook’s hours and locations because at some point they will expand to multiple locations ● There should only be four tables ● The courses GitHub repository has an initialization script to compare your code against mine. But, only use this as a last resort. To truly learn these topics, you will need to make an effort and try to complete the project on your own. Query Guidance ● To display a user’s Wishlist you will need to use two INNER JOINs to combine the user and book tables. ○ Store, Book, Wishlist, User ● To add a book to the users wishlist you will need to capture the selected book_id and user_id ● To view a list of books not in the users wishlist you will need to use the NOT IN operator with a nested query. ○ WHERE book_id NOT IN ( SELECT book_id FROM wishlist WHERE user_id = ); ● If you get stuck, the courses GitHub repository has an SQL script that includes all of the SQL queries. But, again, only use this as a last resort. To truly learn these topics, you will need to make an effort and try to complete the project on your own. User Interface Guidance/Hints ● Create a method to for “show_menu()” ● Create a method for “show_books(_cursor)” ● Create a method for “show_locations(_cursor)” ● Create a method for “validate_user()” ● Create a method for “show_account_menu()” ● Create a method for “show_wishlist(_cursor, _user_id)” ● Create a method for “show_books_to_add(_cursor, _user_id)” ● Create a method for “add_book_to_wishlist(_cursor, _user_id, _book_id)” ● Create a method to display the account menu ● Use variables to capture the user’s entry for user_id ● User variables to capture the user’s entry for book_id ● If you get stuck, the courses GitHub repository has the final solution to compare your code against. But, again, only use this as a last resort. To truly learn these topics, you will need to make an effort and try to complete the project on your own.

Want a similar task completed for you? Worry no more! Simply place your order at myessaydoer.com by clicking on the ORDER NOW option.

Myessaydoer’s team of experts is available 24/7 to assist you in completing such tasks. We assure you of a well written and plagiarism free paper. Place your order at myessaydoer.com by clicking on the ORDER NOW option and get a 20% discount on your first assignment.