EXPLAIN shows information about the database: the number of tables; how tables are joined; how data is looked up (full table scan, full index scan or partial index scan); the presence of subqueries, sorts, and unions; DISTINCT and WHERE clauses are used; indexes used and their length (longer index – longer search); number of records examined

Deliverables
Grading of the lab assignment will be based on the following.

Assignment Step	Description	Points
Step 1	EXPLAIN #1 – describe Output of EXPLAIN	6
Step 2	EXPLAIN #2 to have type as partial index scan	6
Step 3	EXPLAIN #3 to have type as index_merge	6
Step 4	EXPLAIN #4 to have type = fulltext	6
Step 5	EXPLAIN #5 to have type as const	6
Step 6	EXPLAIN #6 Sample subquery example	6
Step 7	EXPLAIN #7 – describe Output of EXPLAIN with join	6
Step 8	EXPLAIN #8 – EXPLAIN EXTENDED	6
Step 9	Explain warnings using SHOW WARNINGS	6
Step 10	Explain UPDATE statement	6
Total iLab Points		60 Points

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

Submit your lab session–showing any queries, and other SQL code, and the resulting return from the database–to the Dropbox for the Week 5 iLab.

iLAB STEPS
1) STEP 1: EXPLAIN Output – test EXPLAIN #1
Mysql> EXPLAIN select column from database.tablename where column = value\G
\G – capital letter G places the result set vertically
Explain the meaning and values of result columns (id, table, type, possible_keys, key, key_len, ref, rows, Extra)
Save the screenshot.

2) STEP 2: Modify EXPLAIN in step #1 – test EXPLAIN #2 to have type as partial index scan by including one of the following:
<, <=, >, >=, IS NULL, BETWEEN, IN
Explain output of EXPLAIN. Save the screenshot.

3) STEP 3: Modify EXPLAIN in step #1 – test EXPLAIN #3 to have type as index_merge by including LIKE statement
Explain output of EXPLAIN. Save the screenshot.

4) STEP 4: Modify EXPLAIN #1 – test EXPLAIN #4 to have type = fulltext data access
To write SELECT which causes fulltext data access –select job_category and job_title of the job with title or description which include the word ‘programmer’.
Example:
EXPLAIN select job_category, job_title from bonus where MATCH (job_title, job_description) AGAINST (‘programmer’)\G
Explain output of EXPLAIN. Save the screenshot.

5) STEP 5: Modify EXPLAIN #1 – test EXPLAIN #5 to have type as const by joining/looking up unique index values (index fields compared with =)
Example:
EXPLAIN select hire_date from employee where employee_id = 1234;
Explain output of EXPLAIN. Save the screenshot.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

6) STEP 6: Sample subquery example – test EXPLAIN #6
Write EXPLAIN select statement using subquery.
Example:
EXPLAIN select employee_id, employee_name IN (select job_category from bonus AS bonus_subquery where bon_comm IS NULL) from employee AS outer\G
Explain output of EXPLAIN. Save the screenshot.

7) STEP 7: Turn subquery in #6 to join – test EXPLAIN #7.
Explain output of EXPLAIN. Save the screenshot.

8) STEP 8: To know the approximate number of examined rows to be returned, modify EXPLAIN #1 to EXPLAIN EXTENDED – test EXPLAIN #8
Mysql> EXPLAIN EXTENDED select column from database.tablename where column = value\G
Explain output of EXPLAIN EXTENDED (values of rows and filtered columns)

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

9) STEP 9: Explain warnings received in step #8 by using command:
Mysql>SHOW WARNINGS\G
10) STEP 10: Explain UPDATE statement – test EXPLAIN #9
Example:
Explain update table_name set column_name = value\G
Explain update mis561.employee set table1col = ‘val’\G
Explain output of EXPLAIN. Save the screenshot.

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

MIS561 Lab 4 Using Backups for Complete Recovery

Successful database recovery relies on the database being backed. This is what enables the database to recover data that were lost due to a media failure, loss of power, or any other type of disaster. Each time the online line redoes logs filled up in a log group, the DBMS issues a log switch that will move the log writer process from the current redo log group to the next one in line. The archive background process begins archiving the data in the full online log group files to the archive log files. This is done simultaneously for each log file in the group. If media recovery is needed at the time that the database needs recovery, then the DBMS will search through the archived log files to find the ones that need to be used.

