Skip to content

Home
Engineering (BE)
Mar’24 month certification
FAQ – Mar’24 Month Certification Drive
Registration Certification link
My Account
Log In
Contact

Home
Engineering (BE)
Mar’24 month certification
FAQ – Mar’24 Month Certification Drive
Registration Certification link
My Account
Log In
Contact

SE IT SEM 3 – DATABASE MANAGEMENT SYSTEM

Course Content

Expand All

Module 1 – Database System Concepts & Architecture 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

1.1 Introduction

1.2 Characteristics of database

1.3 File system V/S database system

1.4 Data abstraction and data independence

1.5 DBMS system architecture

1.6 Database administrator (DBA)

1.7 Role of DBA

1.8.a Self -learning topics

Module 2 – The Entity-Relationship Model 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

2.1 Conceptual modeling of database

2.2 The Entity-Relationship (ER) model

2.4 Entity type

2.5 Attribute and keys

2.6 Relationship types

2.7 Relationship sets

2.8 Weak-entity types

2.9 Generalization, specialization and aggregation

2.10 Extended Entity-Relationship (EER) model

2.11.a Self -learning topics – Design and ER model for any real time case study

Module 3 – Relational Model & Relational Algebra 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

3.1 Introduction to relational model

3.3.a Concept of keys – Primary key

3.3.b Concept of keys – Secondary key

3.3.c Concept of keys – Foreign key

3.4 Mapping the ER and EER model to relational model

3.5 Introduction to relational algebra

3.6.a Relational algebra expressions for unary relational operations – Set theory operations

3.6.b.1 Binary relational operations – Join operation

3.6.b.2 Binary relational operations – Difference operation

3.7 Relational algebra queries

3.8.a Self -learning topics – Map the ER model designed in module II to relational schema

Module 4 – Structured Query Language (SQL) & Indexing 16 Topics

Expand

Lesson Content

0% Complete 0/16 Steps

4.1 Overview of SQL

4.2 Data Definition Commands

4.3 Set operations

4.4 Aggregate function

4.5 Null values

4.6 Data manipulation commands

4.7 Data control commands

4.8 Complex retrieval queries using Group By

4.9 Recursive queries

4.10 Nested queries

4.11 Integrity constraints in SQL

4.12 Database programming with JDBC

4.14 Grant and revoke in SQL functions

4.15 Procedures in SQL and cursors

4.16.a Indexing – Basic concepts and Ordered indices

4.17.a Self -learning topics – Physical design of database for the relational model designed in module III and fire various query

Module 5 – Relational Database Design 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

5.1 Design guidelines for relational schema

5.2 Functional dependencies

5.3 Database tables and normalization

5.4 The need for normalization

5.6 Improving the design

5.8.a Self -learning topics – Consider any real time application and normalization into 3NF/BCNF

Module 6 – Transactions Management & Concurrency & Recovery 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

6.1.a Transaction – Transaction concept

6.1.b Transaction – State diagram

6.1.c Transaction – ACID properties

6.1.d Transaction – Transaction control commands

6.1.e Transaction – Concurrent executions

6.2.a Serializability – Conflict and view

6.3.a Concurrency control – Lock-based protocols

6.3.b Concurrency control – Deadlock handling

6.3.c Lock-based protocols – Timestamp based protocols

6.4.a Recovery system – Recovery concepts

6.4.b Recovery system – Log-based recovery

6.5.a Self -learning topics – Study the various deadlock situation which may occur for a database designed in module V.

Get Certified in Technology Skills for Better Job Opportunities for Mumbai University Students

Copyright © 2024 MuCertification.com

Powered by MUQuestionPapers.com

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Continue with Facebook

Continue with Google

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Password

Confirm Password

Continue with Facebook

Continue with Google

Subscribe to our Free Newsletter

Registration confirmation will be emailed to you.