Table Creation: Creating table comes under Data Definition Language (DDL). The “CREATE TABLE” command is used to create a table by specifying the table name and then by listing the column in a single set of parentheses in the table. The “CREATE” command is employed for establishing databases on our platform by constructing tables in an already existing database . The Syntax for creating table is as follows: CREATE TABLE TABLE_NAME ( Column1 datatype, Column2 datatype, );

Question

You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

Answer 1

Question

Chapter 3, Problem 1SCG

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL).

The “CREATE TABLE” command is used to create a table by specifying the table name and then by listing the column in a single set of parentheses in the table.

The “CREATE” command is employed for establishing databases on our platform by constructing tables in an already existing database.

The Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

);

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

ORACLE SQL STAYWELL The table being used is the PROPERTY table. Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square footage, bedrooms, floors, monthly rent, and owner’s last name for every property in which the number of bedrooms is three.

Use SQL to complete the following exercises. Provide SQL screenshots of the results of both questions. 1. Create a table named SUMMER_SCHOOL_RENTALS. The table has the same structure as the PROPERTY table shown in Figure 3-48 except the PROPERTY_ID and OFFICE_ NUMBER columns should use the NUMBER data type and the MONTHLY_RENT column should be changed to WEEKLY_RENT. Execute the command to describe the layout and characteristics of the SUMMER_SCHOOL_RENTALS table. 2. Add the following row to the SUMMER_SCHOOL_RENTALS table: property ID: 13; office ID: 1; address: 5867 Goodwin Ave; square feet: 1,650; bedrooms: 2; floors 1; weekly rent: 400; owner number: CO103.