4:15 LTE X CST 235-002 Lab5.docx Instructions: DEWIDE 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 Banner ID as database name. 2. Based on the Entity Relationship Diagram (ERD) in Figure 1. Create all the tables in the ERD with your BannerID as prefix for each table. For example, if your BannerID is "950123456", then the table name for table Lecturer should be "950123456_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 CourseName EnrolmentID StdID CourseID CourseID Lecturer M . Enrolment Has Course M SudEmail Enrols in Teaches IntakeYear (Lct Name (StdName Students Lecturer LctID StdID Course Management System