{"id":10631,"date":"2020-02-21T16:28:23","date_gmt":"2020-02-21T16:28:23","guid":{"rendered":"https:\/\/www.inspirenignite.com\/vtu\/15is53p-pl-or-sql-programming-lab-information-sci-5th-sem-syllabus-for-diploma-dte-karnataka-c15-scheme\/"},"modified":"2020-02-21T16:28:23","modified_gmt":"2020-02-21T16:28:23","slug":"15is53p-pl-or-sql-programming-lab-information-sci-5th-sem-syllabus-for-diploma-dte-karnataka-c15-scheme","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/vtu\/15is53p-pl-or-sql-programming-lab-information-sci-5th-sem-syllabus-for-diploma-dte-karnataka-c15-scheme\/","title":{"rendered":"15IS53P: Pl or Sql Programming Lab Information Sci 5th Sem Syllabus for Diploma DTE Karnataka C15 Scheme"},"content":{"rendered":"

Pl or Sql Programming Lab detail DTE Kar Diploma syllabus for Information Science And Engineering (IS), C15 scheme is extracted from DTE Karnataka<\/a> 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.<\/p>\n

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<\/a>. The detail syllabus for pl or sql programming lab is as follows.<\/p>\n

Pre-requisites:<\/h4>\n

Knowledge of ComputerOperation, database and SQL.\n<\/p>\n

Course Objectives:<\/h4>\n
    \n
  1. Apply the specification of syntax rules for lexicaltypes,attributes and expressions in PL\/SQL.<\/li>\n
  2. Recognize the built-in functions and control structures.<\/li>\n
  3. Implementing SQL operations in PL\/SQL.<\/li>\n
  4. Understanding transaction management with PL\/SQL.<\/li>\n
  5. Demonstrating programs using cursors,packages, triggers and exceptions.<\/li>\n<\/ol>\n

    Course Outcomes:<\/h4>\n

    For complete syllabus and results, class timetable and more pls download iStudy Syllabus App<\/a>.<\/b> Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n

    List of Graded Practical Exercises<\/h4>\n
      \n
    1. Write a PL\/SQL code to create an employee database with the tables and fields specified as below.<\/li>\n
        \n
      1. Employee<\/li>\n

        [Emp no\tEmployee name\tStreet\tCity]<\/p>\n

      2. Works<\/li>\n

        [Emp no\tCompany_name\tJoining_date\tDesignation\tSalary]<\/p>\n

      3. Company<\/li>\n

        [Emp no City]<\/p>\n

      4. Manages<\/li>\n

        [Emp no Manager_name Mang_no]\n<\/ol>\n

      5. Write a PL\/SQL code to create astudent database with the tables and fields specified as below.<\/li>\n
          \n
        1. Student<\/li>\n

          [Roll no\tStudent_name\tCourse\tGender]<\/p>\n

        2. Student personal<\/li>\n

          [Roll no\tDOB\tFather_name\tAddress Place]<\/p>\n

        3. Student_enrollment<\/li>\n

          [Roll no\tCourse\tCourse_code Sem\t\tTotal_marks Percentage]\n<\/ol>\n

        4. 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.<\/li>\n
        5. Write a PL\/SQL code to show TABLE type of data(Array.<\/li>\n
        6. 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.<\/li>\n
            \n
          1. Employee_salary<\/li>\n

            [Emp no Basic HRA DA\t\t\tTotal_deduction Net_salary\t\tGross_salary]\n<\/ol>\n

          2. 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)<\/li>\n
          3. Write a PL\/SQL code to display employee number, name and basic of 5 highest paid employees.<\/li>\n
          4. 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.<\/li>\n
          5. Write a PL\/SQL code to update the salary of employees who earn less than the average salary using cursor.<\/li>\n
          6. Write a row trigger to insert the existing values of the salary table in to a new table when the salary table is updated.<\/li>\n
          7. 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.<\/li>\n
          8. 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.<\/li>\n
          9. Create a store function that accepts 2 numbers and returns the addition of passed values. Also write the code to call your function.<\/li>\n
          10. 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.<\/li>\n
          11. Write a PL\/SQL code to create,<\/li>\n
              \n
            1. Package specification<\/li>\n
            2. Package body.<\/li>\n

              For the insert, retrieve, update and delete operations on a student table.\n<\/ol>\n

            3. Write a PL\/SQL code to create,<\/li>\n
                \n
              1. Package specification<\/li>\n
              2. Package body.<\/li>\n

                For the insert, retrieve, update and delete operations on aemp table.\n<\/ol>\n

              3. Write a program to illustrate user defined exceptions, built-in exception and raise application error exception.<\/li>\n<\/ol>\n

                Text Books:<\/h4>\n
                  \n
                1. Database Management Systems, A Practical approach By- Err. Rajiv Chopra, Chand Publications, ISBN : 8121932459.<\/li>\n<\/ol>\n

                  Reference Books:<\/h4>\n

                  For complete syllabus and results, class timetable and more pls download iStudy Syllabus App<\/a>.<\/b> Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n

                  Suggested List of Student Activities:<\/h4>\n<\/p>\n

                  Note: The following activities or similar activities for assessing CIE (IA) for 5 marks (Any one)<\/i><\/p>\n

                  Student activity like mini-project, surveys, quizzes, etc. should be done in group of 1-2 students.<\/p>\n

                    \n
                  1. 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.<\/li>\n
                  2. Each group should conduct different activity and no repeating should occur.<\/li>\n
                      \n
                    1. Mini project implementing cursors,triggers,packages,exceptions, functions and procedures for the following topics:<\/li>\n

                      Customer billing System Project, , Calendar, Application Project, Employee Record System Project, Student Record System Project,
                      \nCyber Management System Project, College billing System Project, Customer billing system, Phone book application, etc.\n<\/ol>\n<\/ol>\n

                      Course Delivery:<\/h4>\n

                      The course will be delivered through Demonstration and Practices\n<\/p>\n

                      Scheme of Valuation for End Examination<\/h4>\n

                      For complete syllabus and results, class timetable and more pls download iStudy Syllabus App<\/a>.<\/b> Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n

                      Resource requirements for PL\/SQL ProgrammingLab<\/h4>\n
                        \n
                      1. PC systems (latest configurations with speakers. 20<\/li>\n
                      2. Laser Printers\t01<\/li>\n
                      3. Networking (Structured) with CAT6e \/ wireless 24 Port switches \/ Wireless Router I\/O Boxes for networking(as required. 03<\/li>\n
                      4. Broad Band Connection\t01<\/li>\n<\/ol>\n

                        **Open Source Software should be encouraged<\/i>\n<\/p>\n

                        For detail syllabus of all other subjects of BE Information Sci, C15 scheme do visit Information Sci 5th Sem syllabus for C15 scheme<\/a>.<\/p>\n

                        Dont forget to download iStudy Syllabus App<\/a> for latest syllabus and results, class timetable and more.<\/p>\n","protected":false},"excerpt":{"rendered":"

                        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. […]<\/p>\n","protected":false},"author":2298,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[18,66],"tags":[],"class_list":["post-10631","post","type-post","status-publish","format-standard","hentry","category-5th-sem","category-information-science-diploma"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/posts\/10631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/users\/2298"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/comments?post=10631"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/posts\/10631\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/media?parent=10631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/categories?post=10631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/tags?post=10631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}