Relational and Distributed Databases(CUCS1005)

Teacher

MANOJ KUMAR PADHI

Category

Course Attendees

Still no participant

Course Reviews

Still no reviews


Relational and Distributed Databases CUCS1005(Year-2025)

Track Total Credits ( 2-2-0)

Courses Division( list all divisions):

Course Objective:

  • Understand the fundamental concepts of relational databases.
  • Learn advanced SQL and database normalization.
  • Explore practically the principles and architecture of distributed databases.

Learning Outcomes:

CO1 Explain the fundamental concepts and principles of relational databases. (Understand, Remember)
CO2 Apply advanced SQL queries and database normalization techniques. (Apply, Create)
CO3 Describe the principles and architecture of distributed databases. (Understand, Remember)
CO4 Implement and manage relational and distributed database systems. (Apply, Evaluate)
CO5 Analyze and optimize database performance. (Analyze, Evaluate)

Module 1: Database System Concepts and Data Models (14 Hours)

  • Overview of Database
  • Concept of Different Data Models
  • DBMS Architecture and Building a DBMS

Practice

o Collect data from different data sources and identify the type of data source

o Installation of MySQL Workbench. Import and export the database into MySQL Workbench

o Create instances of database in MySQL.

o Viewing all databases

o Viewing all Tables in a Database

o Creating Tables (With and Without Constraints)

Module 2: Introduction to Relational Databases (14 Hours)

  • Overview of Relational Databases
  • Database Models and ER Diagrams
  • Relational Algebra and Calculus

Practice

o Experiment 1.1: Creating ER Diagrams

o Experiment 1.2: Translating ER Diagrams to Relational Schemas

o Experiment 1.3: Implementing Relational Schemas in MySQL

o Experiment 1.4: Basic SQL Queries (SELECT, INSERT, UPDATE, DELETE)

o Experiment 1.5: Advanced SQL Queries (JOIN, UNION, INTERSECT)

o Experiment 1.6: Using Aggregate Functions in SQL

Module 3: Advanced SQL and Database Normalization (14 Hours)

  • Advanced SQL Concepts (Subqueries, Indexing, Views)
  • Database Normalization (1NF, 2NF, 3NF, BCNF)
  • Transaction Management and Concurrency Control

Practice

o Experiment 2.1: Writing Subqueries in SQL

o Experiment 2.2: Creating and Managing Indexes

o Experiment 2.3: Implementing Views

o Experiment 2.4: Normalizing a Database to 3NF

o Experiment 2.5: Creating Transactions in SQL

o Experiment 2.6: Implementing Concurrency Control Mechanisms

Module 4: Introduction to Distributed Databases (14 Hours)

  • Overview of Distributed Databases
  • Distributed Database Architectures
  • Data Fragmentation, Replication, and Allocation

Practice

o Experiment 3.1: Setting Up a Distributed Database Environment

o Experiment 3.2: Implementing Data Fragmentation

o Experiment 3.3: Configuring Data Replication

o Experiment 3.4: Managing Data Allocation

o Experiment 3.5: Connecting and Querying Distributed Databases

o Experiment 3.6: Ensuring Data Consistency in a Distributed Environment

Module 5: Distributed Database Transactions (14 Hours)

  • Distributed Transactions and Concurrency Control
  • Two-Phase Commit Protocol
  • Distributed Query Processing and Optimization

Practice

o Experiment 4.1: Implementing Distributed Transactions

o Experiment 4.2: Applying the Two-Phase Commit Protocol

o Experiment 4.3: Distributed Query Processing

o Experiment 4.4: Optimizing Distributed Queries

o Experiment 4.5: Handling Failures in Distributed Transactions

o Experiment 4.6: Monitoring and Troubleshooting Distributed Transactions

 

Module 6: Database Performance and Tuning (14 Hours)

  • Database Performance Metrics
  • Indexing and Query Optimization
  • Database Tuning Techniques

Practice

o Experiment 5.1: Analyzing Database Performance Metrics

o Experiment 5.2: Implementing Indexes for Performance Optimization

o Experiment 5.3: Query Optimization Techniques

o Experiment 5.4: Performing Database Tuning

o Experiment 5.5: Monitoring and Troubleshooting Database Performance

o Experiment 5.6: Conducting a Performance Audit

 

Module 7: Emerging Trends in Databases (14 Hours)

  • NoSQL Databases: Concepts and Applications
  • NewSQL Databases: Characteristics and Use Cases
  • Big Data and Databases in Cloud Computing
  • Future Directions in Database Technologies

