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.
- 0 Answers
- 2604 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
What is varray in pl sql?
Explain how to use transactions efficiently : transact sql
What are the two virtual tables available at the time of database trigger execution?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How can one get sql*loader to commit only at the end of the load file? : aql loader
How do sql databases work?
What is sql*loader and what is it used for? : aql loader
What are dml commands?
What is the trigger in sql?
What is use of term?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
