Question: banner 950377236 CST 235 LAB 5: Manipulating Database Table Structure using SQL Instructions: 29oto CourseName EnrolmentID SudID) CourseIDO CourseID Enrolment Course SudEmail Enrols in Teaches

banner 950377236

CST 235 LAB 5: Manipulating Database Table Structure using SQL

Instructions: 29oto CourseName EnrolmentID SudID) CourseIDO CourseID Enrolment Course SudEmail Enrols in Teaches > IntakeYear (LeoName SedName Students Lecturer SEID 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 BannerID 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

307116527 bLab Instructions: You should we X C Solved Lab Instructions You ShX mn-us-east-1-prod-fleetO2-xythos.content.blackboardcdn.com/5deff73789169/71165277X-Blackboard-Expirat + t Pageview | A...

CST 235 Lab 3 Lab Instructions: You should work individual for this assignment Create a new SQL script file using Notepad or Notepad++) and save it as Lab3xxxx.sql (where xxxx is your last name...

Lab 5 Assignment - Basic SQL Query Task 1 ( Customer Information ) : Retrieve all customers' ID , name, and phone ( s ) and display the results as the following output. Note that the results are...

Lab Instructions: Name: YourNameGoesHere Class: CST 2 3 5 Date: I have not received or given help on this assignment: YourName DROP DATABASE IF EXISTS Lab 3 YourLastName; CREATE DATABASE Lab 3...

Pretend that today is January 1st 2014 and that the fiscal year end for the company is December 31st 2014 Assume that we will sell the stock after two years at the end of 2015). Please use the...

This is an excel assignment in finance course. I will attach the assignment. Thank you FIN 301 SPREADSHEET ASSIGNMENT In this assignment you will practice using several Excel functions for managing...

Review the chapter text about benchmarking. Examine Table 18-1, which illustrates a variety of different benchmarking measures. Required Select either the MHS case study in Chapter 25 or one of the...

Prblem 7-4 Mery 1, 2017,Ivad C y he fwg pperts piart, ene equpert acnts Amted 200 Acmeddcatn t 350, 700000 150 2,150,000 bdings toe Land The comoeny us streight ne deprecition fer buildings and...

banner 950377236 CST 235 LAB 5: Manipulating Database Table Structure using SQL Instructions: 29oto CourseName EnrolmentID SudID) CourseIDO CourseID Enrolment Course SudEmail Enrols in Teaches >...

Bill Novak is working on an audit of a U.S. GAAP client. In his review of the clients interim reports, he notes that the reports are prepared on an integral basis. That is, each interim report is...

A vertical cylinder is fitted with a frictionless piston that is initially resting on stops. The cylinder contains carbon dioxide gas at 200 kPa, 300 K, and at this point the volume is 50 L. A...

Determine taxable income in each of the following independent cases. In atl cases, the company was formed in 2 0 1 2 , was very profitable in all prior years, and had retained earnings of \ ( \ $ 3 ;...

Your client, Hoosier Corporation, is owned by two shareholders: Amy and Max. At year-end 2019, the company accountant determined Amy was due a bonus payment for performance in the amount of $50,000....

Family- friendly benefi ts may be attractive to staff but have disadvantages to employers. Select three of the benefi ts detailed in this chapter, list the disadvantages that may accompany...

here) and other areas you consider relevant.

Using the example of the testing for pub landlords in case study 3.2, draw up a list of specialist positions where the use of tests may produce some interesting personality profi les.