Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MySQL Q.3) (20 points) Write an INSERT statement using a column list to add this row to the orders table. Pay careful attention to the

MySQL
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Q.3) (20 points) Write an INSERT statement using a column list to add this row to the orders table. Pay careful attention to the comments below. order_id: /*The next automatically generated ID*/ customer_id: 6 order_date: Assume the order is taken on September 25, 2017, at 11:35:18 AM* ship_amount: 5 tax amount: 0 ship_date: /*Do not hard code the date and time; use a function that will insert the date and time at the moment when the record is added. */ ship_address_id: /* Hard-code the address_id value of the record added in Q.2 * card type: Visa card number: 1234567890123456 card_expires: 06/2020 billing_address_id: 8 my guitar_shop Tables addresses | Columns address id customer_id linel line2 city state zip_code phone disabled Indexes PRIMARY addresses_fk_customers Foreign Keys addresses_fk_customers | order-items -Columns item_id orderid - product_id item-price discountamount - quantity Indexes PRIMARY items fk orders items_fk_products Foreign Keys items.fk-orders Triggers Columns items_fk_produds orders order-id order_id customer_id order date ship-amount tax amount ship_date ship-address-id card_type card_number card-expires billing address_id ep Indexes PRIMARY ordersfkcustomers - - VE Foreign Keys orders_fk_customers ] Triggers products [05] Columns o columns product_id category_id product-code product-name description list-price discount-percent dateadded - ep Indexes PRIMARY product-code products-fk. categories VE Foreign Keys products_fk_categories Triggers Views Stored Procedures Functions

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

More Books

Students also viewed these Databases questions