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
INSER
...
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.
LAB 5 – CREATE A NEW MODEL (SCHEMA) Physical Schema rename to pizzaorderingdb
This study source was downloaded by 100000831988016 from CourseHero.com on 05-20-2022 04:22:35 GMT -05:00
https://www.coursehero.com/file/49630109/Database-Management-Applications-Labsdocx/You are required to take the following steps to accomplish the task:
1. Click File > New Model. A model can contain multiple schemata. Note that when you create
a new model, it contains the mydb schema by default.
2. On the Physical Schemas toolbar, click the Add button to add a new schema.
3. In the tabsheet, change the name of the schema to pizzaorderingdb. Ensure that this
change is reflected on the Physical Schemata tab.
LAB 6 – CREATE AN ER DIAGRAM
You are required to take the following steps to accomplish the task:
1. Go to the File menu.
2. Select the Open Model option.
3. Choose model and click the Open button.
4. Go to the Model menu.
5. Select the Create Diagram from Catalog Objects option.
6. Select 1:n Non-Identifying relationship .
7. Select the PizzaOrder table and then select the Customer table to add a foreign key
between them.
8. Select 1:n Non-Identifying relationship .
9. Select the PizzaOrder table and then select the Pizza table to add a foreign key between
them.
LAB 7 – CREATE TABLES IN MYSQL WORKBENCH ENVIRONMENT
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 TABLE Pizza (
PizzaID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
PizzaName VARCHAR(50) NOT NULL,
This study source was downloaded by 100000831988016 from CourseHero.com on 05-20-2022 04:22:35 GMT -05:00
https://www.coursehero.com/file/49630109/Database-Management-Applications-Labsdocx/PizzaDescription VARCHAR(250) NOT NULL,
PizzaSize VARCHAR(10) NOT NULL,
PizzaPrice DECIMAL(8,2) NOT NULL,
PizzaPhotoID VARCHAR(200) NOT NULL
);
7. Click the Execute button on the top of the SQL Editor window to execute the query.
LAB 8 – DISPLAY TABLE STRUCTURE IN MYSQL WORKBENCH ENVIRONMENT
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:
Describe Customer;
Describe Pizza;
Describe CustomerPizzaOrder;
7. Click the Execute button on the top of the SQL Editor window to execute the query.
Note: In this lab simulation, you need to execute all the queries simultaneously instead of executing
them individually.
LAB 9 – INSERT DATA INTO A TABLE IN MYSQL WORKBENCH ENVIRONMENT
The following steps will allow you to connect to your database remotely to write and execute a query
to accomplish the above mentioned 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:
This study source was downloaded by 100000831988016 from CourseHero.com on 05-20-2022 04:22:35 GMT -05:00
https://www.coursehero.com/file/49630109/Database-Management-Applications-Labsdocx/INSERT INTO Customer (LastName, FirstName, Street, Apt, City, State,
Zip, HomePhone, MobilePhone, OtherPhone)
VALUES ('Pitt', 'Brad', '1 Paris Lane', NULL, 'Hollywood', 'CA',
'11111', '111-111-1111', '111-111-1112', '111-111-1113');
INSERT INTO Pizza (PizzaName, PizzaDescription, PizzaSize, PizzaPrice,
PizzaPhotoID)
VALUES ('Meat Lovers','Pizza with three meats: pepperoni, sausage, and
bacon.','Small',8.00,'www.pizzaphotos.com/pizza1S.jpg');
INSERT INTO CustomerPizzaOrder (CustomerI
[Show More]
