Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There are five questions listed below. Based on the content in the M04 Readings, answer each question. After completing, submit this assignment to the M04

There are five questions listed below. Based on the content in the M04 Readings, answer each question. After completing, submit this assignment to the M04 Assignment link on IvyLearn. 1. (8 points) Identify the tables from the given scenario. Book.com is an online virtual store on the Internet where customers can browse the catalog and select products of interest. Every book has a title, ISBN, year and price. The store also keeps the author and publisher for any book. For authors, the database keeps the name, address and the URL of their homepage. For publishers, the database keeps the name, address, phone number and the URL of their website. The store has several warehouses, each of which has a code, address and phone number. The warehouse stocks several books. A book may be stocked at multiple warehouses. The database records the number of copies of a book stocked at various warehouses. The bookstore keeps the name, address, email-id, and phone number of its customers. A customer owns several shopping carts. A shopping cart is identified by a Shopping_Cart_ID and contains several books. Some shopping carts may contain more than one copy of same book. The database records the number of copies of each book in any shopping cart. At that time, more information will be needed to complete the transaction. Usually, the customer will be asked to fill or select a billing address, a shipping address, a shipping option, and payment information such as credit card number. An email notification is sent to the customer as soon as the order is placed.

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

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions