Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Flag question: Question 1 Question 1 5 pts Each customer in the database has placed at least one sales order which contains one or many

Flag question: Question 1
Question 15 pts
Each customer in the database has placed at least one sales order which contains one or many line items.
Group of answer choices
True
False
Flag question: Question 2
Question 25 pts
SOTotAmnt, SOLineAmnt, InvoiceLineAmnt, and InvoiceGrandTotal are all derived attributes that use values in other attributes for the calculation of the amount.
Group of answer choices
True
False
Flag question: Question 3
Question 35 pts
Each shipment record is only shipped against one sales order line item.
Group of answer choices
True
False
Only? What about SONo?
Flag question: Question 4
Question 45 pts
Not all sales orders require a shipment delivery to the customer.
Group of answer choices
True
False
Flag question: Question 5
Question 55 pts
Every product in the database has been purchased by at least one customer.
Group of answer choices
True
False
Flag question: Question 6
Question 65 pts
Each product (ProdID) can have different unit prices.
Group of answer choices
True
False
Flag question: Question 7
Question 75 pts
Each product is stored in only one warehouse.
Group of answer choices
True
False
Flag question: Question 8
Question 85 pts
Each warehouse stores one or many products.
Group of answer choices
True
False
Flag question: Question 9
Question 95 pts
Each warehouse can deliver multiple shipments to multiple customers.
Group of answer choices
True
False
Flag question: Question 10
Question 105 pts
The IsA relationship between super-type, Customer, and sub-type Online and Invoice customers, is
Group of answer choices
1:1
1:M
M:M
Flag question: Question 11
Question 115 pts
The same Product can have different OnHandQty in different warehouses.
Group of answer choices
True
False
Flag question: Question 12
Question 125 pts
Each online customer can use different credit cards for different purchases.
Group of answer choices
True
False
Flag question: Question 13
Question 135 pts
Inventory is an associative entity to resolve the M:M relationship between Product and Warehouse.
Group of answer choices
True
False
Flag question: Question 14
Question 145 pts
Each invoice is sent to only one customer after the order delivery which can contain one or multiple line items.
Group of answer choices
True
False
Flag question: Question 15
Question 155 pts
Billing address in the Invoice Customer sub-type entity is the same as the delivery address in the parent Customer entity.
Group of answer choices
True
False
Flag question: Question 16
Question 165 pts
Each customer (super-type) has one or many sales order. Each invoice customer or online customer (subtype) also has one ore many sales orders.
Group of answer choice
True
False
image text in transcribed

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

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

More Books

Students also viewed these Databases questions

Question

14.4 Analyze in detail three basic causes of accidents.

Answered: 1 week ago