Database Management System detailed syllabus scheme for Information Technology (IT), 2017 regulation has been taken from the University of Mumbai 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 all other Mumbai University Information Technology 3rd Sem Syllabus 2017 Pattern, do visit IT 3rd Sem 2017 Pattern Scheme. The detailed syllabus scheme for database management system is as follows.
Database Management System Syllabus for Information Technology SE 3rd Sem 2017 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 pdf platform to make students’s lives easier.
.
Course Outcomes:
Student should be able to:
- Explain the features of database management systems and Relational database
- Design conceptual models of a database using ER modeling for real life applications and also construct queries in Relational Algebra
- Create and populate a RDBMS for a real life application, with constraints and keys, using SQL.
- Retrieve any type of information from a data base by formulating complex queries in SQL.
- Analyze the existing design of a database schema and apply concepts of normalization to design an optimal database.
- Build indexing mechanisms for efficient retrieval of information from a database knowledge
Module I
Introduction Database Concepts Introduction, Characteristics of databases, File system V/s Database system, Users of a Database system Data Models, Schemas, and Instances, Three-Schema Architecture and Data Independence, Database Administrator (DBA), Role of a DBA 05 CO 1
Module II
EntityRelationship Data Model Conceptual Modeling of a database, The Entity-Relationship (ER) Model, Entity Types, Entity Sets, Attributes, and Keys, Relationship Types, Relationship Sets, Weak Entity Types Generalization, Specialization and Aggregation, Extended Entity- Relationship (EER) Model. 09 CO 2
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 pdf platform to make students’s lives easier..
Module IV
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, Complex Retrieval Queries using Group By, Recursive Queries, nested Queries ; Referential integrity in SQL. Event Condition Action (ECA) model (Triggers) in SQL; Database Programming with JDBC, Security and authorization in SQL Functions and Procedures in SQL and cursors. 10 CO 3, CO 4
Module V
Relational-Database Design Design guidelines for relational schema, Functional Dependencies, Definition of Normal Forms- 1NF, 2NF, 3NF, BCNF, Converting Relational Schema to higher normal forms. 08 CO 5
Module VI
Storage and Indexing Operation on Files; hashing Techniques; Types of Indexes: SingleLevel Ordered Indexes; Multilevel Indexes; Overview of B-Trees and B+-Trees; Indexes on Multiple Keys. 09 CO 6
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 pdf platform to make students’s lives easier..
Reference Books:
- Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems,TMH
- Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Database System Implementation, Pearson Ltd. 1/ e
- Thomas M. Connolly Carolyn Begg, Database Systems : A Practical Approach to Design, Implementation and Management, 4/e, Pearson Education.
Assessment:
Internal Assessment for 20 marks: Consisting of Two Compulsory Class Tests Approximately 40% to 50% of syllabus content must be covered in First test and remaining 40% to 50% of syllabus contents must be covered in second test. End Semester Theory Examination: Some guidelines for setting the question papers are as:
- Weightage of each module in end semester examination is expected to be/will be proportional to number of respective lecture hours mentioned in the syllabus.
- Question paper will comprise of total six questions, each carrying 20 marks.
- Q.1 will be compulsory and should cover maximum contents of the syllabus.
- Remaining question will be mixed in nature (for example if Q.2 has part
- from module 3 then part
- will be from any other module. (Randomly selected from all the modules)
- Total four questions need to be solved.
For detail syllabus of all other subjects of Information Technology (IT) 3rd Sem 2017 regulation, visit IT 3rd Sem Subjects syllabus for 2017 regulation.