DATABASE MANAGEMENT APPLICATION LABS

DATABASE MANAGEMENT APPLICATION 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
Y OU 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. T HIS 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’

Y OU 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 P IZZAORDERING DB;


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 S CHEMA RENAME TO PIZZAORDERINGDB




This study source was downloaded by 100000833345068 from CourseHero.com on 10 -08-2021 16:34:58 GMT -05:00


https://www.coursehero.com/file/49630109/Database-Management-Applications-Labsdocx/

, Y OU 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

Y OU 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-I DENTIFYING RELATIONSHIP .
7. SELECT THE PIZZAORDER TABLE AND THEN SELECT THE CUSTOMER TABLE TO
ADD A FOREIGN KEY BETWEEN THEM .

8. SELECT 1: N NON-I DENTIFYING 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

Y OU 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 100000833345068 from CourseHero.com on 10 -08-2021 16:34:58 GMT -05:00


https://www.coursehero.com/file/49630109/Database-Management-Applications-Labsdocx/