Title: Week 5
Course: Introduction to Database Management Systems

The Relational Model

The topic aims to introduce the relational model, an approach for managing data by making use of a structure and language coherent with the first-order predicate logic, such that all data is represented in terms of tuples, grouped into relations or tables. You will also get exposed to integrity rules and constraints as critical aspects in relational models.

Learning Outcomes

At the end of the week, you will be able to:
1. Discuss the types of integrity constraints
2. Describe views and their importance in a database environment
3. Discuss the key characteristics of relational algebra and relational calculus

Over to you
This week is cumulative of what you have learnt from week 1 - 5. This week you will focus on only one activity, but you will also need to read through your notes as you will have a quiz that will cover all the topics.

Pre-Topic
A review of the entity-relationship model is to be conducted. Based on the readings from week 4, attempt the practical exercises after chapter 8.
Fill in the Survey found under the assessments to find out how you are doing in the course and ways of improving. The review for both activities will be done during face-to-face activity.

Due date Tuesday 23:59
Estimated study time: 2 hours

FACE-TO-FACE

- Review of the practical exercises from the pre-topic activity.
- Review of results from the online survey.
- Think, pair, share the weeks’ concepts.

E-TIVITIES

E-tivity 5.1 (Mandatory)

This week is the culmination of the introduction to databases. This week features a quiz and before attempting the quiz you are required to perform the following tasks:
1. First, review the e-tivities from week 1 -4 and pick lessons learnt, new concepts and keywords and fill this into the Annotated Template provided.
2. The second task is to review chapter 7 - 9 from the Database Design core textbook and make short summary notes.
3. The third task is to compare the notes from chapter 2 - 5 from the Relational Database Systems book and update your summarized notes.
4. Based on the readings from this week, pick up the annotated template you filled from task one and update it with the week 5 concepts and keywords.

Due date Saturday 23:59
Estimated study time: 5 hours

E-tivity 5.2 (Mandatory)

Once you have completed e-tivity 5.1 you are required to use the knowledge you have acquired to attempt e-tivity 5.2. The e-tivity is a quiz that will be used to assess your understanding of the week 1-5 topics: Introduction to databases, the database environment, database analysis and design, entity-relational modelling, and the relational model.
The quiz will be purely multiple choice and will be automatically marked with feedback provided upon submission. You are required to individually attempt the quiz.

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

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

ASSESSMENT