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
- 2566 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is sql? : Sql dba
What is trigger in sql? Explain
What is the difference between database trigger and stored procedure?
What is embedded sql in db2?
What is insert command in sql?
What is t-sql? : Transact sql
What is the basic form of sql query?
write a query to delete similar records in different tables with same structure
There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
Is sql similar to python?
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
How do I write a cron which will run a sql query and mail the results to agroup?
-
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)
