ISDLO5013: Database Management System Syllabus for IS 5th Sem 2018 Pattern Mumbai University (Department Level Optional Course-1)

Database Management System detailed syllabus scheme for Instrumentation Engineering (IS), 2018 regulation has been taken from the MU official website and presented for the Bachelor of Engineering students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.

For 5th Sem Scheme of Instrumentation Engineering (IS), 2018 Pattern, do visit IS 5th Sem Scheme, 2018 Pattern. For the Department Level Optional Course-1 scheme of 5th Sem 2018 regulation, refer to IS 5th Sem Department Level Optional Course-1 Scheme 2018 Pattern. The detail syllabus for database management system is as follows.

Database Management System Syllabus for Instrumentation Engineering TE 5th Sem 2018 Pattern Mumbai University

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:

The student will be able to:

1. To describe data models and schemas in DBMS.
2. Explain the features of database management systems and Relational database.
3. Use SQL- the standard language of relational databases.
4. Identify the functional dependencies and Design a database.
5. Describe the concept of Transactions Management and Concurrency.
6. Explain the concept of Query Processing and Optimization.

Module 1

Introduction Database Concepts: Introduction, Characteristics of databases, File system V/s Database system, Users of Database system, Concerns when using an enterprise database, Data Independence, DBMS system architecture, Database Administrator Entity-Relationship Data Model : Introduction, Benefits of Data Modeling, Types of Models, Phases of Database Modeling, The Entity-Relationship (ER. Model, Generalization, Specialization and Aggregation, Extended EntityRelationship (EER) Model. 06 CO1

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

Structured Query Language (SQL) : Overview of SQL , Data Definition Commands, Set operations , aggregate function , null values, , Data Manipulation commands, Data Control commands , Views in SQL, Nested and complex queries . 06 CO3

Module 4

Integrity and Security in Database: Domain Constraints, Referential integrity, Assertions, Trigger, Security, and authorization in SQL Relational-Database Design : Design guidelines for relational schema, Function dependencies, Normal Forms- 1NF, 2 NF, 3NF, BCNF and 4NF 08 CO4

Module 5

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 6

Query Processing and Optimization: Overview ,Issues in Query Optimization ,Steps in Query Processing , System Catalog or Metadata, Query Parsing , Query Optimization, Access Paths , Query Code Generation , Query Execution , Algorithms for Computing Selection and Projection , Algorithms for Computing a Join , Computing Aggregation Functions, Cost Based Query Optimization . 04 CO6

Internal Assessment:

Internal Assessment consists of two tests out of which, (on Minimum 02 Modules).

Theory Examination:

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

Text Books:

1. G. K. Gupta :Database Management Systems, McGraw – Hill.
2. Korth, Slberchatz,Sudarshan, :Database System Concepts, 6th Edition, McGraw – Hill
3. Elmasri and Navathe, Fundamentals of Database Systems, 5thEdition, PEARSON Education.
4. Peter Rob and Carlos Coronel, Database Systems Design, Implementation and Management, Thomson Learning, 5th Edition.

Reference Books:

1. Dr. P.S. Deshpande, SQL and PL/SQL for Oracle 10g,Black Book, Dreamtech Press
2. Mark L. Gillenson, Paulraj Ponniah, Introduction to Database Management,Wiley
3. Sharaman Shah ,Oracle for Professional, SPD.
4. Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems,TMH
5. Debabrata Sahoo Database Management Systems Tata McGraw Hill, Schaums Outline

For detail Syllabus of all subjects of Instrumentation Engineering (IS) 5th Sem 2018 regulation, visit IS 5th Sem Subjects of 2018 Pattern.