{"id":24628,"date":"2020-07-20T07:39:46","date_gmt":"2020-07-20T07:39:46","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/database-management-systems-lab-syllabus-for-mca-1st-year-2nd-sem-r19-regulation-jntuh\/"},"modified":"2020-07-20T07:39:46","modified_gmt":"2020-07-20T07:39:46","slug":"database-management-systems-lab-syllabus-for-mca-1st-year-2nd-sem-r19-regulation-jntuh","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/database-management-systems-lab-syllabus-for-mca-1st-year-2nd-sem-r19-regulation-jntuh\/","title":{"rendered":"Database Management Systems Lab Syllabus for MCA 1st Year 2nd Sem R19 Regulation JNTUH"},"content":{"rendered":"

Database Management Systems Lab detailed Syllabus for Master of Computer Applications(MCA), R19 regulation has been taken from the JNTUH<\/a> official website and presented for the students affiliated to JNTUH course structure. For Course Code, Subject Names, Theory Lectures, Tutorial, Practical\/Drawing, Credits, and other information do visit full semester subjects post given below. The Syllabus PDF files can also be downloaded from the universities official website.<\/p>\n

For all other MCA 1st Year 2nd Sem Syllabus for R19 Regulation JNTUH, do visit MCA 1st Year 2nd Sem Syllabus for R19 Regulation JNTUH <\/a>Subjects. The detailed Syllabus for database management systems lab is as follows. <\/p>\n

Course Objectives:<\/h4>\n

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
\"Get<\/a>. <\/p>\n

Course Outcomes:<\/h4>\n
    \n
  1. Design database schema for a given application and apply normalization<\/li>\n
  2. Acquire skills in using SQL commands for data definition and data manipulation.<\/li>\n
  3. Develop solutions for database applications using procedures, cursors and triggers<\/li>\n<\/ol>\n

    List Of Experiment:<\/h4>\n
      \n
    1. Concept design with E-R Model<\/li>\n
    2. Relational Model<\/li>\n
    3. Normalization<\/li>\n
    4. Practicing DDL commands<\/li>\n
    5. Practicing DML commands<\/li>\n
    6. Querying (using ANY, ALL, IN, Exists, NOT EXISTS, UNION, INTERSECT, Constraints etc.)<\/li>\n
    7. Queries using Aggregate functions, GROUP BY, HAVING and Creation and dropping of Views.<\/li>\n
    8. Triggers (Creation of insert trigger, delete trigger, update trigger)<\/li>\n
    9. Procedures<\/li>\n
    10. Usage of Cursors<\/li>\n<\/ol>\n

      Text Books:<\/h4>\n

      For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
      It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
      \"Get<\/a>. <\/p>\n

      Reference Books:<\/h4>\n
        \n
      1. Database Systems design, Implementation, and Management, Peter Rob and Carlos Coronel 7th Edition.<\/li>\n
      2. Fundamentals of Database Systems, Elmasri Navrate Pearson Education<\/li>\n
      3. Introduction to Database Systems, C.J.Date Pearson Education<\/li>\n
      4. Oracle for Professionals, The X Team, S.Shah and V. Shah, SPD.<\/li>\n
      5. Database Systems Using Oracle: A Simplified guide to SQL and PL\/SQL,Shah,PHI.<\/li>\n
      6. Fundamentals of Database Management Systems, M. L. Gillenson, Wiley Student Edition.<\/li>\n<\/ol>\n

        For detail Syllabus of all other subjects of Master of Computer Applications 1st Year, visit MCA 1st Year Syllabus<\/a> Subjects.<\/p>\n

        For all MCA results, visit JNTUH MCA all years, and semester results <\/a>from direct links.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Database Management Systems Lab detailed Syllabus for Master of Computer Applications(MCA), R19 regulation has been taken from the JNTUH official website and presented for the students affiliated to JNTUH course […]<\/p>\n","protected":false},"author":2344,"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":[120,130],"tags":[],"class_list":["post-24628","post","type-post","status-publish","format-standard","hentry","category-1st-year","category-mca"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/24628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/users\/2344"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/comments?post=24628"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/24628\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=24628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=24628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=24628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}