In Part 1, you will use mysqldump command to dump database, expand tables, and restore database.
In Part 2, you will use MySQL Workbench to back up, expand tables, and restore the database.
Note: Be sure that you are making screenshots and save in Lab4 Report.

Deliverables
Grading of the lab assignment will be based on the following.

Assignment Step	Description	Points
Part 1: Take Dump/Backup and restore database using command line
Step 1	Taking a backup of the database	5
Step 2	Expand table	5
Step 3	Restore and recover the database	10
Part 2: Backup and Recovery using MySQL Workbench
Step 1	Taking a backup of the database using Export to Dump Project Folder	5
Step 2	Taking a backup of the database using Export to self-contained file	5
Step 3	Expand table	5
Step 4	Restore database using Import from Dump Project Folder	10
Step 5	Expand table	5
Step 6	Restore database using Import from self-contained file	10
Total iLab Points		60

The Report file should be a single file called yourname_Lab_4.doc to submit to the Dropbox for the Week 4 iLab.
Your report should show any queries, create statements, or other SQL code, along with the resulting return from the database.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

iLAB STEPS
Part 1: Take Dump/Backup and Restore Database Using Command Line
Step 1: Taking a Backup of the Database

Go to MySQL Command line – Unicode and enter password.
There are several databases here now. To list them, type:
Mysql>show databases;
Identify required database;
You have to make database backup to be used later to restore.
Confirm the location of mysqldump utility on your local machine.
Usually, it is:
C:\Program Files\MySQL\MySQL Server5.6\bin
Go to Start – Accessories – Point to Command Prompt and right-click on Run as administrator (to be able to have all types of access on PC).
Set up location using cd command: type in Command prompt:
C:\user username>cd C:\ and press Enter
C:\>cd Program Files and press Enter
C:\\Program Files> cd MySQL and press Enter.
C:\Program Files\MySQL>cd MySQL Server5.6\ and press Enter.
C:\Program Files\MySQL\MySQL Server5.6>cd and press Enter.
Use mysqldump utility.
1. In Command prompt, type:
  Mysqldump –uroot –p databasename > c:\backup file name with extension .sql
  For example: “c:\mis561.sql”
  Where sign > means to take output (from the left part) and put into the input (right part). All SQL instructions will be written to back-up file.
  Note: The location of back-up file has to be enclosed into the double quotes.Example:
  C:\Program Files\MySQL\MySQL Server5.6\bin>Mysqldump –uroot –p databasename >c:\ backup file name with extension .sql
2. Enter password; press Enter;
3. In case of error Could not execute SELECT @@GTID_Mode, re-type with GTID options:
  Mysqldump –uroot –p -set-gtid-purged=OFF databasename > “c:\backup file name with extension .sql”
4. Enter password;
  Please note that c) and d) are needed only in case of error.
  Save screenshot
5. To verify back-up file:
  Start -All programs-Computer-Local Disk (C)-backup file.sql
  Save screenshot
Go to MySQL Command line – Unicode Using DESCRIBE statement show the columns in the table
Mysql>describe databasename.tablename;
Save screenshot

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

Step 2 Expand table

Using ALTER command add 2 columns to the table
Mysql>ALTER table databasename.tablename
ADD col1 varchar(10);
Save screenshot
Using DESCRIBE statement show the columns in the table
Mysql>describe databasename.tablename;
Save screenshot

Step 3 Restore and recover the database

Go to Start- Accessories – Point to Command Prompt and right click on Run as administrator (to be able to have all types of access on PC)
Set up the location: type in Command prompt:
C:\user username>cd C:\ and press Enter
C:\>cd Program Files and press Enter
C:\\Program Files> cd MySQL and press Enter
C:\Program Files\MySQL>cd MySQL Server5.6\ and press Enter
C:\Program Files\MySQL\MySQL Server5.6>cd bin and press Enter
Type:
C:\Program Files\MySQL\MySQL Server5.6\bin>Mysql –uroot –p databasename < “c:\backup file name with extension .sql”
Where sign < means to take output (from the right part) and put into the output (left part). Database will be restored.
Note: The location of backup file has to be enclosed into the double quotes.
Save screenshot
Go to MySQL Command line – Unicode Using DESCRIBE statement show the columns in the table
Mysql>describe databasename.tablename;
Save screenshot

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

