Relational Database Management System detailed syllabus for Computer Application & Business Management (CB) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Computer Application & Business Management students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Computer Application & Business Management 4th Sem scheme and its subjects, do visit Computer Application & Business Management (CB) 4th Sem 2021 revision scheme. The detailed syllabus of relational database management system is as follows.
Course Objectives:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
On completion of the course, students will be able to:
- Explain database, system architecture,data models
- Apply relational model concepts, relational algebra, database design
- Build SQL Operations
- IllustrateAdvanced SQL statements &explain transaction management
Module 1:
Define Field, Record, Database, Distinguish between Physical record and Logical Record, Explain Advantages of DBMS, Understand Schema, Subschema – Instances, Three schema architecture, Define data independence. Explain Storage manager, Query processor, Disk storage, Database Users, Explain various Database system application architectures like Centralized DBMS architecture, Basic client/server architecture, Two tier client/server architectures, and three tier client/server architecture, Understand Data models, Explain ER model, Define Entity, Attribute, Keys, Relationship types, Relationship set, Define Primary key, Candidate key, Super key, Explain ER diagram, Weak entity set, Describe EER Model: Subclasses – Super classes -Inheritance – Specialization – Generalization.
Module 2:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Module 3:
Explain Data types in SQL, Differentiate Domains, attributes, and tuples, Creation of Table, Explain CREATE TABLE command, Explain DROP TABLE Command, ALTER TABLE, Explain commands for creating and roping indexes, Explain SELECT statements with WHERE, ORDER BY clause with examples – Describe UPDATE Statement, INSERT, DELETE with example – Explain Joining tables – aggregate functions, – Explain BEGIN TRANS, COMMITT, ROLL BACK, SAVE POINT – Explain Views: Advantages, Creation and Updating- Explain Query optimization.
Module 4:
Understand advanced SQL – Define triggers and cursors – Explain reports and forms -Explain stored procedures and functions – Understand about Embedded SQL statements and its application – Explain dynamic SQL by specifying queries at run time – Understand Transaction management. Define Transaction – Explain transaction concepts – Differentiate Properties of transactions, Transaction Sates – Explain Concurrent Executions – Explain Serializability
Reference Books:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Online Resources
- https://nptel.ac.in/courses/106106093/
- https://www.tutorialspoint.com/dbms/
- https://www.studytonight.com/dbms/
For detailed syllabus of all other subjects of Computer Application & Business Management (CB), 2021 revision curriculum do visit Computer Application & Business Management 4th Sem subject syllabuses for 2021 revision.
To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..
To see the results of Computer Application & Business Management (CB) of diploma 2021 revision curriculum do visit SITTTR diploma Computer Application & Business Management (CB) results..
For all Computer Application & Business Management academic calendars, visit Computer Application & Business Management all semesters academic calendar direct link.