Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Use CREATE, DROP, and ALTER commands to write the SQL codes. 1) Create a database called

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

Step by Step Solution

3.46 Rating (146 Votes )

There are 3 Steps involved in it

Step: 1

A 1 Create database myfirstdatabase 2 Create table cu... 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_2

Step: 3

blur-text-image_3

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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

What is a visibility symbol in UML?

Answered: 1 week ago

Question

Calculate the missing value.

Answered: 1 week ago

Question

What amount when increased by 150% equals $575?

Answered: 1 week ago