Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved

    CS405 Assignment 3 Solution and Discussion

    CS405 - Database Programming using Oracle 11g
    cs405 assignment 3 solution discussion fall 2019
    1
    1
    92
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • zareen
      zareen Cyberian's Gold last edited by

      Assignment No. 03
      SEMESTER Fall 2019
      CS405- Database Programming Using Oracle 11g Total Marks: 20
      Due Date: 21-01-20

      Objective:
      The assignment has been designed to enhance your knowledge about how to use:
      • Loops and implementing Nested Loops
      • Cursors and it’s types
      • Cursor Implementation
      Instructions:
      Please read the note section and following instructions carefully before solving & submitting assignment:

      1. The assignment will not be accepted after due date.
      2. Assignment will not be accepted via email.
      3. Zero marks will be awarded to the assignment that does not open or the file is corrupt.
      4. The assignment file must be in MS word (.doc) file format; Assignment will not be accepted in any other format.
      5. Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).

      For any query about the assignment, contact at [email protected]

      Marks: 20

      Consider the following table containing columns to answer the questions:
      Employee(emp_ID, emp_name, emp_rank, emp_scale, emp_experience, emp_salary)

      Question 1: [Screenshot =2.5 Marks, Code = 2.5 Marks]
      Write a PL/SQL block to display the reverse of maximum experience from Employee table.

      Question 2: [Screenshot = 7.5 Marks, Code = 7.5 Marks]

      1. Write a PL/SQL block using cursors to update the salary of employees for the following cases.
        a) If employee scale (16 or less than 16) [Screenshot = 2.5 Marks, Code = 2.5 Marks]
        20 % increase in the salary.
        b) If employee Scale (17 or above) [Screenshot = 2.5 Marks, Code = 2.5 Marks]
        10% increase in salary.
        Also display the emp_ID, emp_scale and emp_updated salary. [Screenshot = 2.5 Marks, Code = 2.5 Marks]

      Lectures Covered: This assignment covers WEEK# 9-10
      Note: You are required to paste code and screenshots of your programs in a Word File, and submit that file on or before January 21, 2020
      GOOD LUCK

      Discussion is right way to get Solution of the every assignment, Quiz and GDB.
      We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
      Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
      NOTE: Don't copy or replicating idea solutions.
      Quiz Copy Solution
      Mid and Final Past Papers
      Live Chat

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Insaf Sehat Card Live Cricket Streaming

      100% Off on Your FEE Join US! Ask Me How?

      Quiz 100% Result If you want to know how you can join us and get 100% Discount on your FEE ask Cyberian in Chat Room!
      Quiz 100% Result Quiz 100% Result
      solution1255 discussion1206 fall 2019813 assignment 1433 assignment 2297 spring 2020265 gdb 1248 assignment 382 crw10174 spring 201955
      | |
      Copyright © 2021 Cyberian Inc. Pakistan | Contributors
      Live Chat