Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called "my_first_database". 2) create a table called "customer_t". The table should include the following column: Customer ID, Customer_Name, Email, City, and Country. 3) add a new column Customer Age to the table "customer_t". 4) delete the column Email from the table "customer_t"! 5) delete the entire table "customer_t". Use CREATE, INSERT, DELETE, and UPDATE commands to write the SQL codes. 1. create a Persons table with the following column: Full names, Age, Gender, City 2. Insert the following two rows in the person table. Full names Age Sheldon Cooper 30 Janet Jones 20 3. Change the city to San Francisco for Janet Jones. 4. Delete the record of Sheldon Cooper. gender Male Female City LA LA € Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called "my_first_database". 2) create a table called "customer_t". The table should include the following column: Customer ID, Customer_Name, Email, City, and Country. 3) add a new column Customer Age to the table "customer_t". 4) delete the column Email from the table "customer_t"! 5) delete the entire table "customer_t". Use CREATE, INSERT, DELETE, and UPDATE commands to write the SQL codes. 1. create a Persons table with the following column: Full names, Age, Gender, City 2. Insert the following two rows in the person table. Full names Age Sheldon Cooper 30 Janet Jones 20 3. Change the city to San Francisco for Janet Jones. 4. Delete the record of Sheldon Cooper. gender Male Female City LA LA €
Expert Answer:
Answer rating: 100% (QA)
A 1 Create database myfirstdatabase 2 Create table cu... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
You have a retirement account that earns 5 percent annual interest with the total account balance of $400,000. How much a year can you withdraw for next 20 years if your first withdrawal starts a...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Children out of School in America is a report on delinquency of school-age children prepared by the Childrens Defense Fund (CDF), a government-sponsored organization. Consider the following three...
-
Two players, Robert and Carol, play a game with payoff matrix (to Robert) (a) Is the game strictly determined? Why? (b) Suppose that Robert has strategy [.7 .3]. The opponents agree that the game...
-
For the wire form shown, the wire diameter is d, the length of the straight section is l, and Youngs modulus is E. Consider the effects of bending only, with d (a) Use Castiglianos method to...
-
What are three value drivers for a major retail store, such as Macys or Home Depot ? Do any of them have a limited life span? Explain.
-
The trial balance of Pacilio Security Services Inc. as of January 1, 2020, had the following normal balances: Cash ..................$122,475 Petty cash ................ 100 Accounts receivable...
-
Zion, Inc. has one employee who has worked January - June of the current year. The employee is single, paid weekly, and claims two allowances on her W-2. The company is in a state that has no state...
-
One criticism of Hofstedes work is that the scores on each dimension reflect only an average tendency of a particular country and, therefore, inadequately reflect the wide range of responses given...
-
Assuming the following level of cost-driver volumes for a month, what are the accounting department's estimated costs of doing business using the account analysis approach? 980 paychecks processed. ...
-
Explain the position of Contingency Theory.
-
Explain the difference in status between a superior and a subordinate.
-
How can smoking exert a positive externality on others?
-
Identify the four steps of the KEYS process.
-
Comment on the free rider problem in the context of global climate agreements. How does recent historical experience with the Kyoto Treaty and the Paris Agreement relate to this problem?
-
State of the Economy Probability PROBABILITY HOLDING RETUN PERIOD BOOM 0.30 18% Normal growth 0.50 12% Recession 0.20 -5% a) What is the expected holding-period return? b) What is the expected...
-
What are current assets and current liabilities? How are they different from non-current assets and non-current liabilities?
-
What is a visibility symbol in UML?
-
Assume that you need to withdraw $100 from your checking account using your banks ATM machine. What set of steps does the DBMS need to perform to complete your transaction?
-
What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?
-
A W14 \(\times 30\) structural A992 steel column is pin connected at is ends and has a length \(L=12 \mathrm{ft}\). Determine the maximum eccentric load \(P\) that can be applied so the column does...
-
A W16 \(\times 45\) structural A992 steel column is fixed at the base and free at the top and has a length \(L=8 \mathrm{ft}\). Determine the maximum eccentric load \(P\) that can be applied so the...
-
Determine the \(\operatorname{load} P\) required to cause the steel \(\mathrm{W} 12 \times 50\) structural A-36 steel column to fail either by buckling or by yielding. The column is fixed at its...
Study smarter with the SolutionInn App