a) Write SQL statement to create the AGENTS table [5 marks] b) Write SQL statement to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
a Write SQL statement to create the AGENTS table CREATE TA... View the full answer
Related Book For
Posted Date:
Students also viewed these 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...
-
Valve Corporation's organizational structure was described at the beginning of this chapter. What coordinating mechanism is likely most common in this organization? Describe the extent and form in...
-
Use the binomial theorem to find the sixth term in the expansion of (x 1) 18 . Data from Binomial Theorem THEOREM 2 Binomial Theorem For all natural numbers n, (a + b)" = Coa" + nCa"-b + Can-b +...
-
4. Anthony Davis operated a computer bulletin board system that permitted users to send and receive e-mail, access the Internet, and download software. Davis's system had one attribute that...
-
After reviewing the waiting line analysis of Problem 12, the manager of Petes Market wants to consider one of the following alternatives for improving service. What alternative would you recommend?...
-
CSUSM is considering the purchase of a fire insurance company. The company has a beta of 2.5. If the risk-free rate is 8 percent and the market risk premium(which is rm-rf) is 6 percent, the...
-
Felde Bucket Co., a manufacturer of rain barrels, had the following data for 2016: Sales .......................... 2,500 units Sales price ................... $40 per unit Variable costs...
-
SECTION 2 Solutions to Problems (Answer to All the Questions) Question 1 Mark: 2+2+2=6 The checking-in time at a readymade garments organization is to be investigated. The means of 15 samples of 10...
-
Winfred Metal Reclamation Ltd, a small company, buys scrap metal residues from local companies and treats the residues to recover the metal which is then sold to other local companies. The company is...
-
Job Alpha requires 2 weeks of work and job Beta requires 3 weeks of work. If job Alpha is completed first and job Beta is completed next, what is the flowtime for job Beta?
-
Consider the following three jobs: Job Oscar requires 2 weeks of work and is due in 4 weeks. Job Lima requires 3 weeks of work and is due in 5 weeks. Job Denver requires 1 week of work and is due in...
-
A debit memo is a (an) a. Report of all the debits to the Cash account b. Document for a purchase return c. Document for a sales return d. Entry to the Accounts Receivable account
-
Tickitt & Run are auditors of McColl Holdings PLC, a chemical manufacturer. The financial director has left the company recently to take up another post and McColl have so far been unable to find a...
-
Consider the following table, which gives a security analyst's expected return on two stocks in two particular scenarios for the rate of return on the market: Market Return 5% 26 Aggressive Stock -3%...
-
Why did management adopt the new plan even though it provides a smaller expected number of exposures than the original plan recommended by the original linear programming model?
-
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.
-
List four specific sources of financial information.
-
Risk associated with investments can be categorized as diversifi able risk and undiversifi able risk. This is one reason mutual funds are so popularmany investors money is pooled and numerous stocks...
-
Americans do not save as they once did. Weak savings mean fewer investments in the economy, and that contributes to slower economic growth.
Study smarter with the SolutionInn App