Part 2 Backup and Recovery using MySQL Workbench
To Backup database

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

Repeat Step 8, Step 9 and Step 10. Enter password
Now, restore from Import from Self-contained file
1. Choose Import from Self-contained file
2. Select file you want to restore
3. Click on Start Import; enter password;
4. Save screenshot with successful completion
5. Close Administration – Data Import/Restore tab
6. Click icon Create new SQL tab for executing queries (located under the File) to display restored table.
7. Save screenshot

This concludes the Lab for Week 4.

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

MIS561 Lab 3 Users Privileges and Roles

MySQL, like many other databases, uses the combination of specific user definitions, privileges, and roles to control access to the data in the database. In turn, it provides various layers of security. When the database is first created, there are several users created for the purpose of not only installing various components of the database, but also to manage and administer the database functionality. You have already used administrative role users in previous labs. In this lab, you will be creating a series of different users, administering various privileges to those users, and exploring how roles help provide additional functionality to the user picture.

It could be achieved in two ways:

Using command line to access MySQL directly;
Using MySQL Workbench User and Privileges option.

Very important!

Be sure to save all screenshots on Terminal and MySQL Workbench while executing your SQL code when working on the lab.

Deliverables
Grading of the lab assignment will be based on the following.
Part 1: Using Command Line on Terminal

a) Add two new users. Grant super user access to one and read-only access to all tables in the database to the second user (Step 1, Step 2, and Step 3).
To prove the super-user access for User 1, please write query to SELECT, DELETE, INSERT, UPDATE from any created table and show successful results.
To prove the read-only access for User 2, please write query to SELECT, DELETE, INSERT, UPDATE from any created table. SELECT, DELETE, INSERT, UPDATE from any created table (Note: Only SELECT query will be eligible.)
Sample of commands to check access:
Mysql>show databases; – will list database names;
Mysql>use database name; – Access allowed or denied.
Add screenshots to Report.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

b) Modify access of the second user by adding update access to Employee table (Step 4). Add screenshots to Report.
To prove the UPDATE privilege, please log in again as User 2 and update COMM column in Employee table.
MYSQL> UPDATE Employee SET COMM = 0.1;
Add screenshots to Report.

Assignment Step	Description	Points
Step 1	Creating a new user using command line on Terminal	6
Step 2	Finding information on users	6
Step 3	Finding user privileges	6
Step 4	Changing user specifications	6

Part 2: Using MySQL Workbench

Assignment Step	Description	Points
Step 1	Creating a new user using MySQL Workbench	6
Step 2	Finding information on users	6
Step 3	Finding user privileges	6
Step 4	Changing user specifications. Assigning users to a role	6
Step 5	Listing privileges associated with a role	6
Step 6	Verifying role content	6

Your lab session, showing any queries, create statements, or other SQL code, and the resulting return from the database–should be placed in a single file called yourname_Lab_3.txt to submit to the Dropbox for the Week 3 iLab.

Note!
This is a difficult assignment to grade, so please combine multiple outputs in a single document in the order of execution. Addition of headings for each step helps clarity. Also, please trim out any errors and unnecessary content.

iLAB STEPS
Part 1: Using command line on Terminal

STEP 1: Creating a new user using command line on Terminal
To start, launch Start, choose MySQL 5.6 Command Line Client – Unicode
Enter password: Enter your password, which you’ve created during installation; Press Enter;
We’ll check the existing users by:
Mysql> select Host, User from mysql.user;
Your response will look like this:
HOST USER
—————— ———————–
127.0.0.1 root
Localhost student1
Now, to add new user:
Mysql> CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’;
Press Enter.
Please note: Username and password are in a single quotes. Statement is ended with semicolon.
Please add before and after screenshots to the Report.