RecommendedResources:

 

  • Books:
    • "Database System Concepts" by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan
    • "Distributed Systems: Principles and Paradigms" by Andrew S. Tanenbaum and Maarten Van Steen
    • "SQL Performance Explained" by Markus Winand "
    • NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence" by Pramod J. Sadalage and Martin Fowler

 

 

Session Plan:

Overview of Database

https://www.geeksforgeeks.org/dbms/what-is-database/

you tube link:

https://www.youtube.com/watch?v=3EJlovevfcA

Theory
Concept of Different Data Models

https://share.google/0IxWVTJ6HPqiH73Fb

you tube link:

https://youtu.be/OwQoj3GJfNY?si=-BYDLZJ-IdbsdjpX

Theory
Collect data from different data sources and identify the type of data source

you tube link:

https://youtu.be/Dv_uCk1ZhPc?si=c17NOy7TiCURGH72

Practical
Installation of MySQL Workbench. Import and export the database into MySQL Workbench

https://www.youtube.com/watch?v=v8i2NgiM5pE

Practical
Concept of Different Data Models

https://share.google/0IxWVTJ6HPqiH73Fb

you tube link:

https://youtu.be/OwQoj3GJfNY?si=-BYDLZJ-IdbsdjpX

 

Theory
DBMS Architecture, and Building a DBMS

https://share.google/2mrq5LRHtsAePfytJ

you tube link:

https://youtu.be/8_W5JT7Jz2Y?si=J7KcpGktCcECpdiF

Theory
Create instances of database in MySQL.

https://www.youtube.com/watch?v=s3_SlfV9IdM

Practical
Creating Tables (With and Without Constraints)

https://www.youtube.com/watch?v=v-2cIUgx_jw

Practical
Overview of Relational Databases

 

https://www.geeksforgeeks.org/dbms/relational-model-in-dbms/

 

https://youtu.be/WI9dE8-TFAc?si=wt1fMfycDHwXvqfe

Theory
Overview of Relational Databases

https://www.geeksforgeeks.org/dbms/relational-model-in-dbms/

 

https://youtu.be/WI9dE8-TFAc?si=wt1fMfycDHwXvqfe

Theory
 Basic SQL Queries (SELECT, INSERT, UPDATE, DELETE)

https://youtu.be/eiLqDeDp7Oc?si=D-FGvjn1KnujlDpX

Practical
Basic SQL Queries (SELECT, INSERT, UPDATE, DELETE)

https://youtu.be/eiLqDeDp7Oc?si=D-FGvjn1KnujlDpX

Practical
Database Models and ER Diagrams

https://share.google/sovK71uBAfF2fLr24

 

https://youtu.be/gbVev8RuZLg?si=YlUeZDqPtEhuT9TW

 

Theory
Relational Algebra and Calculus

https://share.google/iBWroJLyi5DWYvfgc

 

https://www.youtube.com/watch?v=EwEY_Y2Zz0s&list=PL3R9-um41JszwZtQ91SlFbBw8Vx5Pb340

Theory
Advanced SQL Queries (JOIN, UNION, INTERSECT)

https://datalemur.com/sql-tutorial/sql-union-intercept-except

 

https://www.youtube.com/watch?v=V3xjmBi1QQE

Practical
Using Aggregate Functions in SQL

https://youtu.be/Yr4pHPZCshA?si=NOLNolQBd6Y79PuT

 

Practical
Advanced SQL Concepts (Subqueries, Indexing, Views)

https://www.geeksforgeeks.org/sql/sql-subquery/

 

https://www.youtube.com/watch?v=5O2OuN1ougU

 

Theory
Advanced SQL Concepts (Subqueries, Indexing, Views)

 

https://www.geeksforgeeks.org/sql/sql-subquery/

 

https://www.youtube.com/watch?v=5O2OuN1ougU

Theory
Writing Subqueries in SQL

https://www.youtube.com/watch?v=5O2OuN1ougU

Practical
Writing Subqueries in SQL

 

https://www.youtube.com/watch?v=5O2OuN1ougU

Practical
Database Normalization (1NF, 2NF, 3NF, BCNF)

https://www.digitalocean.com/community/tutorials/database-normalization

 

https://www.geeksforgeeks.org/dbms/normal-forms-in-dbms/

 

https://youtu.be/EGEwkad_llA?si=2cx80fYyyUsyYCGl

