Title: Week 2
Course: Introduction to Database Management Systems

The Database Environment

The week brings to light the database system environment. You will be introduced to the layered database system architecture, the language of databases, data models and conceptual modelling. The topic will further explore the DBMS components and function

Learning Outcomes

At the end of the week, you will be able to:
1. Describe the layered database system architecture
2. List and describe database languages and data models
3. Describe the various components and functions of a DBMS

Over to you
This week we continue to build the knowledge we acquired during the first week. We will again review the week's notes and then work toward summarizing the notes and thereafter work on the discussion forum together with your colleagues.

Pre-Topic
A review of an introduction to databases is to be conducted. Based on the readings from Database Design, attempt the three exercises after chapter 1, 2 and 3. The review will be done during the face to face activity.

Due date Tuesday 23:59
Estimated study time: 1 hour

FACE-TO-FACE

- Review of the pre-topic activity Highlights of the presentations from e-tivity 1.2 (if any)
- Question and Answer session based on the weeks’ notes.
- Think, pair, share the weeks’ concepts.

E-TIVITIES

E-tivity 2.1

The purpose of this e-tivity is to help you to understand the database system architecture, data models and conceptual modelling.

Task 1
You are required to read chapter 4 to 6 of the Database Design core textbook covering Types of Data Models, Data Modelling and Classification of Database Management Systems. Additionally, read chapter 4 of the Relational Database Concepts textbook covering ANSI/SPARC 3 Schema Architecture. You may also want to spare some time to watch the brief video in the introduction to DBMS provided.

Be sure to notate the following aspects as you read through the resources:
- Characteristics of the layered database system architecture
- Key aspects of database languages and data models
- Functions and components of a DBMS

Note that, for ease of notation, you may want to print the reading section then use a highlighter to notate the key aspects.

Task 2
Based on the reading and annotation you made in the previous task, you are required to attempt the progression quiz to gauge your understanding of the topic. You will only be allowed to proceed to the next section upon completion

Due date Friday 23:59
Estimated study time: 4 hours

Keep a copy of your work in your e-portfolio folder

ASSESSMENT