STEP 2: Finding information on users
To verify currently defined users, write and execute the query to display the following information:
Mysql> select Host, User from mysql.user;
And the result set will include a newly created user.
HOST USER
—————— —————
127.0.0.1 root
Localhost student1
Localhost student2
Please add Before and After screenshots to the Report.

STEP 3: Finding User Privileges
Creating a user doesn’t give any access to databases.
We have to grant the privileges to the user.
For example, command below grants ‘super user’ privileges:
Mysql> GRANT ALL on *.* TO ‘user name’@‘localhost’ WITH GRANT OPTION;
Press Enter.
Where ALL – all privileges;
*.* – to all databases, all tables;
Mysql>flush privileges;
Press Enter.
Mysql>quit
To remove user:
Mysql>DROP USER ‘user name’@’localhost’; Press Enter.
To show all users and their privileges:
Mysql>select * from mysqluser;
Press Enter.
To show privileges:
Mysql>show grants for ‘username’@’localhost’;
The result set will include grants for user and encrypted password.
Please add Before and After screenshots to the Report.

STEP 4: Changing User Specifications
Command below grants user with UPDATE privilege to Employee table:
Mysql> GRANT UPDATE on *.Employee TO ‘user name’@‘localhost’ WITH GRANT OPTION;
Press Enter.
Where
*.Employee – to all databases, Employee table;
Mysql>flush privileges;
Press Enter.
Mysql>quit
To show grants, log in again and type command:
Mysql>show grants for ‘username’@’localhost’;
The result set will include grants for user and encrypted password.
Please add Before and After screenshots to the Report.

Part 2: Using MySQL Workbench
a) Add two new users. Grant ‘super user’ access to one and read-only access to all tables in the database to the second user (Step 1, Step 2, and Step 3).
To prove the super user access for User 1, please write query to SELECT, DELETE, INSERT, UPDATE from any created table and show successful results.
To prove the read-only access for User 2, please write query to SELECT, DELETE, INSERT, UPDATE from any created table. (Note: Only SELECT query will be eligible. DELETE, INSERT, UPDATE will result in an access denied message.)
Add screenshots to Report.
b) Modify access of the second user by adding update access to Employee table (Step 4).
Add screenshots to Report.
To prove the UPDATE privilege, please log in again as User 2 and update COMM column in Employee table.
MYSQL> UPDATE Employee SET COMM = 0.1;

STEP 1: Creating a new user using MySQL Workbench
To start, launch Start, choose MySQL Workbench, Press Enter.
Choose your schema on Home page to connect to MySQL Server.
Enter password; Press OK.
On the left part of the screen, under the Schema, choose your database schema.
Under the Management, click User and Privileges, Enter password to connect to MYSQL Server.
Screen Administration: User and Privileges allows you to add a new user.
Click Add Account button and fill required information in Login screen.
Repeat for the second user.
Please add screenshots to the Report.

STEP 2: Finding information on users.

STEP 3: Finding user privileges.

STEP 4: Listing privileges associated with a role.
Complete Account Limits, Administrative Roles, and Schema Privileges tabs for User 1 and User 2.
Please add screenshots to the Report.

STEP 5: Changing user specifications. Assigning users to a role.
Add UPDATE privilege on Administrative Roles tab for User 2.
Please add screenshots to the Report.

STEP 6: Verifying role content.
Click on Create a new SQL tab for executing query (located on the left corner below the File tab) to start new Query page.
Please prove super user privilege for user 1 by writing and executing SELECT, INSERT, DELETE, UPDATE statements.
To prove the UPDATE privilege for User 2, log in again as User 2 and update COMM column in Employee table.
UPDATE Employee SET COMM = 0.1;
Please add screenshots to the Report.
This concludes the Lab for Week 3.

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

MIS561 Lab 2 Work with Dictionary and Create Relational Database

In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.

MySQL provides two primary types of file management: dictionary-managed files and MySQL Workbench-managed files. As part of this iLab, you will need to supply some information as to how you would use both of these approaches, and you will have to discuss some of the advantages of each.

