Answered: Use SQL to complete the following…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Use SQL to complete the following exercises.

Provide SQL screenshots of the resutls of both questions.

1. Create a table named REP. The table has the same structure as the SALES_REP table shown in Figure 3-15 except the LAST_NAME column should use the VARCHAR data type and the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table.

2. Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser; address: 427 Billings Dr.; city: Cody; state: WY; postal: 82414; cell phone: 307-555-6309; commission: 0.00; and rate: 0.05. Display the contents of the REP table.

Parentheses
define the beginning
and ending to the
parameters
Command
keyword
Name of the table
you want to create
CREATE TABLE SALES REP
-(
REP_ID CHAR (2) PRIMARY KEY,
FIRST NAME CHAR (20),
LAST NAME CHAR (20),
ADDRESS CHAR (20),
CITY CHAR (15),
STATE CHAR (2),
POSTAL CHAR (5),
CELL PHONE CHAR (12),
COMMISSION DECIMAL (7, 2),
RATE DECIMAL (3, 2)
Clause to
disallow duplicate
values for this
column
Each SQL
statement ends
with a semicolon
(;)
FIGURE 3-15 CREATE TABLE command to create the SALES_REP table

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions