Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

fix my SQL code Create table Order ( OrderNum INT NOT NULL CustID ShippingStreet ShippingCity ShippingState ShippingZip OrderDate DeliveryChange PaymentInformation CreditConfirmation CONSTRAINT OrderNum PRIMARY KEY

 fix my SQL code

Create table Order (

OrderNum INT NOT NULL

CustID

ShippingStreet

ShippingCity

ShippingState

ShippingZip

OrderDate

DeliveryChange

PaymentInformation

CreditConfirmation

CONSTRAINT OrderNum PRIMARY KEY

CONSTRAINT FOREIGN KEY

Home Insert Draw Page Layout  1 2 J24 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 AutoSave OFF BES 5 20 21 22 

Home Insert Draw Page Layout 1 2 J24 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 AutoSave OFF BES 5 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 V Paste X P Ready A X A B orderNum custID 1001 C10 1002 C50 1003 C20 1004 C30 1005 CAO 1006 C100 1007 C90 1008 C70 1009 C140 1010 C90 1011 C80 1012 C60 1013 C20 1014 C90 1015 C60 1016 C70 1017 C90 Drone Calibri (Body) BIU fix C shippingStreet Michigan Ave. Main St. Second St. Main St. Park Ave. Keen Oak Way Lake St. Oak St. Jackson Drive Lake St. Washington Blvd. University Place Second St. Lake St. University Place Oak St. Lake St. Customer 11 Formulas Data Review View Tell me Order V A A A === Delivery D E F G H I OH OH 41073 2020-12-26 41073 2021-1-8 45469 2021-1-10 IL shippingCity shippingState shippingZip orderDate deliveryCharge paymentinformation Dayton Cincinnati Dayton OH Cincinnati OH Dayton OH Chicago Dayton OH Cincinnati OH Chicago IL Dayton OH Dayton OH Cincinnati OH Dayton OH Dayton OH Cincinnati OH Cincinnati OH Dayton OH 41073 2021-1-18 45469 2021-2-3 60601 2021-2-18 45469 2021-2-25 41073 2021-3-2 60603 2021-3-11 45469 2021-3-15 45469 2020-4-10 41073 2020-4-16 45469 2020-5-3 45469 2020-5-11 41073 2020-5-12 41073 2020-5-26 45469 2020-5-26 Store ab Wrap Text Products Merge & Center 24.99 credit 14.99 credit 24.99 credit 24.99 cash 24.99 credit 14.99 credit 14.99 cash 24.99 cash 14.99 credit 14.99 credit 24.99 cash Dataset_EP-updated 14.99 credit 24.99 credit 14.99 credit 14.99 credit 24.99 credit 14.99 credit OrderLine + General $ % 9 V J CreditConfirmation BCD85XYZ ABC34XYZ BCD34XYZ BCD52XYZ ABC24XYZ ABC64XYZ ABC86XYZ ABC55XYZ BCD48XYZ ABC93XYZ ABC72XYZ BCD68XYZ ABC17XYZ .00 .00 .0 K Conditional Format Cell Formatting as Table Styles L U M N O Insert v Delete v Format v P Q Share 28. 0. 3 Ideas Sort & Filter Find & Select R B E S T U Qa Comments Sensitivity V 100%

Step by Step Solution

3.36 Rating (143 Votes )

There are 3 Steps involved in it

Step: 1

It appears that your SQL code fragment for creating an Order table is incomplete as it lacks the data type definitions for various columns and proper ... 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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

Find the median for the set of measurements 2, 9, 11, 5, 6, 27.

Answered: 1 week ago

Question

How can Trip 7 prevent future supply chain uncertainties?

Answered: 1 week ago