For Step 3, you need access to your database instance. If you have any difficulties connecting your database instance, let’s take error messages, screen shots, descriptions of the situation to the graded threads and work as a team to resolve issues.
Now you are ready to proceed.

Deliverables
Your assignment will be graded based on the following.
For Steps 1, 2, 3 and 4 create a single Word document and include the answers or solutions to all problems. Be sure to label your document and include your name and course number in the heading. Save your document as “yourname_Lab_2.docx.”

Submit both “yourname_Lab_2.docx” to the Dropbox for this week.

iLAB STEPS
STEP 1: Create Data Dictionary for provided elements

As the DBA for your company, you have decided to install a new version of the MySQL database to replace the current database version being used. The old database has become a constant headache and seems to be causing an overload on the disk drive’s I/O channels. Further analysis has also shown that two primary large tables are the main points of access. The new tables will be DEPT, EMPLOYEE, and BONUS.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

Describe how you plan to compile the Data Dictionary and decide on the table’s structure with the new MySQL database.
Given list of elements:

NN	Attribute Name	Column name	Data Type
1	Employee number	(PK)	EMPNO NUMBER(4)
2	Employee first name	EFNAME	VARCHAR2(10)
3	Employee last name	ELNAME	VARCHAR2(20)
4	Job category	(FK) JOBCATEGORY	VARCHAR2(4)
5	Manager	MGR	NUMBER (4)
6	Hire date	HIREDATE	DATE
7	Salary	SAL	NUMBER (7.2)
8	Commission	COMM	NUMBER (7.2)
9	Department	number(FK) DEPTNO	NUMBER(2)
10	Department name	DEPTNAME	VARCHAR2(14)
11	Location	LOC	VARCHAR2(13)
12	Job title	JOBTITLE	VARCHAR2(20)
13	Job description	JOBDESC	VARCHAR2(20)

Compile Data Dictionary (in alphabetic order):
NN Attribute Name Column name Data Type Data element description Table name Primary key/ Foreign key indicator (P/F) Not NULL Default value
Department number DEPTNO NUMBER(2)
Place and save your answers in a Word document named “yourname_Lab_2.docx.”

STEP 2: Create SCHEMA and database tables in MySQL Workbench
2.a Create SCHEMA

Launch MySQL Workbench;
Click File and choose ‘New Model’;
Add Diagram:
Name: new schema name;
Press ‘Enter’ and new SCHEMA will be added;

2.b Create tables

In Model overview (top part of the screen) Click ‘Add Diagram’; Navigation pane shows new schema in Catalog Tree;
Place a new table on the free part of screen;
Fill:
Table Name:
Column Name, Datatype; PK; NN; UQ;BIN; UN; ZF;AI; Default;
Press ‘Enter’
Continue to add all tables;

2.c Foreign key creation

Click on the bottom of the Form ‘Foreign key’ to establish the reference to parent table;
Choose the Reference table and Reference column;
Choose Foreign key options On Update and On Delete; Enter.

2.d Save database

Choose ‘File’ on the Toolbar and Save Model as on your folder.
Established database are visible on Home page.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

STEP 3: Create and configure a new connection to the MySQL Server
Part 1 Create a new connection to the MySQL Server

Launch to MySQL Workbench Home page;
To add a connection, click the [+] icon to the right of the MySQL Connections title. This opens the Setup New Connection form:
Figure 3.1 Setup New Connection Form
Important note:
The Setup New Connection form features a Configure Server Management button (bottom left) that is required for the MySQL connection to perform tasks that requires shell access to the host. For example, starting/stopping the MySQL instance or editing the configuration file Fill out the connection details and optionally click Configure Server Management to execute the Server Management wizard. Click OK to save the connection.
Important:
All connections opened by MySQL Workbench automatically set the client character set to utf8. Manually changing the client character set, such as using SET NAMES …, may cause MySQL Workbench to not correctly display the characters.
New connections are added to the Home page as a tile, and multiple connections may be opened simultaneously in MySQL Workbench.

Part 2 Configure a New MySQL Connection

