1. The following questions will be based on the Employee Table as below: EmpName (b) (c)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. The following questions will be based on the Employee Table as below: EmpName (b) (c) Write SQL commands to: (a) Create table EMPLOYEE. (d) EmpNo 100 (e) Ali Hassan 101 Mohd Anwar Ali 102 Aminah Hassan 103 Rahayu Rahim 104 Jamaluddin Johari 105 Sarimah Ibrahim 106 Mohd Ali Hashim Date Birth 1/2/1971 1/2/1972 8/4/1973 9/6/1975 21/7/1977 11/2/1970 19/6/1970 Employee Table Salary DeptCode 1200 HRM 2500 HRM 2000 HRM 1000 ACC 3000 MKT 1800 ACC 3500 MKT Remove table EMPLOYEE from the database. (4) Insert TWO new records in EMPLOYEE table. List the employees sorted by department and in each department sort the list in descending order by salary. Create the view to see the detail of employee who works in HRM department. (4) (4) (4) (4) (Total : 20) 1. The following questions will be based on the Employee Table as below: EmpName (b) (c) Write SQL commands to: (a) Create table EMPLOYEE. (d) EmpNo 100 (e) Ali Hassan 101 Mohd Anwar Ali 102 Aminah Hassan 103 Rahayu Rahim 104 Jamaluddin Johari 105 Sarimah Ibrahim 106 Mohd Ali Hashim Date Birth 1/2/1971 1/2/1972 8/4/1973 9/6/1975 21/7/1977 11/2/1970 19/6/1970 Employee Table Salary DeptCode 1200 HRM 2500 HRM 2000 HRM 1000 ACC 3000 MKT 1800 ACC 3500 MKT Remove table EMPLOYEE from the database. (4) Insert TWO new records in EMPLOYEE table. List the employees sorted by department and in each department sort the list in descending order by salary. Create the view to see the detail of employee who works in HRM department. (4) (4) (4) (4) (Total : 20)
Expert Answer:
Answer rating: 100% (QA)
Based on the image youve shared you would like to know how to write SQL commands for certain tasks r... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these programming questions
-
A stock has a return on equity of 10.5% and a plowback ratio of 30%. What is the sustainable growth rate? Enter you answer as a percentage.
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The shift toward more strategic, higher-value IT offshoring is a significant next step in the evolution of the relationship between multinationals and their suppliers. In their quest for...
-
You have obtained the following share prices from Yahoo Finance. Company 1 is listed on the London Stock Exchange. You want to estimate the beta value for Company 1. You run a regression of the share...
-
14.39Add examples of guides other than those shown in Fig. 14.31?
-
Ray steals a purse from an unattended car at a gas station. Because the purse contains money and a handgun, Ray is convicted of grand theft of property (cash) and grand theft of a firearm. On appeal,...
-
What type of information does a mutual fund quotation provide to help you evaluate a fund?
-
Baldwin Inc. is an athletic footware company that began operations on January 1, 2014. The following transactions relate to debt investments acquired by Baldwin Inc., which has a fiscal year ending...
-
ASSIGNMENT 02 (30 marks) (36 minutes) The following balances were extracted from the trial balance of Bell Crest Lid on 30 June 2020: Additional information R Land at cost 1, 2 800 000 Buildings at...
-
John Campbell, an employee of Manhattan Construction Company, claims to have injured his back as a result of a fall while repairing the roof at one of the Eastview apartment buildings. He filed a...
-
Three months back you bought for $4 a put option on a stock with an exercise price of $100. If the stock price at expiration of this option is $92, what is your return on Investment? 100 percent 150...
-
(1) Assume that ISI has a capital budget of $800,000 planned for next year. You have determined that your current capital structure (60 percent equity and 40 percent debt) is optimal, and your net...
-
I want someone to look at my work and make the necessary corrections. my assignment instruction was to choose any news related to Michigan first i had to do a summary of the article using third...
-
Find a such that 4dx=10. (Hint: you may find it helpful to sketch the graph.) a=
-
When doing business with an emerging market like Africa, there are often surprise costs, such as the logistics costs. How might you incorporate that into your initial NPV for the acquisition?
-
It is a general knowledge that there exists a gap between theory and practice in the world of economic thinking and behavior. By implication, a theory which appears logically sound might not be...
-
Choose a Multinational company or a local company in your community and write on the information technology upgrades, system applications, security access, user support ,IT trends affecting the...
-
Refrigerant-134a enters an adiabatic compressor as saturated vapor at 120 kPa at a rate of 0.3 m3/min and exits at 1-MPa pressure. If the isentropic efficiency of the compressor is 80 percent,...
-
The beta of a stock is found by running a regression with the monthly return on a market index as the explanatory variable and the monthly return on the stock as the dependent variable. The beta of...
-
During the next two months an automobile manufacturer must meet (on time) the following demands for trucks and cars: month 1, 400 trucks and 800 cars; month 2, 300 trucks and 300 cars. During each...
-
In the Walton Bookstore example with a discrete demand distribution, explain why an order quantity other than one of the possible demands cannot maximize the expected profit.
-
2. CPA QUESTION: Assuming all other requirements are met, a corporation may elect to be treated as an S corporation under the Internal Revenue Code if it has: (a) Both common and preferred...
-
3. Under Delaware law, a corporation cannot appear in court without a lawyer, but a partnership can. Fox Hollow Ventures, Ltd., was a limited liability company. One of its employees, who was not a...
-
4. Glenleigh Falls Development Co. was a limited liability company that hired architects John and Marion Zaugg to design a residential golf course. The Zauggs were to receive partial payment for...
Study smarter with the SolutionInn App