Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fix my SQL code Create table Customer ( CustID INT NOT NULL CustFName CustLName CustStreet CustCity CustState CustZip CustPhone CustEmail IsMember MemExpiration CONSTRAINT CustID PRIMARY
fix my SQL code
Create table Customer (
CustID INT NOT NULL
CustFName
CustLName
CustStreet
CustCity
CustState
CustZip
CustPhone
CustEmail
IsMember
MemExpiration
CONSTRAINT CustID PRIMARY KEY
CONSTRAINT FOREIGN KEY
);
AutoSave OFF BES Home Insert Draw Page Layout X Paste N15 E 1 custCity 2 Dayton OH 3 Dayton OH 4 Cincinnati OH 5 Dayton OH 6 Cincinnati OH 7 Cincinnati OH 8 Cincinnati OH 9 Dayton OH OH 10 Dayton II 11 Chicago 12 Chicago 13 Chicago 14 Chicago 15 Chicago 16 Chicago 17 18 19 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 X IL IL IL IL IL F G H custState custZip custPhone Calibri (Body) BIU Drone fx 11 Customer Formulas Data Review View Tell me V A A A Order custEmail I == 41073 937-111-2222 dan.hall@email.com 45469 937-222-3333 joe.smith@email.com 41073 513-333-4444 jane.wellington@email.com 45469 937-444-5555 kevin.johnson@email.com 41073 513-555-6666 dave.jones@email.com 41073 513-666-7777 katie.williams@email.com 41073 513-777-8888 jen.anderson@email.com 45469 937-888-9999 matt.white@email.com 45469 937-999-1111 beth.martin@email.com 60601 (773) 397-4563 EddieLoudermilk@mail.com 60604 (312) 337-3820 DonnyWalker@mail.com 60604 (312) 247-1500 60603 (773) 536-8484 CatrinaStanton@mail.com Buyunglwang@mail.com 60603 (312) 337-8021 60605 (312) 335-7232 JoshuaAllbaugh@mail.com J K isMember Mem Expiration. false false false false true true false false true true true Michael Demopolos@mail.com false false false false Delivery 210 Store EE 2021-12-4 2021-12-4 2021-12-4 2021-12-4 2021-12-4 ab Wrap Text v Products Merge & Center L Dataset_EP-updated OrderLine General Formula Bar + 70 M + N 9 0 .00 .00 .0 P U Conditional Format Cell Formatting as Table Styles Q R S T Insert v Delete v Format v U O V Share 28. 0. B Ideas Sort & Filter Find & Select # B W E X Y Z Qa Comments Sensitivity AA 100%
Step by Step Solution
★★★★★
3.37 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
There are several issues in the provided SQL code Specify the datatypes for the columns Include the ...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