Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help designing a database schema for an online web application bookstore which needs the following features: 1. Book browsing and sorting (users can

I need help designing a database schema for an online web application bookstore which needs the following features:

1. Book browsing and sorting (users can browse books by genre, top sellers in the book store, and book rating with pages based on 10 to 20 results. Sort is allowed by book title, author, price, book rating, and release date.).

2. Profile management (Users can manage their login credentials (ID, password), personal information (name, email address, home address), nickname for book rating and commenting, credit card information (multiple), and shipping address (multiple).

3. Shopping cart (Users can easily access their cart from any page, view the same information displayed in the book list, change the quantity, remove it from their cart, or save it for later.)

4. Book details (Display book name, book cover (which can be enlarged when clicked), author and bio, book description, genre, publishing info (publisher, release date, etc.), book rating, and comments.)

5. Book Rating and Commenting (For Rating: Use a five-star rating system. Users can only rate a book if theyve purchased it, and may select whether they show their nickname (defined in their profile) or remain anonymous.).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions