Recent Topics


Assignment 01
 Semester: Spring 2019 
Database Programming Using Oracle 11g – CS405



  • Assignment 01
    Semester: Spring 2019
    Database Programming Using Oracle 11g – CS405
    Weeks Covered : 01 - 03

    Total Marks: 20

    Due Date: 17-05-19

    Objectives:
    Students will be able to learn:
    • Relationships among tables
    • Structured Query Language Basics
    • SQL Joins
    Instructions:
    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]

    Scenario
    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:

    1. 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’.

    2. Display the net salary paid to the Lecturers of all departments where net salary is more than 85000 and records are order by salary.

    3. Display information of all those employees who are working in CS dept and their minimum salary is greater than 70000.

    4. Display the employee name, employee ID and total leaves availed by employee in last 6 months.

    5. Display the empID, name and designation of employees having same joining date.

    Spring 2019_CS405_1.docx



Hello Cyberians, We are hiring Global Moderator. Cheers!
Contact Us!
How to allow Copy Quiz VU! Download Chrome Extension!

Online Users

  • 1
  • 1
  • 4
  • 4
  • 2
  • 3
  • 2

0
Online

64
Users

420
Topics

1.2k
Posts

About Us!

Cyberian offers practice exercises, Learning videos, and a Virtual learning dashboard that empower learners to study at their home pace in and outside of the classroom. We tackle math, science, computer programming, Bio, management sciences, history, art history, economics, and more. Our math missions guide learners from kindergarten to calculus using state-of-the-art, adaptive technology that identifies strengths and learning gaps. We've also partnered with institutions like VU, AIOU, Academy of Sciences, and MIT to offer specialised content.
Cyberian Mobile App

Suggested Topics

  • 1
  • 2
  • 5
  • 3
  • 2
  • 1
  • 2
  • 10
| |