Pl or Sql Programming Lab detail DTE Kar Diploma syllabus for Information Science And Engineering (IS), C15 scheme is extracted from DTE Karnataka official website and presented for diploma students. The course code (15IS53P), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.
For all other information sci 5th sem syllabus for diploma c15 scheme dte karnataka you can visit Information Sci 5th Sem Syllabus for Diploma C15 Scheme DTE Karnataka Subjects. The detail syllabus for pl or sql programming lab is as follows.
Pre-requisites:
Knowledge of ComputerOperation, database and SQL.
Course Objectives:
- Apply the specification of syntax rules for lexicaltypes,attributes and expressions in PL/SQL.
- Recognize the built-in functions and control structures.
- Implementing SQL operations in PL/SQL.
- Understanding transaction management with PL/SQL.
- Demonstrating programs using cursors,packages, triggers and exceptions.
Course Outcomes:
For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
List of Graded Practical Exercises
- Write a PL/SQL code to create an employee database with the tables and fields specified as below.
- Employee
- Works
- Company
- Manages
- Write a PL/SQL code to create astudent database with the tables and fields specified as below.
- Student
- Student personal
- Student_enrollment
- PL/SQL code to retrieve the employee name, join date, and designation from employee database of an employee whose number is input by the user.
- Write a PL/SQL code to show TABLE type of data(Array.
- Write a PL/SQL code to calculate tax for an employee of an organization -XYZ and to display his/her name & tax, by creating a table under employee database as below.
- Employee_salary
- Write a PL/SQL code to calculate the total and the percentage of marks of the students in four subjects from the table- Student with the schema given below. STUDENT ( RNO , S1 , S2, S3, S4, total, percentage)
- Write a PL/SQL code to display employee number, name and basic of 5 highest paid employees.
- Write a PL/SQL code to calculate the total salary of first n records of emp table. The value of n is passed to cursor as parameter.
- Write a PL/SQL code to update the salary of employees who earn less than the average salary using cursor.
- Write a row trigger to insert the existing values of the salary table in to a new table when the salary table is updated.
- Write a trigger on the employee table which shows the old values and new values of Ename after any updations on ename on Employee table.
- Writ a PL/SQL procedure to find the number of students ranging from 100-70%, 6960%, 59-50% & below 49% in each course from the student_course table given by the procedure as parameter.
- Create a store function that accepts 2 numbers and returns the addition of passed values. Also write the code to call your function.
- Write a PL/SQL function that accepts department number and returns the total salary of the department. Also write a function to call the function.
- Write a PL/SQL code to create,
- Package specification
- Package body.
- Write a PL/SQL code to create,
- Package specification
- Package body.
- Write a program to illustrate user defined exceptions, built-in exception and raise application error exception.
[Emp no Employee name Street City]
[Emp no Company_name Joining_date Designation Salary]
[Emp no City]
[Emp no Manager_name Mang_no]
[Roll no Student_name Course Gender]
[Roll no DOB Father_name Address Place]
[Roll no Course Course_code Sem Total_marks Percentage]
[Emp no Basic HRA DA Total_deduction Net_salary Gross_salary]
For the insert, retrieve, update and delete operations on a student table.
For the insert, retrieve, update and delete operations on aemp table.
Text Books:
- Database Management Systems, A Practical approach By- Err. Rajiv Chopra, Chand Publications, ISBN : 8121932459.
Reference Books:
For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Suggested List of Student Activities:
Note: The following activities or similar activities for assessing CIE (IA) for 5 marks (Any one)
Student activity like mini-project, surveys, quizzes, etc. should be done in group of 1-2 students.
- Each group should do any one of the following type activity or any other similar activity related to the course and before conduction, get it approved from concerned course co-ordinator and programme coordinator.
- Each group should conduct different activity and no repeating should occur.
- Mini project implementing cursors,triggers,packages,exceptions, functions and procedures for the following topics:
Customer billing System Project, , Calendar, Application Project, Employee Record System Project, Student Record System Project,
Cyber Management System Project, College billing System Project, Customer billing system, Phone book application, etc.
Course Delivery:
The course will be delivered through Demonstration and Practices
Scheme of Valuation for End Examination
For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Resource requirements for PL/SQL ProgrammingLab
- PC systems (latest configurations with speakers. 20
- Laser Printers 01
- Networking (Structured) with CAT6e / wireless 24 Port switches / Wireless Router I/O Boxes for networking(as required. 03
- Broad Band Connection 01
**Open Source Software should be encouraged
For detail syllabus of all other subjects of BE Information Sci, C15 scheme do visit Information Sci 5th Sem syllabus for C15 scheme.
Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.