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

How many types of triggers are there in pl sql?

0 Answers  

what is unique key constraint? : Sql dba

0 Answers  

Does execute immediate commit?

0 Answers  

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

How to fetch common records from two tables?

1 Answers  




Is sql between inclusive?

0 Answers  

Does user triggers have entry for trigger with compilation errors?

0 Answers  

when a procedure /package is getting invalidated?

4 Answers   TCS,

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

How many types of triggers exist in pl/sql?

0 Answers  

Is sql injection illegal?

0 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories