Title: Week 11
Course: Introduction to Database Management Systems

DML (WHERE clause, Sorting, Grouping & Functions)

The topic aims to expound on week 10’s introduction to DML by focusing on a broad view of the WHERE clause for selecting and filtering data from the database. It further explores how to sort and group data using the select statement.

Learning Outcomes

At the end of the week, you will be able to:
1. Write and execute data manipulation statements with the WHERE clause.
2. Perform sorting and grouping of results using the select statement.
3. Write and execute queries using SQL functions.

Over to you
After an introduction to DML during the previous week, you will now practice some activities with DML statements.

Pre-Topic
For you to be able to undertake the face-to-face activities, it is prudent for you to review the lessons learnt from week 10. Catch up on any e-tivities you may have missed.

Due date Tuesday 23:59

FACE-TO-FACE

- Review of concepts related to DML from week 10 and 11.
- Highlight concepts related to DML.
- Work on a group discussion on a Mini Case study inline with DML

Task
In reference to records inserted in tables in week 10, demonstrate the use of WHERE clause, Sorting, Grouping and Functions on the data as guided by the instructor

E-TIVITIES

E-tivity 11.1 (Mandatory)

This week, we will be focusing on the WHERE clause, sorting, grouping and functions for data filtering. You will be required as an individual to perform the tasks listed below. Keep in mind the review from week 10.

- Read chapter 16 of the Database Design course textbook on SQL Data Manipulation Language and capture important concepts regarding DML.
- After you finish the first task, review chapter 9 of the Relational Database Systems course textbook on The SQL Data Manipulation Language (DML). Update the concepts from the first task.
- Watch the video on Data Manipulation Language (DML) provided in the learning resources and capture any other additional concepts you deem worthy that were not captured in the first and second task.
- After completing the first three tasks, attempt the Running Case tasks below:

1. Write and execute statements to display all records in each table.

Capture the SQL statements executed plus the screenshots of the outcome in an MS-Word document for submission.

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

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

ASSESSMENT