Click on ‘Local Instance MySQL’ and enter password;
Local Instance MySQL screen appears;
Click MySQL Workbench Home, click database to be connected;
EER Diagram screen appears;
Choose Database on Toolbar and ‘Forward Engineering’ on scroll menu;
Forward Engineer to Database screen appears
Set parameters for Connecting to a DBMS:
Stored Connection: Select from saved connection settings; Click ‘Next’;
Set Options for Database to be Created appears
Select DROP objects before each CREATE object;
Leave selected Include model attached script; Click ‘Next’;
Select Objects to Forward Engineer screen appears, enter password again;
Select Export MySQL Table Objects and click ‘Next’;
Review the SQL script to be Executed screen appears for your review and saving to file or copy to Clipboard; Click ‘Next’;
Forward Engineering Progress screen appears, enter password again;
Forward Engineering Progress shows the executed tasks.
Click ‘Close’.

Please add Management, INSTANCE and PERFORMANCE screenshots for the created database to lab Report.

STEP 4: Insert data to tables using MySQL Workbench

Copy INSERT statements for the given tables into the notepad;
Launch to MySQL Workbench Home page;
Choose created database instance; enter password;
New screen appears with the Connection name;
Choose in Navigator your schema’s name;
Copy script from Notepad to screen ‘Query 1’;
Highlight executable rows, choose ‘Query’ on the Toolbar and Execute (All or Selection);
Output will display the results of the execution.

Please select counters and rows in database tables and add screenshots to lab Report.

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench

Part 1: Installing MySQL Installer and MySQL Workbench

Choose which distribution to install.
Several versions of MySQL are available, and most are available in several distribution formats. We choose a production (stable) release:
MySQL 5.6: Latest General Availability (Production) release
How to Install, Configure, and Verify a MySQL Workbench on Windows 7.
To start, go to the MySQL Official site: www.mySQL.com
1. Select Downloads tab on the top;
2. Scroll down and under MySQL Community Edition select Community (GPL) Downloads;
3. Choose MySQL on Windows (Installer & Tools) and click ‘DOWNLOAD’
  (Current Generally Available Release 5.6.21 or higher)
  – Select MySQL Installer which provides wizard for installation.
  – Scroll down to select platform:Select Platform: Microsoft Windows
  Windows (x86, 32-bit), MSI Installer, click Download button
4. The Begin Your Download window come up,
5. Bypass Begin Your Download form, on the bottom of the page, choose No thank you, just take me to the downloads,
6. Appears Panel with Do you want to run or save mysql-installer-web-community-5.6.22.msi from cdn.mysql.com? Choose Run.
7. Message Do you want to allow the following program to install software on this computer? Answer Yes.
8. Accept License Agreement, click Next.
9. Window Choosing a Setup Type.
  – Check Full radio button to install all included MySQL products and features; click Next.
10. Window Check Requirements – follow instructions on the window. Click Next.
11. Click Execute to start downloading process. Installer shows the status of installation (upgrade) for each product. Click Next.
12. Product Configuration screen appears and shows products to be installed using Wizard. Click Next.
13. Type and Networking screen appears – Click Next;
14. Accounts & Roles screen – to set up MySQL password. Type password and note it. Click Next.
15. Windows Services screen – choose Standard System account; Click Next.
16. Apply Server configuration screen – click Execute.
17. After processing, press Finish.
18. Product Configuration screen – Click Next.
19. Connect to Server screen – click Check.
20. Message connection successful.
21. Click Next.
22. Screen Apply server configuration – Click Execute.
23. Installer shows progress.
24. When complete, click Finish.
25. Product Configuration screen – Click Next.
26. Installation complete message will notify about installation completion.
27. Click Finish.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

Part 2: Installing MySQL Server
To start, go to the MySQL official site: www.mySQL.com

