This course is part of the B.E. Computer Science Engineering curriculum under Anna University Regulation 2021. The knowledge from this course continues to be actively applied in professional software development.
Semester 4 (Second Year)
3 Credits
45 Lecture Hours
Course Overview
UniversityAnna University
Regulation2021
Semester4
Credits3
TypeCore
Units5
Course Objectives
1
To learn fundamentals of data models, relational algebra, and SQL
2
To represent database systems using ER diagrams and normalization
3
To understand transaction, concurrency, and recovery processing
4
To learn internal storage structures using indexing techniques
5
To gain knowledge of Distributed databases and NOSQL
Syllabus
Detailed unit-wise breakdown of the course curriculum as per Anna University Regulation 2021.
1
RELATIONAL DATABASES
9 Hours
Purpose of database systemsViews of dataData modelsDatabase system architectureRelational modelKeysRelational algebraSQL fundamentalsAdvanced SQL featuresEmbedded SQLDynamic SQL
2
DATABASE DESIGN
9 Hours
Entity-Relationship modelE-R DiagramsEnhanced-ER ModelER-to-Relational MappingFunctional DependenciesNon-loss DecompositionFirst, Second, Third Normal FormsDependency PreservationBoyce/Codd Normal FormMulti-valued Dependencies and 4NFJoin Dependencies and 5NF
3
TRANSACTIONS
9 Hours
Transaction ConceptsACID PropertiesSchedules and SerializabilityTransaction support in SQLConcurrency control – Two Phase LockingTimestamp and Multiversion methodsValidation and Snapshot isolationMultiple Granularity lockingDeadlock HandlingRecovery ConceptsARIES Algorithm
4
IMPLEMENTATION TECHNIQUES
9 Hours
RAIDFile OrganizationOrganization of Records in FilesData dictionary StorageColumn Oriented StorageOrdered IndicesB+ tree Index FilesB tree Index FilesStatic and Dynamic HashingQuery Processing OverviewQuery optimization
5
ADVANCED TOPICS
9 Hours
Distributed Databases – ArchitectureData Storage and Transaction ProcessingQuery processing and optimizationNOSQL Databases – CAP TheoremDocument Based systemsKey-value StoresColumn Based SystemsGraph DatabasesDatabase Security – Access controlSQL InjectionEncryption and Public Key infrastructures
Course Outcomes
Upon completion of this course, students will be able to:
CO1
Apply relational algebra and SQL for database operations
CO2
Design databases using ER models and normalization
CO3
Implement transaction processing with concurrency control
CO4
Use indexing techniques for database optimization
CO5
Understand distributed and NOSQL database concepts
Industry Application & Relevance
How the concepts learned in this course are applied in real-world software development projects across Banking, Healthcare, and Enterprise domains over 20+ years of experience.
Professional Application
Oracle, MySQL, PostgreSQL - daily use in all projects
Textbooks & References
Textbooks
Abraham Silberschatz et al., 'Database System Concepts', McGraw Hill
Ramez Elmasri, Shamkant Navathe, 'Fundamentals of Database Systems', Pearson
Reference Books
Raghu Ramakrishnan, Johannes Gehrke, 'Database Management Systems', McGraw Hill
C.J. Date, 'An Introduction to Database Systems', Pearson
Related Courses from Semester 4
Other courses from the same semester that are actively used in professional work.