Question: a) Write SQL statement to create the AGENTS table [5 marks] b) Write SQL statement to change the datatype of COUNTRY to CHAR (20)

a) Write SQL statement to create the AGENTS table [5 marks] b)

Write SQL statement to change the datatype of COUNTRY to CHAR (20)

a) Write SQL statement to create the AGENTS table [5 marks] b) Write SQL statement to change the datatype of COUNTRY to CHAR (20) [3 marks] c) Write SQL statement to drop the table AGENTS [3 marks] d) Write SQL statement to make the WORKING AREA column as NOT NULL [3 marks] e) Write SQL statement add a column AGENT_TYPE with datatype as CHAR(10) [3 marks] AGENTS AGENT_CODE CHAR(6) AGENT NAME CHAR(40) WORKING AREA CHAR (35) Y COMMISSION DECIMAL (10,2) OPHONE NO CHAR(15) COUNTRY VARCHAR(25) Indexes

Step by Step Solution

★★★★★

3.35 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Write SQL statement to create the AGENTS table CREATE TA... View full answer

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!

(a) A distributed conference application provides a shared whiteboard. Each member of the conference has a replica of the whiteboard that is managed by a member of a closed process group. Discuss one...

Find the condition number of the following matrices. Which would you characterize as ill conditioned? (a)_ 3 999 .341 1.001 .388 o(L01 29997) (d) (-1 2-4) )1.00 1.9997 2 10 6 72 96 103 2 (e) 4255 59...

= In the one-period binomial model, the stock price of Apple Inc. (AAPL) is $768 in the up move and $512 in the down move. Also, the one-period risk-free rate I =2% (per annum; NOT re), time to...

If a price ceiling or price floor existed where you lived, would you be willing to purchase products on the black market? What would you identify as a consequence to engaging in transactions on the...

The following equity investment-related transactions were completed by Lance Company in 2010: Jan. 12. Purchased 1,800 shares of Baxter Company for a price of $56.50 per share plus a brokerage...

3-12. Give an example of operational planning that supports a marketing plan. Describe what that plan might include.

Did the researcher provide sufficient description?

At the end of Year 1, Herkimer & Co. sells two laptops for $1,800 each. Based on the information in RE11-6 in Year 1, prepare the journal entries to record the purchase of the laptops, the...

1 hapter 5: Applying Excel .arisb e 2xpenses per un t : wha: : 1W2 "Tha.anor eufely pervertage?. wrks. IK .w degre" uf upelr'g evutage? (Round your answer to 2 decimal place5.) vetUM'lY)-d.erge " .i...

Substance A in a liquid reacts to produce R and S as follows: A feed (C A0 = 1, C R0 = 0, C S0 = 0) enters two mixed flow reactors in series, ( 1 = 2.5 min, 2 = 5 min). Knowing the composition in...

John and Sandy Ferguson got married eight years ago and have a seven-year-old daughter, Samantha. In 2021, John worked as a computer technician at a local university earning a salary of $152,000, and...

1. Mrs. Kapoor has been accumulating mutual funds over the past two years. She decides to sell her holdings on January 31, 2017, on which date the value of her investments is as shown below. What is...

9 Javon Company set standards of 2 hours of direct labor per unit at a rate of $15.10 per hour. During October, the company actually uses 11,000 hours of direct labor at a $168,300 total cost to...

April Sandra Wong, Vice President Human-Resource Department Robinson Enterprises 55123 W. Robinson Lane Prosperity, CA 99923 Dear Sandra Wong It was a pleasure speaking with you this afternoon...

Jim is on trial for the rape of Sandra. Jim's attorney wants to introduce evidence ( 1 ) The fact that Sandra is the mother of Jim's child, who was born three years ago when they were dating ( they...

Explain all drawbacks of application procedure.

What is the output of print ( np . array ( [ 1 , 2 , 3 ] ) * np . array ( [ 1 , 2 , 3 ] ) ) ?

In Exercises delete part of the domain so that the function that remains is one-to-one. Find the inverse function of the remaining function and give the domain of the inverse function. f(x) = 16x4 -3...

Which of the following should have their names changed to more meaningful ones? A. All controls that will be coded B. All controls that will be referred to in code C. The form D. All of the above.

When used in a parameter query, which of the following WHERE clauses will select the records for employees working more than 40 hours? a. WHERE Hours > @Hours b. WHERE Hours > !Hours c. WHERE Hours >...

What is the id used for text box names? A. Tex B. Text C. Txt D. None of the above.

The newborn grandson of one of the authors was 48 cm long and weighed 3 kg. According to the regression model of Exercise 3, what was his residual? What does that say about him? Exercise 3 A least...

For the online clothing retailer discussed in the previous problem, the scatterplot of Total Yearly Purchases by Income looks like this: The correlation between Total Yearly Purchases and Income is...

Consider the Albuquerque home sales from Exercise 29 again. The regression analysis gives the model Price = 47.82 + 0.061 Size. a) Explain what the slope of the line says about housing prices and...