Select Downloads option;
Under MySQL community edition, select MySQL Community Server; click DOWNLOAD;
Select Platform: Microsoft Windows
Choose Other downloads: Windows 32-bit or 64-bit and press Download. To verify your OS parameters, go to Start, Control panel, System and Security, System will show the System type;
The Registration window comes up, click register. As soon as you are registered, you will be able to log in.
Bypass form. On the bottom of the page, choose No thank you, just take me to the downloads.
Select the nearest location (example: North America’ option, Hurricane Electric, choose ‘HTTP’ option there), Save a file;
Close the download window;
Close your browser;
Once the download is complete, you will see a new icon on Desktop – MySQL Installer;
Click on a new icon on Desktop – MySQL Installer;
Run it;
Installation Wizard comes up. Click Next;
On a Please select a set-up type, choose Custom and click Next;
On new screen, choose how the feature will be installed – show the directory: on the C: drive and under the webdev directory, create new folder mysql and click OK.
C:\webdev\mysql\
Click Next. Hit Install – installation starts, Status bar shows the progress;
MySQL provides an additional information available for fee, click Next;
On screen Wizard completed, uncheck Register MySQL server now and check Configure MySQL server now;
Select Finish;
If you are asked about the permission to install program, click Yes;
On the MySQL Server Instance Configuration Wizard, click Next;
Please select a configuration type Detailed configuration and click Next;
On the next page, uncheck the Developer machine and choose Server machine. Click Next;
For the database usage, choose Multifunctional Database. Click Next;
For the InnoDB datafile, choose C: drive. Click Next;
For the concurrent connections to the server (how many users may work simultaneously to MySQL server), choose default Decision Support (DSS)/OLAP for 20 users;
For the Networking option, check Enable TCP/IP Networking with default port 3306; also leave checked Enable Strict Mode. Click Next;
For the default character set, choose Standard Character set; hit Next;
For the Windows option, check Install as a Windows server; it will start MySQL server when computer is up;
Also, select Include the Directory to Windows PATH. So we can work from command path; click Next;
To select security options, create password, click Next;
Execute your configurations;
When complete, click Finish.

Deliverables
Your assignment will be graded based on the following:

Assignment	Step Description	Points
Step 1	Install MYSQL Installer	10
Step 2	Install MySQL Workbench	15
Step 3	Install MySQL Community Server	15
Total Lab Points		40

Steps 1, 2, and 3 will have you create a single Word document for this week’s iLab. Include the screenshots of the beginning and the last steps of installation. Add your feedback (issues, questions, errors) for the installations. Please be sure to label your document and include your name and course number in the heading. Save your document as yourname_iLab_1.docx.

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench,
MIS561 Lab 2 Work with Dictionary and Create Relational Database,
MIS561 Lab 3 Users Privileges and Roles,
MIS561 Lab 4 Using Backups for Complete Recovery,
MIS561 Lab 5 Optimizing query using EXPLAIN

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 5 Optimizing query using EXPLAIN

Description

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 5 Optimizing query using EXPLAIN

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 4 Using Backups for Complete Recovery

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 3 Users Privileges and Roles

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 2 Work with Dictionary and Create Relational Database

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS561 Lab 1 Installing MySQL Community Server and MySQL Workbench

CMSC 335 CMSC335 CMSC/335 ENTIRE COURSE HELP – UNIVERSITY OF MARYLAND GLOBAL CAMPUS (UMGC)

CSIS 209 CSIS209 CSIS/209 ENTIRE COURSE HELP – LIBERTY UNIVERSITY

CIS 336 CIS336 CIS/336 ENTIRE COURSE HELP – DEVRY UNIVERSITY

New Solution: CISS 242 CISS242 CISS/242 ENTIRE COURSE HELP – COLUMBIA COLLEGE

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

Description

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

MIS 561 MIS561 MIS/561 ENTIRE COURSE HELP – DEVRY UNIVERSITY

Related products

New Solution: CIS 407A CIS407A CIS/407A ENTIRE COURSE HELP – DEVRY UNIVERSITY

CMSC 335 CMSC335 CMSC/335 ENTIRE COURSE HELP – UNIVERSITY OF MARYLAND GLOBAL CAMPUS (UMGC)

CSIS 209 CSIS209 CSIS/209 ENTIRE COURSE HELP – LIBERTY UNIVERSITY

CIS 336 CIS336 CIS/336 ENTIRE COURSE HELP – DEVRY UNIVERSITY

New Solution: CISS 242 CISS242 CISS/242 ENTIRE COURSE HELP – COLUMBIA COLLEGE