Question
Offered Price $55.00

MIS582 week 1 ilab 2017

Question # 00495320
Subject: Computer Science
Due on: 03/05/2017
Posted On: 03/04/2017 01:50 PM

Rating:
4.1/5
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
4760
Tutorials:
6482
Feedback Score:

Purchase it
Report this Question as Inappropriate
Question

This week, you will learn to create and run SQL SELECT queries 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 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.

Deliverables

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these .equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html">step-by-step instructions.

(See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)

  • SQL file named LastName_Lab1_Query.sql containing SELECT statements
  • Word document named LastName_Lab1_Output containing queries and output
  • Zip the files, and upload the zipped file to the Week 1: iLab Dropbox.

Required Software

Omnymbus – MySQL

Access the software at .edupe.net:8300">https://devry.edupe.net:8300
Steps: 1–4

Lab Steps

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 Environmentfrom 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 WeekOneiLabScript.sqlfile from Doc Sharing in the folder titled iLab Documents

STEP 3: Running script file in MySQL, create SQL SELECT Queries

Run scripts files in MySQL:

  • Download the tutorial Running SQL Scripts in MySQL Omnymbus environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow those steps to help execute the WeekOneiLabScript.sql file needed to create the needed tables and to insert data into them.

Create SQL SELECT Queries:

  • Using the data in the Student table in the database, create a SQL script file named LastName_Lab1_Query.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 each query with a screen shot of the output in a MS Word document named Lastname_Lab1_Output.
NameTask
Query1Write a SQL statement to display Student’s First and Last Name.
Query2Write a SQL statement to display the Major of students with no duplications. Do not display student names.
Query3Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622
Query4Write 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.
Query5Write 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.

Query7Write 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.
Query8Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.
Query9Write 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.

STEP 4: Save and Upload to Dropbox

When you are done, zip the files Lastname_Lab1_Query.sqland Lastname_Lab1_Query_Output file and upload them to the Week 1: iLab Dropbox.

Tutorials for this Question
Available for
$55.00

MIS582 week 1 ilab 2017

Tutorial # 00491843
Posted On: 03/04/2017 01:51 PM
Posted By:
Best Tutors for school students, college students mac123
Expert tutors with experiences and qualities
Questions:
4760
Tutorials:
6482
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …ilab…
Attachments
MIS582_week_1_ilab.zip (1.62 KB)
Rhodes_Lab1_Query_Output.docx (30.21 KB)
Preview: who xxxx the xxxxxxxxxxxx than 1 xxx less than xx  Use xxxxxxx xxxxxx STUDENT xxxxxxxxxx , STUDENT xxxxxxxxxx STUDENT CLASSFROM xxxxxxxxxxxxxxxxxxx CLASS xxxxxxx x And xx First_NameLast_NameCLASSRanaMills2HolmesSnow3CaseyDillon2DahliaFerrell3VictorStrickland3SashaFrost3CameronCalhoun3JakeemGonzalez4AmethystMichael2ColeCooper2GriffinPetersen3SheilaCrane2OscarGilliam4AuroraCohen3JoshuaBlack2PatienceBarber4BlakeDunn2VaughanAshley2Write a xxx statement to xxxxxxx the xxxxx xxx Last xxxx of students xxx have the xxxx name xxxx xxxxxx with xx S SELECT xxxxxxx First_Name , xxxxxxx Last_NameFROM xxxxxxxxxxxx xxxxxxx Last_Name xxxx 'S%';First_NameLast_NameHolmesSnowSydneyStevensonVictorStricklandWrite a xxx statement to xxxxxxx the xxxxx xxx Last xxxxxx studentshaving ana xx.....
Purchase this Tutorial @ $55.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
Loading...