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...
-
A couple plans to pay their child's college tuition for 4 years starting 18 years from now. The current annual cost of college is C$7,000, and they expect this cost to rise at an annual rate of 5...
-
On April 1, 2017, Faircloud Variety Company deposited $24 000 into a savings account earning simple interest of 1.5%. How much interest was paid to Faircloud's account on June 30, 2017?
-
Figure 20.21 shows the flowsheet for a reactive distillation column for the production of ethylene glycol (EG) from ethylene oxide (EO) and water (Al-Arfaj and Luyben, 2002):...
-
ABC, activity area cost-driver rates, product cross-subsidization Idaho Potatoes (IP) operates at capacity and processes potatoes into potato cuts at its highly automated Pocatello plant. It sells...
-
The assets and liabilities of Thompson Computer Services at March 31, the end of the current year, and its revenue and expenses for the year follow. The common stock was $118,300 and the retained...
-
Consider the state diagrams of Figure 12.28. a. Describe the behavior of each. b. Compare these with the branch prediction state diagram in Section 12.4. Discuss the relative merits of each of the...
-
1. A Ford pickup truck is pulling a trailer filled with concrete blocks (total mass 3000 kg) up a ramp that makes a 20 degree angle with the horizontal. The Ford truck exerts a 11,000 N towing force...
-
Actual November 2 Actual December 2021 North Actual January 2022 North Actual rebruary 20 North Actual April Actual May Actual June Actual July 2022 North 2022 North 2022 North 2022 North Actual...
-
You are required to create a logical network diagram for the entire new network. This means that Sydney will be a branch office in your diagram and Tech Park will exist. This course does not have a...
-
A boy is pulling his sister in a wagon, as shown in the figure. He exerts a force of F = 42.5 N at an angle of 30. How much work does the boy do pulling his sister, in joules, if he pulls her 29 m? F...
-
2. (15 pts) Two fair coins are flipped and player I is allowed to view the outcome, player II is not. Player I can fold and pay player II $2, or stay. If player I stays, then player II must try to...
-
Question 1 of 2 View Policies Current Attempt in Progress Hale Company Janish Company Valdez Company (a) Oriole Company has a balance in its Accounts Payable control account of $8,170 on January 1,...
-
A company pledges their receivables so they may Multiple Choice Charge a factoring fee. Increase sales. Recognize a sale. Collect a pledge fee. Borrow money. Failure by a promissory notes' maker to...
-
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?
-
The accountant for Elite Security Services Ltd reviewed the following information for accounts receivable: For the financial year 2022 - 2023 1. At 1 July 2022, Allowance for Doubtful Debts had an...
-
On 1 June, Sugar Rush Ltd had Accounts Receivable and Allowance for Doubtful Debts accounts as below. GST Inclusive. The following transactions occurred during the month of June: 5. Credit sales...
-
Outback Get Away Ltd sells four-wheel drive accessories and recovery equipment on credit. The accounting records at 30 June 2023 highlights the following. Ignore GST. In the past, the companys yearly...
Study smarter with the SolutionInn App