Chapter -11 : Practice Questions & Materials

Raw data has order level information one of the largest Supermart in USA. Us the data to create the following tables

Put date validation on order date column

Apply string length validation on customer id. The customer id should be exactly 17 letters long

List validation on

Customer Type

Salesman

Shipping Distance

Shipping City

Delivery Speed

Shipping Contain

Product Category

Ship Mode

Product Container

Listing price should not be more than $1200

Quantity ordered cannot be zero

Discount should not be more than 20%

Shipping Charges , Delivery Charges, Customer Payable should be numerical

⁠

Workbook (2).xlsx

382.9 kB

⁠

⁠

4.2 Workbook - Data Validation Solution (1).xlsx

389.5 kB

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.