Title: Week 10
Course: Introduction to Database Management Systems

Introduction to Data Manipulation Language (DML)

The topic aims at introducing you to concepts behind writing and execution of Data Manipulation Language (DML) SQL statements. The key focus is to introduce mechanisms on how to deal with data related statements that could allow for insertion, update, selection and deletion of data in database tables.

Learning Outcomes

At the end of the week, you will be able to:
1. Describe the syntax of the insert, update, select and delete statement.
2. Write and execute basic data manipulation language queries

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 DDL is to be conducted. During week 7 you attempted the questions from chapter 15 on the relational model. This week, we focus on the same chapter on the DDL questions. Based on the readings from week 7 and 8 you, attempt the practical exercises after chapter 15 on DDL. The review will be done during face-to-face activity.

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

FACE-TO-FACE

- Review of the pre-topic activity Highlight concepts related to DML.
- Group discussion on a Mini Case study inline with DML

Task
In reference to the tables created in week 8 and with modifications done on them in week 9, insert at least two records in each of the tables, display/retrieve the inserted records, update any of the records, delete any of the records.

E-TIVITIES

E-tivity 10.1 (Mandatory)

The purpose of this e-tivity is to lay a foundation to Data Manipulation Language statements. For this e-tivity, you will be required to perform the tasks listed below based on the running case. You will as an individual insert, select (display), update and delete records in a database.

Task 1

Keeping in mind e-tivities 8.1 and 9.1 from the previous weeks and the background of the running case that created a database and its objects, you are expected to read chapter 16 of Database Design course textbook on SQL Data Manipulation Language and chapter 9 of Relational Database Concepts course textbook on The SQL Data Manipulation Language (DML). Additionally, watch the video on Data Manipulation Language (DML) provided in the learning resources.

Capture key points discovered from the learning resources based on what you understood and gained from the readings and the video.

Task 2

Based on Task 1 activities and on the Running Case, write and execute SQL statements to perform the following activities in that order:

1. Insert at least 10 records in each of the tables.
2. Display all records in each of the tables.
3. Modify any of the records in each table.
4. Display all records in each of the tables.
5. Remove one record from each of the tables.
6. Display all records in each of the tables.

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