Q18. Write the SQL command for the following on the basis of given table. Table : FURNITURE
PRICE
NO ITEMNAME TYPE DATEOFSTOCK
DISCOUNT
(%)
23/02/2002
30000
Bouble bed
1
25
White lotus
20/01/2003
20
Pink feather
7000
2
Baby cot
Baby cot
3
Dolphin
20
19/02/2003
9500
Decent
Office Table
01/01/2002
25000
30
Comfort zone
5
Double bed
12/01/2002
25000
25
Donald
6
Baby cot
24/02/2002
6500
15
i. To display itemnames bought in the year 2003.
ii. To increase the discount by 5% for items where price is in the range of 5000
and 10000
To delete all those records where the itemname starts with D and ends with n.
iv. Add a field by the name quan_in_hand to store the number of items for every item.
v. Select min(dateofstock) from furniture;
vi. Select sum(price) from furniture where discount IN ( 20,30);​

What is word processing and word wrap?

3. ranga ramasesh is the operations manager for a firm that is trying to decide which one of four countries it should research for possible outsourcing providers. the first step is to select a country based on cultural risk factors, which are critical to eventual business success with the provider. ranga has reviewed outsourcing provider directories and found that the four countries in the table that follows have an ample number of providers from which they can choose. to aid in the country selection step, he has enlisted the aid of a cultural expert, john wang, who has provided ratings of the various criteria in the table. the resulting ratings are on a 1 to 10 scale, where 1 is a low risk and 10 is a high risk. john has also determined six criteria weightins: trust, with a weight of 0.3; quality, with 0.2; religious, with 0.1; individualism, with 0.2; time, with 0.1; and uncertainity, with 0.1. using the factor-rating method, which country should ranga select? why? (2 points)

File i/o activity objective: the objective of this activity is to practice working with text files in c#. for this activity, you may do all code in the main class. instructions: create an app that will read integers from an input file name numbers.txt that will consist of one integer per record. example: 4 8 25 101 determine which numbers are even and which are odd. write the even numbers to a file named even.txt and the odd numbers to a file named odd.txt.