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.

WEEK 1 ASSIGNMENT Complete the following exercise: Create a student table. The student table needs to include the following columns: Student ID Student First Name Student Last Name Middle Name City State ZIP Code GPA Use the appropriate data types for each column. Create a Primary Key constraint for the table. Make sure all columns contain either a NULL or NOT NULL constraint.