Net Tech Software Engineering Company Private Limited
4th Floor, Satabdi Tower, SNP Area Sakchi, Jamshedpur-1
STUDENT PROJECT & ASSIGNMENT DIVISION
Subject: DATABASE Marks: 100
- What is the term Database? What are the requirements of database in the IT World? Explain the step Database Designing Process.
- Explain Database Model.
- What are Keys? Explain Primary, Secondary, Candidate, Alternate and Foreign Key.
- What is Data Integrity? Explain its types.
- What is Constraints? Explain its types.
- What are DBMS and RDBMS? Explain with their features.
- Explain ER-Diagram. Make a ER-Diagram for Institute Manage System ( Like. Students Fee, Teachers Salary, Students Exam. Etc.)
- What is Relationship Explain its type?
- Explains Union, Sub Query with all types and Join with all types.
- Write the SQL Query to create the following table as given.
emp_no |
dept_no |
emp_name |
job |
salary |
commission |
E11 |
10 |
Rohit Roy |
Clerk |
4000 |
200 |
E12 |
20 |
Danis |
Salesman |
3500 |
Null |
E13 |
10 |
Robart Disuja |
Manager |
6000 |
500 |
E14 |
10 |
Monika Rani |
Clerk |
2800 |
Null |
E15 |
20 |
Minu |
Salesman |
3800 |
600 |
Write the Query according to the above database.
- Display the details of all employees.
- Display the name and job for all employees.
c) Display the employee’s no., name, salary, salary with commission and annual salary for all employees.
d) Display the name of all employees who are working as clerk and drawing salary more than 3000/-.
e) Display the employee no. and name who are earning commission.
f) Display the name of the employees whose name contains ‘a’.
g) Display the name of the employee who earns highest salary.
h) Display the name of the employee who earns second highest salary.
i) Update the salary of each employee by 10% increments that are not eligible for commission.
j) Display name, salary, hra, pf, total salary, for each employee. The output should be in the order of total salary, HRA 15% of the salary, DA 10% of Salary and PF 5% of Salary. Total Salary will be (Salary+HRA+DA)-(PF).
|