Lab 2 : Manipulating Database Table Structure using SQL

Objectives:

• Create table based on ERD.
• Alter a table column.
• Delete a Table from a Database.

Instructions:

Figure 1: ERD Course Management System

• Go follow the instructions and walk through from the links in the objectives. After that complete the exercise below:

1. Create a database using MySQL/MariaDB console with your Matric No as database name.
2. Based on the Entity Relationship Diagram (ERD) in Figure 1. Create all the tables in the ERD with your Matric No as prefix for each table. For example, if your Matric no is "123456", then the table name for table Lecturer should be "123456_Lecturer".
3. Add a column called "Department" with datatype "VARCHAR(12)" to the table "Lecturer". Shows the metadata of the updated "Lecturer" table.
4. Drop the "Department" column from the table "Lecturer", and show the metadata of the updated "Lecturer" table.

*Use snipping tools (in windows) or screencapture software to print screen the show database result before and after the task. Save the task title and also the screencapture in a Microsoft Document named "lab2-[matric no]".