Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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.


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

Post New Answer

More SQL PLSQL Interview Questions

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  


Why do we use view in sql?

0 Answers  


What is the unique index?

0 Answers  


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

0 Answers  


What are the sql aggregate functions?

0 Answers  


What is sqlerrd?

0 Answers  


how to drop an existing view in mysql? : Sql dba

0 Answers  


Which sql statement is used to delete data from a database?

0 Answers  


Which one is better subquery or joins?

0 Answers  


What is the sql*loader? : aql loader

0 Answers  


How long it takes to learn pl sql?

0 Answers  


What is a rank in sql?

0 Answers  


Categories