Answered step by step
Verified Expert Solution
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 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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started