Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the table
Question:
Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the table and the default value of Y is assigned to the Comm column. (The Comm column indicates whether the sales representative earns commission.)
CREATE TABLE store_reps
(rep_ID NUMBER (5),
last VARCHAR2 (15),
first VARCHAR2 (10),
comm CHAR (1));
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 69% (13 reviews)
CREATE TABLE storereps rep...View the full answer
Answered By
GERALD KAMAU
non-plagiarism work, timely work and A++ work
4.40+
6+ Reviews
11+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...
-
The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TUN. Most business intelligence tools...
-
The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...
-
Consider the case when the cost function satisfies C xe ( )=0. This can arise for different reasons. Consider the following two possibilities: (a) Suppose production and abatement costs (AC) are...
-
On March 1, 2017, Big North Insurance received $4,800 cash from Eire Co. for a one-year insurance policy. Big North Insurance has an October 31 fiscal year end and adjusts accounts annually. Complete...
-
What are the steps necessary for success of nations? Support your argument with examples where possible.
-
Suppose a new process was developed that could be used to make oil out of seawater. The equipment required is quite expensive, but it would, in time, lead to very low prices for gasoline,...
-
Marston Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents are paid a commission of 18% of sales. The income statement for the year ending...
-
When and why would data validation be useful in a worksheet? Select one: a. Control types of information that can be entered in a cell. b. Stop the user from entering incorrect data. c. Warn the user...
-
Below are incomplete financial statements for Benson. Incorporated. Requlred: Calculate the missing amounts. table [ [ BENSON , INCORPORATED ] , [ Income Statement ] , [ Year ended Decem ber 3 1 , 2...
-
Which of the following is the valid syntax for adding a PRIMARY KEY constraint to an existing table? a. ALTER TABLE tablename ADD CONSTRAINT PRIMARY KEY (columnname); b. ALTER TABLE tablename ADD...
-
Change the STORE_REPS table so that NULL values cant be entered in the name columns (First and Last).
-
Use a computer algebra system to find the volume of the solid bounded by the graphs of the equations. z = ln(1 + x + y), z = 0, y = 0, x = 0, x = 4 - y
-
A company determines that monthly sales S(t), in thousands of dollars, after t months of marketing a product is given by S(t) = 23-551 + 230t+ 160. a) Find S'(1), S'(2), and S'(4). b) Find S''(1),...
-
Dan is a 16 year-old who decided to skip his adolescent development class. If Dan was 19 years-old, this would be his choice, but because of his age, he has broken the law. What type of offence did...
-
You need to remove a bolt from a metal door. The maximum torque the bolt can withstand before starting to rotate is 7 = 70 N-m. You apply a wrench of m = 0.5 kg and 1 = 0.3 m long. You push down on...
-
Lesson 10.1: Emotional Intelligence Emotional Intelligence is a type of social intelligence that affords the individual the ability to monitor his own and others' emotions, to discriminate among...
-
Harriet??s annuity has a total cash value of $2000, and she has paid a total of $1,500 into it. Under a Section 1035 exchange, Harriet rolls the entire value of the annuity into a different annuity....
-
Determine the moment of inertia for the area about the y axis. y 4 in. y = = X 16 in. X
-
Discrete sample spaces: suppose there are N cable cars in San Francisco, numbered sequentially from 1 to N. You see a cable car at random; it is numbered 203. You wish to estimate N. (See Goodman,...
-
In the art gallery guarding problem we are given a line L that represents a long hallway in an art gallery. We are also given a set X = {x 0 ,x 1 , . . . ,x n1 } of real numbers that specify the...
-
Give an example set of denominations of coins so that a greedy change-making algorithm will not use the minimum number of coins.
-
Describe an efficient greedy algorithm for making change for a specified value using a minimum number of coins, assuming there are four denominations of coins (called quarters, dimes, nickels, and...
-
help!!! Use the above information to calculate ending inventory using FIFO for a company that uses a perpetua/inventory system
-
Rocky Mountain Chocolate Factory (RMCF) founder and president Frank Crail employs 220 people in 361 outlets in the United States, Canada, United Arab Emirates, Japan, South Korea and Saudi Arabia. If...
-
The market price of a semi-annual pay bond is $979.86. It has 21.00 years to maturity and a yield to maturity of 7.34%. What is the coupon rate? Submit Answer format: Percentage Round to: 0 decimal...
Study smarter with the SolutionInn App