Theory
Transaction Management and Concurrency Control

https://share.google/VO9BwvNpiJbtHy2Yi

 

https://share.google/xxBHcetuWjpRQr53Z

 

https://www.scribd.com/document/511424613/lecture03transactionconcurrencycontrol-121201053857-phpapp01

 

https://www.youtube.com/watch?v=t5hsV9lC1rU&list=PLFnnUST2z6IXEnNNYCKV40ar-CtYN_aD8

 

 

Theory
Using Aggregate Functions in SQL

 

https://www.youtube.com/watch?v=9NfthspfXEo

Practical
Implementing Relational Schemas in MySQL

 

https://www.youtube.com/watch?v=nbTBw7iV6KA

Practical
Overview of Distributed Databases

 

https://share.google/3rKjJie5UzUbP43Kz

 

https://www.youtube.com/watch?v=Q1RIpXS7lPc&list=PLV8vIYTIdSnbAW2wj_TiHyrFJId5zkhz2

Theory
Overview of Distributed Databases

https://share.google/3rKjJie5UzUbP43Kz

 

https://www.youtube.com/watch?v=Q1RIpXS7lPc&list=PLV8vIYTIdSnbAW2wj_TiHyrFJId5zkhz2

Theory
Setting Up a Distributed Database Environment

 

https://www.youtube.com/watch?v=TtP9Lr3oWMw

Practical
Implementing Data Fragmentation

 

https://www.youtube.com/watch?v=W0BSpV4bM74

 

Practical
Distributed Database Architectures

https://www.tutorialspoint.com/distributed-database-architecture

 

https://www.youtube.com/watch?v=yCokw7VSbZw&list=PL0s3O6GgLL5ftzY3smhxUmzbzIE7JIraU

Theory
Data Fragmentation, Replication, and Allocation

https://share.google/F36upemFpuDhkDgvV

 

https://youtu.be/9GtoDxCQGvk?si=N1ZxItr48DzSfc8L

 

Theory
Connecting and Querying Distributed Databases

 

https://www.youtube.com/watch?v=GPz7RgBNEYE

 

https://youtu.be/JBqpPYth8ts?si=2yOaUXSvOBusPLOc

Practical
Ensuring Data Consistency in a Distributed Environment

 

https://www.youtube.com/watch?v=m4q7VkgDWrM

Practical
Distributed Transactions and Concurrency Control

 

https://www.slideshare.net/slideshow/distributed-dbms-unit-8-distributed-transaction-management-concurrency-control/70892939

 

https://www.geeksforgeeks.org/operating-systems/concurrency-control-in-distributed-transactions/

 

https://www.youtube.com/watch?v=t5hsV9lC1rU&list=PLAXUYU7PbJhiOTtYhGANw3X5ILJ6DT9YT

 

 

Theory
Distributed Transactions and Concurrency Control

 

 

 

https://www.slideshare.net/slideshow/distributed-dbms-unit-8-distributed-transaction-management-concurrency-control/70892939

 

https://www.geeksforgeeks.org/operating-systems/concurrency-control-in-distributed-transactions/

 

https://www.youtube.com/watch?v=t5hsV9lC1rU&list=PLAXUYU7PbJhiOTtYhGANw3X5ILJ6DT9YT

 

Theory
Implementing Distributed Transactions

 

https://www.youtube.com/watch?v=7FgU1D4EnpQ

 

 

https://www.youtube.com/watch?v=d2z78guUR4g

 

Practical
Implementing Distributed Transactions

 

https://www.youtube.com/watch?v=7FgU1D4EnpQ

 

 

https://www.youtube.com/watch?v=d2z78guUR4g

Practical
Two-Phase Commit Protocol

 

https://share.google/NOAdWPfMpjM2KTOUf

 

 

https://www.youtube.com/watch?v=7FgU1D4EnpQ

Theory
Distributed Query Processing and Optimization

 

https://www.tutorialspoint.com/distributed_dbms/distributed_dbms_query_optimization_distributed_systems.htm

 

https://www.slideshare.net/slideshow/query-processing-in-distributed-database-system/231612789

 

 

https://www.youtube.com/watch?v=GPz7RgBNEYE

 

https://youtu.be/TyHUU05XKMY?si=LSCcXfvUNkl8GcVV

Theory
Applying the Two-Phase Commit Protocol

 

https://www.youtube.com/watch?v=7FgU1D4EnpQ

