Summary WGU C170 DATABASE MANAGEMENT APPLICATIONS LABS

WGU C170


WGU C170 DATABASE MANAGEMENT APPLICATIONS
LABS
• Normalizing a dataset
• Creating an E-R Diagram
• Writing CREATE TABLE statements - establishing primary and foreign keys
• Establishing relationships between entities with the FOREIGN KEY REFERENCE statement
• INSERTING data into tables (including multi-row INSERT statements)
• Using the CONCAT function
• Using aliases for table names


LAB 3 - CREATE MYSQL CONNECTION
You are required to take the following steps to accomplish the task:



1. On the MySQL Workbench Home window, click the [+] icon next to MySQL Connections.This opens the
Setup New Connection wizard.
2. Define the Connection Name value as MyFirstConnection.
3. Ensure that Connection Method is set as Standard (TCP/IP).
4. Click the OK button to create the new MySQL connection.

LAB 4 - CREATE DB ‘NAME’

You are required to take the following steps to accomplish the task:



1. Go to the Database menu.
2. Select Connect to Database.
3. Ensure that Stored Connection is set as Myconnection.
4. Ensure that Connection Method is set as Standard (TCP/IP).
5. Click the OK button.
6. Write the following query on the SQL Editor window:




CREATE DATABASE PizzaOrderingDB;


7. Click the Execute button on the top of the SQL Editor window to execute the query.

, WGU C170

LAB 5 – CREATE A NEW MODEL (SCHEMA) Physical Schema rename to pizzaorderingdb