Title: Week 9
Course: Introduction to Database Management Systems

DDL (Adding fields & Constraints and Deletion of Objects)

The topic aims at expounding on the previous week’s creation of databases and their objects by focusing on advanced concepts on Data Definition Language (DDL). It explores DDL statements for adding fields and constraints to existing tables and deletion of database objects.

Learning Outcomes

At the end of the week, you will be able to:
1. Add and delete fields and constraints to existing tables.
2. Delete databases, tables, and views.

Over to you
We are now getting into the heart of SQL, specifically DDL. You will be doing a review of the reading resources than using the resources to work on face-to-face activity as well as the e-tivity.

Pre-Topic
You should have successfully completed and understood week 8 activities.

Due date Tuesday 23:59

FACE-TO-FACE

- Review of the week 8 e-tivity.
- Highlight concepts related to DDL.
- Group discussion on a Mini Case study in line with DDL

Task
In reference to the tables created in week 8, add at least two fields of your choice to each table. Demonstrate deletion of at least one field from each table. Further, demonstrate how to delete a table and a database.

E-TIVITIES

E-tivity 9.1 (Mandatory)

Having managed to create database objects in week 8, it is now time to move toward executing statements on the objects we created. A focus of the e-tivity will be on adding and removing fields and deleting databases and their objects. The tasks will be performed individually and will be based on the running case. You will modify tables and their constraints and delete databases and tables as designed in e-tivity 8.1. You will perform the following tasks:

- Read chapter 15 of the Database Design course textbook on Structured Query Language with a focus on DDL for adding table fields and constraints and deletion of database objects. Take note of concepts and DDL statements covered.
- Thereafter, review chapter 12 of the Relational Database Systems course textbook with a similar focus on adding table fields and constraints and deletion of database objects. Update the concepts and statements from the first task with any newly discovered statements.
- Based on the concepts and statements you have unearthed from the two books attempt the Running Case tasks below:

1. Add at least two fields of your choice to each of the tables created in e-tivity 8.1.
2. Delete at least one field (not the one just added) from each of the tables created in e-tivity 8.1.
3. Add extra constraints of your choice to any table.

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

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

ASSESSMENT