UNSOLVED ACC501 Quiz 3 Solution and Discussion
ACC501 - Business Finance12
UNSOLVED FIN723 Quiz No. 4 Solution and Discussion
FIN723 - Taxation Management11
UNSOLVED ECO402 Quiz 3 Solution and Discussion
ECO402 - Microeconomics11
UNSOLVED ECO401 Quiz 3 Solution and Discussion
ECO401 - Economics11
UNSOLVED CS409 Quiz 2 Solution and Discussion
CS409 - Introduction to Database Administration11
UNSOLVED HRM613 Quiz 3 Solution and Discussion
HRM613 - Performance Management11
UNSOLVED EDU701 Quiz 2 Solution and Discussion
EDU701 - Human Resource Management in Education11
15th August Block Day with Kashmir solidarity
UNSOLVED #UN for Kashmir Freedom
UNSOLVED EDU433 GDB 1 Solution and Discussion
EDU433 - Professionalism in Teaching4
Important UNSOLVED Final Term Exam Help Center
UNSOLVED GSC101 GDB 1 Solution and Discussion
GSC101 - General Science2
UNSOLVED Malala Yousafzai
UNSOLVED CS510 GDB 1 Solution and Discussion
CS510 - Software Requirements and Specifications2
UNSOLVED Quiz 1 — Math (No Calculator)
UNSOLVED Topic 8 | About WordPress and what is it really?
WPS101 - WordPress1
UNSOLVED BT603 GDB 1 Solution and Discussion
BT603 - Fermentation Technology1
George vs Shaniera: The Ultimate Urdu Shopping Challenge
Good Morning Pakistan1
UNSOLVED Very important questions for PPSC. FPSC.CSS
Competition Exam Preparation and Discussions1
پاکستان تحریکِ انصاف کا حکومت میں ایک سال: کتنا کامیاب، کتنا ناکام؟
Assignment 01 Semester: Spring 2019 Database Programming Using Oracle 11g – CS405
moaaz last edited by
Semester: Spring 2019
Database Programming Using Oracle 11g – CS405
Weeks Covered : 01 - 03
Total Marks: 20
Due Date: 17-05-19
Students will be able to learn:
• Relationships among tables
• Structured Query Language Basics
• SQL Joins
Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:
♣ The assignment is submitted after due date.
♣ The assignment is submitted via email.
♣ The assignment is copied from Internet or from any other student.
♣ The submitted assignment does not open or file is corrupt.
♣ It is in some format other than .doc/docx.
Note: All types of plagiarism are strictly prohibited.
For any query about the assignment, contact at [email protected]
Suppose a Software Development Company is maintaining Employee’s Basic Information, Attendance Record and Leave Record. The following three tables have been created and their attributes are also given.
Employee (emp_id, emp_name, designation, phone_no, address, joining_date, basic_salary, net_salary, department)
Attendance (emp_id, date, duty_time_in, duty_time_out, emp_time_in, emp_time_out, working_hours)
Leave (emp_id, leave_id, leave_date, leave_type, leave_status, total_leaves_allowed, leaves_availed)
Question: You are required to use these relations to write SQL statements for the following cases:
Display the list of names of all employees who are having either ‘S’ in the name or the name should end with ‘I’ and designation is ‘Lecturer’.
Display the net salary paid to the Lecturers of all departments where net salary is more than 85000 and records are order by salary.
Display information of all those employees who are working in CS dept and their minimum salary is greater than 70000.
Display the employee name, employee ID and total leaves availed by employee in last 6 months.
Display the empID, name and designation of employees having same joining date.