Practical
Handling Failures in Distributed Transactions

 

https://www.youtube.com/watch?v=d2f0_-ZfIP8

Practical
Database Performance Metrics

 

https://blog.quest.com/10-database-monitoring-metrics-to-track-for-optimal-performance/

 

 

https://youtube.com/shorts/lrJW8UAU_6A?si=D99i1ars-BSMbO7f

 

Theory
Indexing and Query Optimization

 

https://fitech101.aalto.fi/fi/courses/designing-and-building-scalable-web-applications/part-2/5-indexing-and-query-optimization

 

https://youtu.be/xXtig5uLQS4?si=lkeXDqg8F5AlXxD2

 

https://youtu.be/TyHUU05XKMY?si=Hmbxm6rG9Lz1ZOVm

 

Theory
Analyzing Database Performance Metrics

 

https://youtu.be/F2TnBCn4EaA?si=_JJi4mZOvcvtuaP0

Practical
Implementing Indexes for Performance Optimization

 

https://youtu.be/xXtig5uLQS4?si=kL9xi8kuPItZT1yu

Practical
Database Tuning Techniques

 

https://www.tutorialspoint.com/sql/sql-database-tuning.htm

 

https://www.geeksforgeeks.org/sql/sql-database-tuning/

 

 

https://youtu.be/xuxgxdbCPnY?si=fvQb_Yi85n9tOzjO

 

 

https://youtu.be/BHwzDmr6d7s?si=M4psp1OYICzcjlSF

Theory
Database Tuning Techniques

 

https://www.geeksforgeeks.org/sql/sql-database-tuning/

 

https://youtu.be/BHwzDmr6d7s?si=M4psp1OYICzcjlSF

Theory
Performing Database Tuning

 

https://youtu.be/xuxgxdbCPnY?si=fvQb_Yi85n9tOzjO

Practical
Monitoring and Troubleshooting Database Performance

 

 

https://www.youtube.com/watch?v=5dYGhK2MqOk&list=PLhiNPw_JwRBB01xtzzxfrM3Vx8mMbCp0V

Practical
NoSQL Databases: Concepts and Applications

 

https://www.geeksforgeeks.org/dbms/introduction-to-nosql/

 

https://youtu.be/xQnIN9bW0og?si=jWrn6JLeZtMcqd8B

Theory
Future Directions in Database Technologies

 

https://www.dataversity.net/articles/the-future-of-database-management-systems/

 

https://youtu.be/33n50Du6rMQ?si=In9wnyd55tZx0r2q

 

https://youtu.be/dIpqY_8PrF0?si=49PVnKBol2Hnfsrf

Theory
 

 

Distributed Query Processing

 

https://www.geeksforgeeks.org/dbms/query-processing-in-distributed-dbms/

 

 

https://youtu.be/SI8GrBH47Oo?si=nbnVCBm5saNPNQIf

 

Practical
Distributed Query Processing

 

https://www.geeksforgeeks.org/dbms/query-processing-in-distributed-dbms/

 

 

https://youtu.be/SI8GrBH47Oo?si=nbnVCBm5saNPNQIf

Practical
NewSQL Databases: Characteristics and Use Cases

 

https://www.baeldung.com/sql/database-newsql-intro

 

 

https://www.youtube.com/watch?v=tT37mu6Kx-A&t=175s

 

https://youtu.be/wElXFk9_9yQ?si=JaYQZd7iuo1m3pWy

Theory
Big Data and Databases in Cloud Computing

 

https://americancloud.com/blog/big-data-and-cloud-computing-how-they-work-together

 

 

https://youtu.be/LOuAOZWJ9RA?si=cyWtVyi1VVU1MSei

Theory
Handling Failures in Distributed Transactions

 

https://youtu.be/d2f0_-ZfIP8?si=98rBJtdYqyP6ESBK

Practical
Handling Failures in Distributed Transactions

 

https://youtu.be/d2f0_-ZfIP8?si=98rBJtdYqyP6ESBK

Practical

List of Projects/ papers/jobs/products to be done in domain:

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Our Main Teachers

MANOJ KUMAR PADHI working as Assistant Professor, Dept of CSE, Centurion University of Technology and Management, ODISHA . Interested to work on Machine learning,Advanced Java Programming,Deep Learning. Programming Skill: C Programming Data Structure Object Oriented Programming using C++ Formal Language Automata Theory Python Web Development(HTML,CSS,PHP) Database Management Systems Compilers