Title: Week 8
Course: Introduction to Database Management Systems

Database Definition Language (Syntax and Creation of Database Objects)

The topic aims to build you to be knowledgeable on the creation of databases and their objects. It will introduce Database Definition Language that is designed purely for defining structural parts of a database without touching on the data.

Learning Outcomes

At the end of the week, you will be able to:
1. Comprehend the syntax for the creation of database objects
2. Create databases, tables and views

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 7, attempt the practical exercises after chapter 15 on SQL. Ignore the DDL questions. The review of the same will be done during the face-to-face session.

Furthermore, prepare your environment for practical activities by downloading and installing either the Developer or Express versions of the MS-SQL Server DBMS. Ensure that the installation completes successfully and that you can start the SQL Server Management Studio (SSMS), connect to the database engine and open the query the browser in readiness for writing and execution of SQL command as shown in the video.

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

FACE-TO-FACE

- Review of the pre-topic activity
- Highlight concepts related to Data Definition Languages (DDL).
- Group discussion on a Mini Case study in line with the creation of databases and their objects.

Task
In reference to the 3NF for the mini case that was generated in week 6, create the database and its tables.

E-TIVITIES

E-tivity 8.1 (Mandatory)

The purpose of this e-tivity is to comprehend writing and executing DDL statements for creating databases and their objects. You are required to perform the tasks listed below based on the running case and in reference with the database and its tables as determined in e-tivity 6.1.

Task 1
Go through chapter 15 of the Database Design course textbook on Structured Query Language with a focus on DDL and chapter 12 of Relational Database Systems - Why and How course textbook on The SQL Data Definition Language (DDL). You may also search for a YouTube video of writing and executing SQL statement.
As you go through the materials, notate key points and make summary notes of the same. The notation and summary should be based on a reflection of what you have understood and gained from the readings and the video.

Task 2
Bearing in mind the readings and any YouTube videos you managed to watch, attempt the following based on Running Case tasks below:
- Create a database called “TenderStore”.
- Create tables as determined by the 3NF for e-tivity 6.1.
- Be sure to enforce relationships as determined by the key fields.

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