EIT 221 – Database Management Systems (DBMS)
Year II · Semester II · 3 Credits · Core
About this course
Almost every system we use today, such as banking, online shopping and university portals, runs on a database. This course introduces how databases work, how to design them properly, and how to store, retrieve and manage data using SQL. No previous database experience is needed. We start from the basics and build up step by step.
What you will learn
- Core ideas of databases and DBMS, and why they replaced file-based systems
- Designing databases with Entity-Relationship (ER) diagrams
- The relational model and normalisation (1NF, 2NF, 3NF)
- Writing SQL queries, from basic to advanced (joins, sub-queries, views, functions)
- Stored procedures, cursors and triggers
- How a DBMS processes and optimises queries
- Transactions, concurrency control and system recovery
- Database security, distributed databases, data mining and data warehousing
How the course runs
- 15 weeks, 3 hours per week (theory and practical sessions)
- Learning through lectures, group work, discussions, presentations, videos and case studies
- Practical work uses free tools: draw.io for diagrams and MySQL for SQL
Assessment
- Continuous assessment: 40% (four theory assignments and one practical assignment)
- Final examination: 60%
Recommended reading
- Silberschatz, A., Korth, H. F. & Sudarshan, S. Database System Concepts. McGraw-Hill.
- Elmasri, R. & Navathe, S. B. Fundamentals of Database Systems. Pearson.
- Ramakrishnan, R. & Gehrke, J. Database Management Systems. McGraw-Hill.
- Pakhira, M. K. Database Management System. Prentice Hall of India.
Prerequisites: EITC-1 and EITC-2 are recommended.
- Teacher: V.P.G Priyankara
- Teacher: Admin User