CSC502: Database Management System Syllabus for CS 5th Sem 2018 Pattern Mumbai University

Database Management System detailed syllabus scheme for Computer Engineering (CS), 2018 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 Computer Engineering 5th Sem Syllabus 2018 Pattern, do visit CS 5th Sem 2018 Pattern Scheme. The detailed syllabus scheme for database management system is as follows.

Database Management System Syllabus for Computer 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 pdf platform to make students’s lives easier.
.

Course Outcomes:

On successful completion of course learner will be able to:

1. Understand the fundamentals of a database systems
2. Design and draw ER and EER diagram for the real life problem.
3. Convert conceptual model to relational model and formulate relational algebra queries.
4. Design and querying database using SQL.
5. Analyze and apply concepts of normalization to relational database design.
6. Understand the concept of transaction, concurrency and recovery.

Prerequisites:

Basic knowledge of Data structure.

Module 1

Introduction Database Concepts: 4

1. 1. Introduction, Characteristics of databases
   2. File system v/s Database system
   3. Users of Database system
2. 1. Data Independence
   2. DBMS system architecture
   3. Database Administrator

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 pdf platform to make students’s lives easier.
.

Module 3

Relational Model and relational Algebra 8

1. 1. Introduction to the Relational Model, relational schema and concept of keys.
   2. Mapping the ER and EER Model to the Relational Model
2. 1. Relational Algebra – unary and set operations, Relational Algebra Queries.

Module 4

Structured Query Language (SQL. 12

1. 1. Overview of SQL
   2. Data Definition Commands, Data Manipulation commands, Data Control commands, Transaction Control Commands.
2. 1. Set and string operations, aggregate function – group by, having.
   2. Views in SQL, joins , Nested and complex queries, Integrity constraints :- key constraints, Domain Constraints, Referential integrity , check constraints
3. 1. Triggers

Module 5

Relational-Database Design 8

1. Pitfalls in Relational-Database designs , Concept of normalization
2. Function Dependencies , First Normal Form, 2nd , 3rd , BCNF, multi valued dependencies , 4NF.

Module 6

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

Assessment

Internal Assessment: Assessment consists of two class tests of 20 marks each. The first class test is to be conducted when approx. 40% syllabus is completed and second class test when additional 40% syllabus is completed. Duration of each test shall be one hour. End Semester Theory Examination:

1. Question paper will comprise of 6 questions, each carrying 20 marks.
2. The students need to solve total 4 questions.
3. Question No.1 will be compulsory and based on entire syllabus.
4. Remaining question (Q.2 to Q.6) will be selected from all the modules.

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, 5th Edition, 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. Gillenson, Paulraj Ponniah, Introduction to Database Management, Wiley Publication.
3. Sharaman Shah, Oracle for Professional, SPD.
4. Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems ,TMH.

For detail syllabus of all other subjects of Computer Engineering (CS) 5th Sem 2018 regulation, visit CS 5th Sem Subjects syllabus for 2018 regulation.