Answer Posted / sreenivas

THE MAIN DIFFERENCE BETWEEN DBMS and RDBMS IS THAT:
DBMS STANDS FOR DATA BASE MANAGEMENT SYSTEM and
RDBMS STANDS FOR RELATIONAL DATA BASE MANAGEMENT SYSTEM..
AND, DBMS CAN CREATES DATA, STORED DATA AND META DATA...
AND, RDBMS CAN CREATES RELATIONS BETWEEN TWO TABLES, ROWS
AND COLUMS OR TOUPLES.....

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.

2570

---

What is an example of translating a date into julian format?

1042

---

How subquery works in sql?

997

---

What is the maximum size of sqlite database?

1043

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1977

---

What are the different types of dbmss?

966

---

What is the best partition size for windows 10?

947

---

What are the various restrictions imposed on view in terms of dml?

911

---

What is group by in sql?

1027

---

How do you select unique values in sql?

938

---

What is difference between stored function and application function?

1105

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1006

---

How to rename a table?

959

---

explain normalization concept? : Sql dba

998

---

Is null operator in sql?

980

---