CSDLO6022: Advance Database System Syllabus for CS 6th Sem 2018 Pattern Mumbai University (Department Level Optional Course-2)

Advance Database System detailed syllabus scheme for Computer Engineering (CS), 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 6th Sem Scheme of Computer Engineering (CS), 2018 Pattern, do visit CS 6th Sem Scheme, 2018 Pattern. For the Department Level Optional Course-2 scheme of 6th Sem 2018 regulation, refer to CS 6th Sem Department Level Optional Course-2 Scheme 2018 Pattern. The detail syllabus for advance database system is as follows.

Advance Database System Syllabus for Computer Engineering TE 6th 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:

On successful completion of course learner will be able to:

1. Build indexing mechanisms for efficient retrieval of information from databases.
2. Measure query cost and optimize query execution
3. Design distributed database for better resource management
4. Demonstrate the understanding of the concepts of document oriented databases.
5. Apply appropriate security techniques database systems.
6. Implement advanced data models for real life applications.

Prerequisites:

Basic knowledge of Database management System.

Module 1

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 2

Query processing and Optimization 12 Query Processing :

• Overview
• Measures of Query cost
• Selection operation
• Sorting
• Join Operations, and other Operations Evaluation of Expression Query Optimization :
• Translations of SQL Queries into relational algebra
• Heuristic approach & cost based optimization

Module 3

Distributed Databases 12

1. • Types of Distributed Database Systems; Distributed Database Architectures; Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design
2. • Distributed Query Processing (Semi join)
   • distributed Transaction Management in Distributed Databases
   • distributed Concurrency Control (locking) , Recovery in Distributed Databases {2PC/3PC) and deadlock management.

Module 4

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 5

Advanced data models 6

1. • Temporal data models :- Aspects of valid time , Bitemporal time and bi-temporal time with examples of each.
   • Spatial model :- Types of spatial data models -Raster, Vector and Image
   • Mobile databases
2. • Multimedia databases

Module 6

Data Security 6

1. • Introduction to Database Security Issues; authorization , Discretionary Access Control Based on Granting and Revoking Privileges
   • Mandatory Access Control and Role-Based
2. Access Control for Multilevel Security
   • SQL Injection
   • Introduction to Statistical Database Security Introduction to Flow Control

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. Chhanda Ray , Distributed Database System, Pearson Education India.
2. Hector Garcia-Molina, Jeffery D. Ullman, Jennifer Widom , Database system Implementation
3. Thomas M.Connolly Carolyn Begg, Database Systems : A practical Approach to Design , Implementation and Management, 4/e.

Suggested mini. Project I Experiment work:

1. Given problem statement 2/3 student to perform-
   1. Design EER model and perform sorting, join operations for the specified problem statement.
   2. Perform the various fragmentation (Horizontal, Vertical, Derived) and check its correctness criteria.
   3. Perform two phase commit protocol (2PC)
2. Mini Project / Case study on document oriented database such a Mariadb
3. Mini Project Case study Development of an application based on any one advance data model (temporal, Spatial Multimedia )

Perform Laboratory (Experiments) work in the in Mini-Project

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.

For detail Syllabus of all subjects of Computer Engineering (CS) 6th Sem 2018 regulation, visit CS 6th Sem Subjects of 2018 Pattern.