fix my SQL code Create table Customer ( CustID INT NOT NULL CustFName CustLName CustStreet CustCity CustState
Fantastic news! We've Found the answer you've been seeking!
Question:
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
);
Transcribed Image Text:
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% 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%
Expert Answer:
Answer rating: 100% (QA)
There are several issues in the provided SQL code Specify the datatypes for the columns Include the ... View the full answer
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
What are the strengths and weaknesses of these capital budgeting methods? Match the term with the strengths and weaknesses listed for each of the four capital budgeting models. Capital Budgeting...
-
Explain how to apply the rules of Section (61)a to determine taxable items.
-
Locate the centroid x, y of the shaded area. Summarize your answer at the end of your solution. y y = a sin
-
Two spheres of mass 1 kg and 1 . 5 kg hang from the ends of two 1 . 5 meter long threads fixed at the ceiling point. The lighter sphere is pulled to one side so that its thread forms an angle of 6 0...
-
Determine the magnitude and coordinate direction angles of F3 so that resultant of the three forces acts along the positive y axis and has magnitude FR. Given: FR = 600 lb F1 = 180 lb F2 = 300 lb...
-
Question 1: The Bisection method: Consider the function f(x) = 3x + sin(x) ex. (1.1) Use the bisection method to determine a root of f(x) in the interval (0, 2), using up to ten iterations. (10)...
-
You are a sales manager for an office supply distributor in a large metropolitan area. What do you use as your basic control unit in creating territories? Why?
-
Scott Snapp contracted with Castle-brook Builders, Inc., which was owned by Stephen Kappeler, to remodel a house. Kappeler estimated that the remodeling would cost around $500,000. Eventually,...
-
It is Annie's birthday, and she received a new car for her birthday. The cost of the car, which is considered an asset, is $18,000. The car will depreciate over 20 years, with a Salvage value of...
-
Kaplan Computers manufactures high end computer systems for the graphics design industry. At the present time, the company makes three computers with the following characteristics: Computer 1...
-
b) using the values of the capacitor, inductance and resistance, calculate the valies of the circuit peak to peak currents and write them down in the table. c) insert the resistance Rs as indicated...
-
Explain the meaning of SST, SSR, and SSE, and how they are related to \(R^{2}\).
-
The owners of a motel discovered that a defective product was used during construction. It took seven months to correct the defects during which approximately 14 rooms in the 100 -unit motel were...
-
Define the elasticity of \(y\) with respect to \(x\) and explain its computation in the simple linear regression model when \(y\) and \(x\) are not transformed in any way, and when \(y\) and/or \(x\)...
-
A swift blow with the hand can break a pine board. As the hand hits the board, the kinetic energy of the hand is transformed into elastic potential energy of the bending board; if the board bends far...
-
Explain, intuitively and technically, why predictions for \(x\) values further from \(\bar{x}\) are less reliable.
-
In the Analysis phase, the development of the ____________occurs, which is a clear statement of the goals and objectives ofthe project. Documentation Flowchart Program specification Design is a...
-
Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....
-
What are the relative merits of using DAC or MAC?
-
What are the approaches to processing phrase and proximity queries?
-
Discuss the architecture of a DDBMS. Within the context of a centralized DBMS, briefly explain new components introduced by the distribution of data.
-
Most countries in Europe do not have stringent laws to protect whistleblowers. True/false
-
In view of significant financial losses to investors, corporate fraud does not really affect the U.S. economy and investor confidence. True/false
-
Auditors should not demand full access to the entire general ledger so that they can be more focused on the audit. True/false
Study smarter with the SolutionInn App