Welcome to the Database Management Systems (DBMS) course. This course is designed to provide a comprehensive understanding of database systems, their design, implementation, and real-world applications.
- Course Code & Title: CSE-2101: Database Management Systems
- Course Code & Title: CSE-2102: Database Management Systems Lab
- Sunday (2.00pm-3.00pm): CSE-2102
- Wednesday (10.30am-1.30pm): CSE-2101
By the end of this course, students will be able to:
- Understand the fundamental concepts of databases and database management systems.
- Design database schemas using Entity-Relationship (ER) diagrams.
- Write efficient SQL queries for data manipulation and retrieval.
- Understand normalization techniques and functional dependencies.
- Gain insights into advanced topics like transaction management, indexing, and database security.
-
Introduction to Databases
- Data, database, and DBMS concepts
- Advantages of using a DBMS
-
Relational Model
- Relations, tuples, attributes, and schemas
- Relational algebra
-
Entity-Relationship (ER) Modeling
- ER diagrams
- Converting ER diagrams to relational schemas
-
SQL (Structured Query Language)
- DDL, DML, and DQL
- Aggregate functions, subqueries, and joins
-
Functional Dependencies and Normalization
- Decomposition
- First to Fifth Normal Forms
-
Transaction Management
- ACID properties
- Concurrency control
-
Indexing and Query Optimization
-
Database Security and Backup
- "Database System Concepts" by Silberschatz, Korth, and Sudarshan
- "Fundamentals of Database Systems" by Elmasri and Navathe
- MySQL Workbench: For SQL practice and database design
- phpMyAdmin: Web-based database management (Download XAMPP and Install)
- DBeaver: Multi-platform database tool
For queries, please reach out to:
- Instructor: Md Samsuddoha, Assistant Professor, Dept of CSE, BU
- Email: sams.csebu@gmail.com
Happy Learning! 🚀