Cashback Offer from 22nd to 27th July 2021. Get Flat 20% Cashback credited to your account for a minimum transaction of $50. Post Your Question Today!

Question DetailsNormal
$ 28.00

ILab 1 SQL Queries Using MySQL | Complete Solution

Question posted by
Online Tutor Profile
request

iLab 1 SQL Queries Using MySQL

iLab Overview

Scenario/Summary

The purpose of this iLab is to prepare for the first phase of the Course Project. This week, you will learn to create and run SQL SELECT queries from a script  in the MySQL database. You will need to create a database in MySQL via Omnymbus, run a SQL script to create tables and insert data, create and execute a script containg SQL SELECT queries using the STUDENT table.

Please ensure that you can connect to MySQL/Omnymbus via the account your Professor has emailed to you. Please consult with the document titled MySQLOmnymbusSupport.docx located in the Doc-Sharing folder titled Omnymbus Tutorial Files for instructions on how to get help for any issues that you are having with the MySQL/Omnymbus Environment.

Due Midnight Mountain Time attached to the Week 1 DropBox. OR let me know if you are going to be delayed!

    SQL file named Lab1_Query.sql containing SELECT statements
    Text document named Lab1_Output.txt containing labeled output
    Upload files to the Week 1  iLab Dropbox.
    Please do not zip the files

Required Software

Omnymbus – MySQL at the edupe database server.

Access the software at https://devry.edupe.net:8300
If you have any problems,  connection, password, technical, etc  ONLY your instructor can assist. Using any other Help facility will delay the resolution of the problem as the request is forwarded in all cases to the instructor.

STEP 1: Logging in to Omnymbus

    Look at your email account to obtain the MySQL/Omnymbus account and password that your Professor has emailed to you.
    To help you log into MySQL Omnymbus environment, download the tutorial Login MySQL Omnymbus Environment in the Doc-Sharing folder titled “Omnymbus Tutorial Files”.

STEP 2: Create a Database and modify your script to reference your Database

Create a MySQL database:

    Download the tutorial Creating a Database in MySQL Omnymbus Environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow the steps to create a database in MySQL, especially paying attention to the database naming conventions specified in the tutorial.
    Download the Wk1LoadDatabaseScript.sql file from Doc Sharing in the folder titled iLab Documents.

STEP 3: Running script file in MySQL, create SQL

Download the tutorial Running SQL Scripts in MySQL Omnymbus environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow those steps and execute the Wk1LoadDatabaseScript.sql file to create the  tables and to insert data into them; and then download and run the script file with the queries  iLab1QueryScript.sql.  This script has the first few queries and it is intended that you should finish it.  A demonstration in the Week 1 Live Lecture will be provided.

Create SQL SELECT Queries:

ALWAYS and only use a plain text editor such as Notepad!  All word processors will insert hidden tags that confuse database processors.

    Using the data in the Student table in the database, expand the supplied starter SQL script file named iLab1QueryScript.sql, containing queries to execute each of the tasks below.
    To reference, learn and apply MySQL’s own dialect of the SQL language to this iLab, browse through the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc-Sharing folder titled My SQL Documents.
    Save the completed results by copying and pasting to a file named iLab1_Results.txt
    An incomplete example is provided in the Doc Sharing.

Name
    

Task

Query1
    

Write a SQL statement to display Student’s First and Last Name.

Query2
    

Write a SQL statement to display the Major of students with no duplications. Do not display student names.

Query3
    

Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622

Query4
    

Write a SQL statement to display the First and Last Name of students who live in the Zip code 97912 and have the major of CS.

Query5
    

Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622 or 37311. Do not use IN.

Query6
    

Write a SQL statement to display the First and Last Name of students who have the major of Business or Math. Use IN.

Query7
    

Write a SQL statement to display the First and Last Name of students who have the Class greater than 1 and less than 10. Use the SQL command BETWEEN.

Query8
    

Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.

Query9
    

Write a SQL statement to display the First and Last Name of students having an a in the second position of their first names.

Query10
    

Write a SQL expression to display each Status and the number of occurrences of each status using the Count(*) function; display the result of the Count(*) function as CountStatus. Group by Status and display the results in descending order of CountStatus.

Note:  there are examples very similar to these in the Kroenke text

Rubric


Queries that are correct will be awarded the number of points shown below:
4 points: Query 1
5 points: Query 2 – 9
6 points: Query 10

The following rubrics will be used for incorrect queries:
0 points: Query was not turned in with the assignment.
-4 points: Query will not run.
-3 points: Query runs but is incorrect because query required a WHERE clause to meet requirements which was not included.
-2 points: Query runs but is incorrect because WHERE clause contained errors, gives popup for user input, or only meets partial requirements.


Please Make sure all requirements are met!

Available Answer
$ 28.00

[Solved] iLab 1 SQL Queries Using MySQL | Complete Solution

  • This solution is not purchased yet.
  • Submitted On 03 Sep, 2015 03:20:46
Answer posted by
Online Tutor Profile
solution
/*Using the STUDENT table in the MISLab...
Buy now to view the complete solution
Other Similar Questions
User Profile
Exper...

iLab 1 SQL Queries Using MySQL | Complete Solution

/*Using the STUDENT table in the MISLab1 database in Omnymbus, perform the following tasks: Note the first SELECT is there to label the output, DUAL is a ...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35