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

 

material:

 

https://docs.google.com/presentation/d/1C0A_85_r4ITj7lcLoLUW0XtDkPw7CGtP/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

Concept of Different Data Models

https://share.google/0IxWVTJ6HPqiH73Fb

you tube link:

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

 

material:

https://drive.google.com/file/d/1Ap575DyFyxyOFYEbO4_06baywXrbHHzG/view?usp=drive_link

 

 

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

you tube link:

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

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

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

Concept of Different Data Models

https://share.google/0IxWVTJ6HPqiH73Fb

you tube link:

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

 

material:

https://drive.google.com/file/d/1Ap575DyFyxyOFYEbO4_06baywXrbHHzG/view?usp=drive_link

 

 

DBMS Architecture and Building a DBMS

https://share.google/2mrq5LRHtsAePfytJ

you tube link:

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

 

material:

 

https://docs.google.com/presentation/d/1idMBslIX8Zqb8g52WFCCSgjvzIVbpJaj/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Create instances of database in MySQL.

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

Creating Tables (With and Without Constraints)

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

Overview of Relational Databases

 

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

 

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

 

material:

 

https://docs.google.com/presentation/d/1autCtj8OSVMzlax6A251JQ9gbZHbcZgz/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

Overview of Relational Databases

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

 

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

 

material:

 

https://docs.google.com/presentation/d/1autCtj8OSVMzlax6A251JQ9gbZHbcZgz/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

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

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

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

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

 

 

 

 

Database Models and ER Diagrams

https://share.google/sovK71uBAfF2fLr24

 

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

 

material:

 

https://docs.google.com/presentation/d/16OODhSfV5Sdm7Muww2n22FT1d9uGbUks/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

Relational Algebra and Calculus

https://share.google/iBWroJLyi5DWYvfgc

 

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

 

 

 

 

 

material:

 

https://docs.google.com/presentation/d/1AjiaQ9w_cSQvcjEvnAhp16OFAPV33NCk/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Advanced SQL Queries (JOIN, UNION, INTERSECT)

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

 

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

Using Aggregate Functions in SQL

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

 

Advanced SQL Concepts (Subqueries, Indexing, Views)

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

 

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

 

material:

 

https://docs.google.com/presentation/d/1SnSYYmtnspIYTU_7VKBDmNtHd8UYApsZ/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Advanced SQL Concepts (Subqueries, Indexing, Views)

 

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

 

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

 

material:

 

https://drive.google.com/file/d/10bAB0LpC-gu8ZuveI3GQ9S1EZOaotKl3/view?usp=sharing

 

Writing Subqueries in SQL

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

Writing Subqueries in SQL

 

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

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

 

 

 

 

 

material:

 

https://docs.google.com/presentation/d/1hWfdiJhSfD0mKZ1Br--eLuXMccL-SE58/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

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

 

 

material:

 

https://docs.google.com/presentation/d/1IomxbMKYC5QDsEYm5HDNWNBux9QSzJ6N/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Using Aggregate Functions in SQL

 

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

 

Implementing Relational Schemas in MySQL

 

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

Overview of Distributed Databases

 

https://share.google/3rKjJie5UzUbP43Kz

 

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

 

material:

 

https://docs.google.com/presentation/d/1ahp5JdPO86tEJrZfMyr4Hz4erLpH5-y_/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

Overview of Distributed Databases

https://share.google/3rKjJie5UzUbP43Kz

 

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

 

material:

 

https://docs.google.com/presentation/d/1ahp5JdPO86tEJrZfMyr4Hz4erLpH5-y_/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

Setting Up a Distributed Database Environment

 

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

Implementing Data Fragmentation

 

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

 

Distributed Database Architectures

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

 

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

 

 

material:

 

https://docs.google.com/presentation/d/1ahp5JdPO86tEJrZfMyr4Hz4erLpH5-y_/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

Data Fragmentation, Replication, and Allocation

https://share.google/F36upemFpuDhkDgvV

 

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

 

material:

 

https://docs.google.com/presentation/d/1jmW2q9KzO0M67eUaueQLgvO2oLkSB2LJ/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Connecting and Querying Distributed Databases

 

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

 

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

Ensuring Data Consistency in a Distributed Environment

 

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

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

 

material:

 

https://docs.google.com/presentation/d/1UgF1MneL8Yah8e8LuvjEP2lFTCIR9FEs/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

 

 

 

 

 

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

 

material:

 

https://docs.google.com/presentation/d/1UgF1MneL8Yah8e8LuvjEP2lFTCIR9FEs/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Implementing Distributed Transactions

 

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

 

 

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

 

Implementing Distributed Transactions

 

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

 

 

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

Two-Phase Commit Protocol

 

https://share.google/NOAdWPfMpjM2KTOUf

 

 

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

 

material:

 

https://docs.google.com/presentation/d/1SagboBOZDqXFscHucPTzRv4Oxal6ymZ0/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

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

 

material:

 

https://docs.google.com/presentation/d/1dT-x6gifkbhIP2ozSxrNbyAP9yu7ezt5/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

 

Applying the Two-Phase Commit Protocol

 

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

Handling Failures in Distributed Transactions

 

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

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

 

material:

 

https://docs.google.com/presentation/d/1wEB3nQseu_vAsaxpl_age2_pNXoGkWX4/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

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

 

material:

 

https://docs.google.com/presentation/d/1H5PAdO1-NAaRa0GURnaD8MSV0YFBw02C/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

Analyzing Database Performance Metrics

 

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

Implementing Indexes for Performance Optimization

 

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

 

 

 

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

 

material:

 

https://docs.google.com/presentation/d/1bm0Fp3qhTvVSkWf9OvepZXcqoa31n1ly/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

Database Tuning Techniques

 

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

 

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

 

material:

 

https://docs.google.com/presentation/d/1bm0Fp3qhTvVSkWf9OvepZXcqoa31n1ly/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

Performing Database Tuning

 

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

Monitoring and Troubleshooting Database Performance

 

 

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

NoSQL Databases: Concepts and Applications

 

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

 

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

 

material:

 

https://docs.google.com/presentation/d/1w4yL3OmHMS4WY38-vlZmURsiGGxHN9Z7/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

 

 

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

 

material:

 

https://docs.google.com/presentation/d/1bm0Fp3qhTvVSkWf9OvepZXcqoa31n1ly/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

 

 

 

Distributed Query Processing

 

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

 

 

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

 

Distributed Query Processing

 

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

 

 

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

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

 

material:

 

https://docs.google.com/presentation/d/16cpl-3WZTI_YAtCNAra2nI3W_pJzy7iG/edit?usp=sharing&ouid=112330153353330209796&rtpof=true&sd=true

 

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

 

material:

 

https://docs.google.com/presentation/d/1HUjKlA2sGU2cPxYSWeSSVaJHCSvFPvwX/edit?usp=drive_link&ouid=112330153353330209796&rtpof=true&sd=true

 

Handling Failures in Distributed Transactions

 

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

Handling Failures in Distributed Transactions

 

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

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