4255: Relational Database Management System KL Diploma Syllabus for CA&BM 4th Sem 2015 Revision SITTTR

Relational Database Management System detailed syllabus for Computer Application & Business Management (CA&BM) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the CA&BM 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 CA&BM 4th Sem 2015 revision scheme. The detailed syllabus of relational database management system is as follows.

Course General Outcomes:

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.
.

SPECIFIC OUTCOMES

MODULE – 1

1. Understand Database
   1. Define Field, Record, Database
   2. Distinguish between Physical record -and Logical Record
   3. Explain Advantages of DBMS
   4. Understand Schema, Subschema, – Instances, Three schema architecture
   5. Define data independence.
   6. Distinguish between Logical data independence and Physical data independence
2. Know Database system structure(Architecture)
   1. Explain Storage manager, Query processor, Disk storage, Database Users
   2. Distinguish Database Languages – DDL , DML,DCL
   3. Explain various Database system application architectures like Centralized DBMS architecture, Basic client/server architecture, Two tier client/server architectures, and three tier client/server architectures
3. Understanding Data Models
   1. Explain ER model
   2. Define Entity, Attribute, Keys, Relationship types, Relationship set
   3. Define Primary key, Candidate key, Super key
   4. Explain ER diagram, Weak entity set
   5. Compare ER Model and Enhanced ER Model
   6. Describe EER Model: Subclasses – Super classes – Inheritance – Specialisation – Generalisation
   7. Define Unified Modelling Language- Class diagram

MODULE – 2

1. Understand Relational model Concepts
   1. Define Domains, Attributes, Tuples
   2. Explain Mapping ER model to Relational model
   3. Explain Constraints: Domain constraints, Key constraints, Entity integrity, Referential integrity, Foreign keys
2. Understand Relational algebra operations
   1. Explain the following operations with examples: Select, Project, Rename, Union, Intersection, Difference, Cartesian Product, Division, Join, Equijoin, Natural join
3. Understand Relational database design
   1. Explain design guidelines for relation schema
   2. Define Functional dependency
   3. Define Normalization
   4. Explain normal forms: 1NF – 2NF – 3NF – Boyce Codd Normal Form
   5. Explain Decomposition, Dependency preservation, Multi-valued dependencies
   6. Explain 4NF with example
   7. Explain Join dependencies and define 5NF

MODULE – 3

1. Understand SQL
   1. Explain features of SQL
   2. Explain Data types in SQL
   3. Differentiate Domains, attributes, and tuples
2. Creation of Table
   1. Explain CREATE TABLE command
   2. Explain Constraints: NULL, DEFAULT,CHECK, PRIMARY KEY, UNIQUE, referential Integrity
   3. Explain DROP TABLE Command , ALTER TABLE
   4. Explain commands for creating and roping indexes CREATE INDEX, CREATE UNIQUE INDEX, DROP INDEX
   5. Explain SELECT statements with WHERE, ORDER BY clause with examples
   6. Describe UPDATE Statement, INSERT, DELETE with example
   7. Explain Nested queries, tuples and multi set comparison, Correlated nested queries
   8. Explain EXISTS and UNIQUE functions
   9. Explain explicit sets and renaming of attributes
   10. Explain Joining tables – aggregate functions
   11. Explain grouping: GROUP BY, HAVING clauses
   12. Explain BEGIN TRANS, COMMITT, ROLL BACK, SAVE POINT
   13. Explain Views: Advantages, Creation and Updation
   14. Explain Query optimization

MODULE – 4

1. Understand advanced SQL
   1. Define triggers and cursors
   2. Explain reports and forms
   3. Explain stored procedures and functions
   4. Explain how Procedures are invoked from Interface
2. Understand Embedded SQL
   1. Understand about Embedded SQL statements and its application
   2. Explain retrieving single tuples with embedded SQL
   3. Explain retrieving multiple tuples with embedded SQL using cursor
   4. Explain dynamic SQL by specifying queries at run time
3. Understand Transaction management
   1. Define Transaction
   2. Explain transaction concepts
   3. Differentiate Properties of transactions, , Transaction Sates
   4. Explain Concurrent Executions
   5. Explain Serializability

MODULE – I :

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 – II :

Relational model – Concepts – Constraints – Key constraints – Referential integrity – Foreign keys Relational algebra operations -Unary & Binary relational operations Relational database design -Guidelines- Functional dependency – Normalization – 1NF – 2NF – 3NF – Boyce Codd Normal Form – Decomposition – Dependency preservation – Multivalued dependencies -4NF – Join dependencies – 5NF

MODULE – III :

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 – IV:

Triggers, cursers – stored procedures and functions, embedded SQL, Retrieving single tuples with embedded SQL Dynamic SQL – specifying queries at run time using dynamic SQL Transaction management-Transaction concepts -Properties of transactions-Sates-Concurrent Executions-Serializability

BOOKS RECOMMENDED

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.
.

For detailed syllabus of all other subjects of Computer Application & Business Management, 2015 revision curriculum do visit CA&BM 4th Sem subject syllabuses for 2015 revision.

To see the syllabus of all other branches of diploma 2015 revision curriculum do visit all branches of SITTTR diploma 2015 revision.