WEEK 2: COMPONENTS OF DATABASE SYSTEMS, DBMS FUNCTIONS AND ARCHITECTURE
Section outline
-
-
Teaching and Learning Methods to be Employed
1. Illustrated lecture on DBMS architecture with layered diagrams
2. Lab session: Navigating MySQL Workbench schemas, tables, users
3. Demonstration: Data independence in practice
Learning Outcomes / Objectives
By the end of this week, students should be able to:
1. Identify and describe the components of a database system.
2. Explain the functions of a DBMS.
3. Describe the three-schema (ANSI/SPARC) architecture.
4. Distinguish between physical and logical data independence.
5. Explain the roles of DBA, database designer, and end-users.
-
Course Discussion ForumDue: Thursday, 11 June 2026, 6:22 PM
-