Back close

Course Detail

Course Name Introduction to DBMS
Course Code 24AIM305
Program B.Tech. in Artificial Intelligence (AI) and Data Science (Medical Engineering)
Semester V - Micro-credential courses: Set 4
Credits 3
Campus Coimbatore

Syllabus

Unit 1: Introduction : History of database systems – Purpose of Database systems – File Systems Vs Database systems –Database architecture – Different Data models of Database. Relational Data Model: Structure of relational databases– Database schema – Formal Relational Query Languages. Database Design: Overview of the design process – The E-R Models – Constraints – Removing Redundant Attributes in Entity Sets – E-R Diagrams – Reduction to Relational Schemas.

Unit 2: Relational Database Design: Different Normal forms: 1NF, 2NF, 3NF, BCNF and Higher Normal Forms, Decomposition using Functional Dependencies – Functional Dependency Theory – Multi-valued dependency – SQL: Introduction to SQL – Intermediate SQL.

Unit 3: Transactions: Transaction concept – A simple transaction model – Transaction atomicity and durability – Serializability – Recoverable schedules, Casecadeless schedules. Concurrency control: Lock-based protocols – Locks, granting of locks, The two-phase locking protocol, Graph-based protocols. Deadlock handling: Deadlock prevention, Deadlock detection and recovery.

Course Objectives and Outcomes

Course Objectives:

  • This course aims to provide an understanding of the concepts of database design, database languages, database-system implementation and maintenance
  • The course would afford know-how on the design and development of databases using SQL
  • To introduce various database systems including modern databases systems apt for AI and ML applications.

Course Outcomes:
After completing this course, students should be able to
CO1: Demonstrate an understanding of relational data models, schema structures, and formal query languages for effective database design and implementation.
CO2: Apply normalization forms and decomposition techniques.
CO3: Implement transaction concepts and concurrency control mechanisms, including lock-based protocols and deadlock handling.
CO4: Apply knowledge of modern database systems, using SQL and Python to design databases suitable for modern applications.

CO-PO Mapping

CO/PO

PO1

PO2

PO3

PO4

PO5

PO6

PO7

PO8

PO9

PO10

PO11

PO12

PSO1

PSO2

PSO3

CO1

3

2

2

2

2

1

2

1

CO2

3

2

2

2

2

1

2

1

CO3

3

2

2

2

2

1

2

1

CO4

3

2

2

2

2

1

2

1

Textbooks / References

  1. Silberschatz A, Korth H F, SudharshanS. Database System Concepts, Sixth Edition, TMH publishing company limited;2011.
  2. Garcia-Molina H, Ullman JD, Widom J. Database System; The complete book. Second Edition, Pearson Education India, 2011.
  3. Elmasri R, Navathe SB. Fundamentals of Database Systems. Fifth Edition, Addison Wesley.

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now