Title: Week 7
Course: Introduction to Database Management Systems

Introduction to SQL

The topic aims to introduce you to the Structured Query Language (SQL) as a database language. SQL is one of the most famous languages of the database applicable to relational databases. The topic will expose you to write and execute SQL statements, together with the ISO SQL data types.

Learning Outcomes

At the end of the week, you will be able to:
1. Differentiate between data definition language and data manipulation language
2. Describe rules relating to writing SQL queries
3. List and discuss the various ISO SQL data types

Over to you
This section involves you looking through the learning resources and summarizing the chapters provided. Thereafter, you will work on the e-tivities to demonstrate whether you understood and internalized the content.

Pre-Topic
A review of the entity-relationship model is to be conducted. Based on the readings from week 6, attempt the practical exercises after chapter 10 and 12. 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
- Review of expectations of e-tivity 7.1 and 7.2
- Think, pair, share the concepts covered in the recorded lecture.

E-TIVITIES

E-tivity 7.1 (Mandatory)

This e-tivity works to introduce the concepts of the SQL language. Based on the topic you are required to perform the following tasks:
1. The first task is reading through chapter 15 of the Database Design course textbook. As you read the chapter, focus on the SQL concepts, and make short notes.
2. The second task is to improve the short notes that you created on the first task by reading chapter 7 and 8 of the Relational Database Systems book. These readings will aid in working on the discussion forum question.
3. The third task involves watching the video and highlighting points missed during the first and second summary.
4. You have been assigned to a group of 5 members within the system. You will be required to engage your peers on the discussion question below:
  - A student from a background other than Computing is has started learning SQL. Based on your readings from this week, what would you advise them to focus on so that they have a better understanding before they start coding?
  - When engaging with your peers, point out areas they may have left out or areas they included that you had not thought of. Ensure that you have enhanced your summary.

Post due date Thursday 23:59
Peer Review due date Saturday 23:59
Estimated study time: 4 hours

E-tivity 7.2 (Mandatory)

Once you have posted and engaged with your peers on the discussion forum, you will be required to attempt the progression quiz. This quiz is aimed at checking whether you have understood the concepts from the week. You will be unable to proceed to week 8 until you pass all the questions in the quiz.

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

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

ASSESSMENT