{"id":25498,"date":"2020-07-23T16:13:03","date_gmt":"2020-07-23T16:13:03","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/18cm305e-rdbms-syllabus-for-computer-engineering-3rd-sem-c18-curriculum-tssbtet\/"},"modified":"2020-07-23T16:13:03","modified_gmt":"2020-07-23T16:13:03","slug":"18cm305e-rdbms-syllabus-for-computer-engineering-3rd-sem-c18-curriculum-tssbtet","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/18cm305e-rdbms-syllabus-for-computer-engineering-3rd-sem-c18-curriculum-tssbtet\/","title":{"rendered":"18CM-305E: Rdbms Syllabus for Computer Engineering 3rd Sem C18 Curriculum TSSBTET"},"content":{"rendered":"

Rdbms detailed Syllabus for Computer Engineering (DCME), C18 curriculum has been taken from the TSSBTET<\/a> official website and presented for the diploma students. For Course Code, Course Name, Lectures, Tutorial, Practical\/Drawing, Internal Marks, Max Marks, Total Marks, Min Marks and other information, do visit full semester subjects post given below. <\/p>\n

For all other Diploma in Computer Engineering (DCME) Syllabus for 3rd Sem C18 Curriculum TSSBTET, do visit Diploma in Computer Engineering (DCME) Syllabus for 3rd Sem C18 Curriculum TSSBTET Subjects<\/a>. The detailed Syllabus for rdbms is as follows. <\/p>\n

Prerequisites:<\/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 Outcome:<\/h4>\n

Upon completion of the course the student shall be able to<\/p>\n

    \n
  1. Describe the characteristics of database, architecture and languages of Database system.<\/li>\n
  2. Implement Entity-Relationship diagrams.<\/li>\n
  3. Apply relational model concepts and constraints.<\/li>\n
  4. Apply normalization techniques for relational databases and familiarize with transaction processing.<\/li>\n
  5. Use Structured Query Language (SQL), frame queries to any database and managing schema objects.<\/li>\n
  6. Develop programs using PL\/SQL.<\/li>\n<\/ol>\n

    Unit 1: Concepts of Databases:<\/h4>\n

    Introduction – An Example – Characteristics of the database approach – Advantages of using the DBMS Approach – A Brief History of Database Applications. Database System Concepts and Architecture – Data Models – Schemas and Instances – Three-Schema Architecture and Data Independence – Database Languages and Interfaces – The Database System Environment – Centralized and Client \/Server Architectures for DBMSs -Classification of database Management System.<\/p>\n

    Unit 2: Data Modeling Using the Entity-Relationship(Er) Model<\/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

    Unit 3: Relational Data Model and Relational Data Base Constraints<\/h4>\n

    Relational Model concepts – Relational Model Constraints and relational database schemas -Update operation and Dealing with constraints violations – Transaction<\/p>\n

    Unit 4: Normalization and Fundamentals of Data Base Transaction Processing<\/h4>\n

    Informal Design guidelines for relation schemas – Functional dependencies – Normal forms based on primary keys – General Definition of first, second and third normal forms, Boyce-codd Normal form. Introduction to transaction processing – transaction and system concepts – desirable properties of transactions – Serializability – States of Transactions.<\/p>\n

    Unit 5: Concept of Sql and Management of Schema Objects.<\/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

    Unit 6: Pl\/Sql<\/h4>\n

    Introduction- Data types- Naming Conventions – control statements – sequential control GOTO and NULL statements – Subprograms – Procedures -Functions RETURN statement- Recursion -Stored Procedures – Exceptions – Cursors – Triggers – Packages.<\/p>\n

    Course Outcome:<\/h4>\n

    Upon completion of the course the student shall be able to<\/p>\n

    Concepts of Databases<\/strong>\n <\/p>\n