Question: Make a table named REP. The table has the same structure as the SALES_REP table shown on page 1 of this lab, except the COMMISSION

Make a table named REP. The table has the same structure as the SALES_REP table shown on page 1 of this lab, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table.

Make a table named REP. The table has the same structure

REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL PHONE COMMISSION RATE 05 Susan Garcia 42 Mountain Ln Cody WY 82414 307-824-1245 12743.16 0.04 10 Richard Miller 87 Pikes Dr Ralston WY 82440 307-406-4321 20872.11 0.06 15 Donna Smith 312 Oak Rd Powell WY 82440 307-982-8401 14912.92 0.04 20 Daniel Jackson 19 Lookout Dr Elk Butte WY 82433 307-883-9481 0.00 0.04

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Model: KimTay The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the companys recent growth no longer...

Create a table named REP. The table has the same structure as the SALES _ REP table shown on page 1 of this lab, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the...

For this assignment, run this on SQL Workbench: Querying SQL Servers 1 Use SQL to complete the following exercises. 1. Create a table named REP. The table has the same structure as the SALES_REP...

Directions:- Use SQL Server 2017 . See the images below and under TAL distributors write queries to perform steps 1 and 2 and 3. In Step 1 - name your table as Sales_Rep_Lastname. (The Last name in...

Create a table named SALES_REP. The table has the same structure as the REP table shown in Figure 3-11 except the LAST_NAME column should use the VARCHAR data type and the COMMISSION and RATE columns...

Database Preparation: 1. Login MySQL 2. Create a database, its name must include your first and last name. See example below if your name is John Smith the database name should be John Smith Kim Tay...

Staywell finds and manages accommodation for owners of student accommodation in the Seattle Area. The company rents out and helps to maintain 15-bedroom properties located in two main areas in the...

i need a little help this is what i have so far none of the tasks clear -- Write your query below and then click "Run Query" to execute it. To save multiple queries, click the "+" icon above. drop...

bTask 1 : Create a table named SUMMER _ SCHOOL _ RENTALS. The table has the same structure as the PROPERTY table shown on Page 1 , except the PROPERTY _ ID and OFFICE _ NUM columns should use the...

The data below are weekly figures from Herbert Hooleys Happy House (except for the quarterly error figures). They sell radios, TVs, and VCRs in their electronics department. He needs you to help him...

45) Which of the following is true regarding bipolardisorder? A) It involves depression, mania, and anxiety disorders. B) Manic episodes usually last three times as long as depressiveepisodes. C) It...

Regarding international taxation: a . An item of taxable income for a U . S . entity can only be subject to income tax in the United States. b . In the United States, inbound taxation refers to the U...

Steam undergoes a change from an initial state of 380 C and 3,300 kPa to a final state of 150 C and 230 kPa. Determine H and S using (a) equations for an ideal gas, and (b) more appropriate...

In the Data Source View in Visual Studio, what option is available to view data in any Source View Table? What are the primary uses this capability?

What Microsoft Analysis Services Extension for Visual Studio 2017 needs to be installed before beginning work on a Multidimensional OLAP Cube Project? How can the installation be verified?

Why would the FedScope Employment database be more representative of the General Population in terms of Salary Data than the CPS studies?