Answered step by step
Verified Expert Solution
Link Copied!

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 

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 ... 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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant Navathe

7th Edition

0133970779, 978-0133970777

More Books

Students also viewed these Databases questions

Question

What training is required for the position?

Answered: 1 week ago

Question

What are the relative merits of using DAC or MAC?

Answered: 1 week ago

Question

What are the approaches to processing phrase and proximity queries?

Answered: 1 week ago