C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

2665

---

Is it possible to overwrite Hadoop MapReduce configuration in Hive?

774

---

In support project one ticket alloted which steps follows manualy tell me ?

2720

---

How to use "in" parameter properly?

1121

---

Where is crop in powerpoint?

395

---

What are action support, action function and action poller used for?

527

---

Which was intel's first microprocessor

1178

---

Explain NULL?

1096

---

What type of salary are you looking for? : insurance sales

600

---

Can i use the B-curve MCB instead of C-curve MCB

2092

---

what is the diff. between hplc and lc.

1788

---

Why box sizing border box is used?

755

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

831

---

What are modules in drupal?

133

---

What are the different types of ejb?

1053

---