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:
4661
Tutorials:
6257
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.

Tags 0 ilab week mis582 display create omnymbus mysql write students database statement tutorial file titled files queries folder dropbox select docsharing ilab step steps named environment download script containing using status upload student week

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:
4661
Tutorials:
6257
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …ilab…
Attachments
MIS582_week_1_ilab.zip (1.62 KB)
Preview not available.
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...