Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / guest

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

Sql technical questions

0 Answers  

what are the different functions in sorting an array? : Sql dba

0 Answers  

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

how to create a new view in mysql? : Sql dba

0 Answers  




Can I join the same table twice?

0 Answers  

differentiate between float and double. : Sql dba

0 Answers  

What is a nested table in word?

0 Answers  

Write the order of precedence for validation of a column in a table ?

2 Answers  

what is sql optimization

1 Answers   Fidelity,

How to use sql statements in pl/sql?

0 Answers  

What is the difference between in and between in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories