3132: Database Management System KL Diploma Syllabus for IT 3rd Sem 2015 Revision SITTTR

Database Management System detailed syllabus for Information Technology (IT) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the IT 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 Information Technology 3rd Sem scheme and its subjects, do visit IT 3rd Sem 2015 revision scheme. The detailed syllabus of database management system is as follows.

Course 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 – I Database systems

1. To Understand Database systems
   1. Define data, information, field, record, file, and database
   2. Define DBMS
   3. Explain the advantages of DBMS
   4. Describe the applications of DBMS
   5. List the Database Users.
   6. Define instance, schema and subschema
   7. Explain Three Schema architecture with diagram
   8. Explain Data Independence – Logical Data Independence and Physical Data Independence
   9. Describe Conceptual Model, representation and physical model
   10. Explain hierarchical, network and relational models
   11. Describe DBMS Languages – DDL, DML and DCL
   12. Explain Component Modules of DBMS
   13. Centralised and Client-Server Database Systems

MODULE – II Database Design

1. To Understand Database Design
   1. Explain Relational model concepts
   2. Define Domains, Attributes, Tuples , Instances, relations and relational schema
   3. Explain Keys – Super key, candidate key, composite key, primary key and foreign key
   4. Explain E-R Model with example
   5. Discuss the features of Enhanced E-R diagram
   6. Explain Relational Algebra and fundamental operations
   7. Explain Additional Operations – Natural-Join, Outer Join
   8. Explain the mapping of E-R model to relational model

MODULE – III Structured Query Language

1. To Understand SQL
   1. Explain features of SQL
   2. Explain Data types in SQL
   3. Explain CREATE TABLE command with constraints NULL, DEFAULT,CHECK, PRIMARY KEY, UNIQUE, referential Integrity
   4. Explain INSERT, UPDATE and DELETE commands
   5. Explain SELECT statements with WHERE, ORDER BY clause with examples
   6. Describe the use of Aggregate and scalar functions in SELECT statements with examples
   7. Explain SELECT statements with GROUP BY, HAVING clauses with examples
   8. Explain Nested queries, sub queries
   9. Describe DROP TABLE and ALTER TABLE command
   10. Explain what are inner join and outer join
   11. Explain how views are created and used
   12. Explain transactions
   13. Describe integrity constraints
   14. Explain how index creation is done
   15. Explain about authorizations on data and granting & revoking of privileges
   16. Explain how to create and use functions, procedure, cursor and trigger
   17. Explain Database connectivity using JDBC/ ODBC
   18. Explain how to connect to a database

MODULE – IV Emerging Technologies

1. To Understand Normalisation
   1. State functional dependency
   2. Explain the need of normalisation
   3. Describe decomposition of a table with examples
2. To Understand Emerging Technologies
   1. Explain Object Oriented Concepts
   2. Describe Object Identity, Object Structure
   3. Explain Parallel DBMS.
   4. Describe Distributed DBMS
   5. Explain Mobile Databases
   6. State Data Mining Technology
   7. Describe Data Warehousing

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

Database Design Relational Model Concepts – Domain – Attribute – tuple – instance – relation – relational schema -Keys – E R Model – Enhanced E R diagram – sub class – super class – inheritance – specialisation -generalisation – UML class diagram – Relational Algebra operations – select, project, Union, Set Difference, Cartesian Product and Rename – additional operations – Natural-Join, Outer Join – mapping of E-R model to relational model

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

Emerging Technologies Normalisation -Functional Dependency – Decomposition — Introduction to Object oriented databases-Features-Object identity- Object Structure. Parallel DBMS – Overview – Architecture – Distributed DBMS -Advantages Mobile Databases – Concept .Databases and Internet.Introduction to Data Mining and Data warehousing.

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

Reference Books:

1. Introduction to Database Systems – ITL Education Solutions Ltd – PEARSON- 2010
2. Database system concepts – Silberschatz, Korth, and Sudarshan (TMH)-Sixth Edition
3. SQL for professional – Swapne & Rajesh Naik

For detailed syllabus of all other subjects of Information Technology, 2015 revision curriculum do visit IT 3rd 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.