MIS 562 MIS562 MIS/562 Lab 2 in MySQL – DeVry University
DOWNLOAD SOLUTION https://www.solvedcollegepapers.com/product/mis-562-mis562-mis-562-dev/ Part 1 Create the tables from demo.sql script 1. Download the demo.sql and createStudent.sql file from the Doc Sharing. Run demo.sql and createStudent.sql in MySQL Omnymbus Environment. This will create some tables and insert data into them. View the script in notepad to determine the table names that were created. Use the describe command to view the structure of the tables. 2. Please use the template below to provide your solutions. You must submit your Input SQL Query in the second column in the template and you must also include executed output of each input query below input SQL Query. Please truncate to 20 rows, if output is more than 20 rows. Any answers without executed output WILL NOT earn any credit. 3. Please use demo.sql for questions Q1 through Q12 and remaining questions use createStudent.sql 4. If you combined demo.sql and createStudent.sql under MIS562_xxxx database, then there is no need to change database. Category: Assignments Help Experts Tags: MIS 562 Lab 2 in MySQL, MIS 562 Lab 4 in MySQL, MIS 562 Lab 5 in MySQL, mis 562 lab 7, MIS 562 Lab 7 in MySQL, MIS 562 MIS562 MIS/562 Database Programming & Applications - DeVry University, mis 562 week 7, MIS 562mis 562
Description
Description
MIS 562 Lab 2 in MySQL – DeVry University Part 1 Create the tables from demo.sql script 1. Download the demo.sql and createStudent.sql file from the Doc Sharing. Run demo.sql and createStudent.sql in MySQL Omnymbus Environment. This will create some tables and insert data into them. View the script in notepad to determine the table names that were created. Use the describe command to view the structure of the tables. 2. Please use the template below to provide your solutions. You must submit your Input SQL Query in the second column in the template and you must also include executed output of each input query below input SQL Query. Please truncate to 20 rows, if output is more than 20 rows. Any answers without executed output WILL NOT earn any credit. 3. Please use demo.sql for questions Q1 through Q12 and remaining questions use createStudent.sql 4. If you combined demo.sql and createStudent.sql under MIS562_xxxx database, then there is no need to change database. Write SQL statements to solve the following requests. Question (4 pts per question) SQL statement or answer 1. 2. 3. 4.
List all employee information in department 30. List employees name, job, and salary that is a manager and has a salary > $1,000 Repeat exercise 2 for any employee that is not a manager or earns a salary > $1,000 Show all employee names and salary that earn between $1,000 and $2,000. Use the between operator. 5. Select all employees that are in department 10 and 30. Use the IN operator. 6. Select all employee names with an “A” in the first position of the employee name. Use the substring function or a wild card. 7. Select all employees with an “A” as the second character of their name. Use a wildcard. 8. List the employee names in alphabetical sequence. 9. List the job, salary, and employee name in job order and then salary in descending order. 10. Show a list of different jobs. Eliminate repeating values. 11. Show employee names, salary that has not earned a commission yet. 12. Show the employee name, salary, commission, and the total of salary and commission. Be sure you evaluate null values correctly. 13. Write an SQL query that retrieves data from the COURSE table for courses that cost 1195, and whose descriptions do not start with ‘Intro’, sorted by descending order. 14. Write an SQL query that retrieves data from the STUDENT table for students whose last names begin with “A” though “T” and who work for ‘Competrol Real Estate’, sorted by the last names. 15. Determine which student does not have the first letter the last name capitalized. Show the STUDENT_ID and LAST_NAME columns.
16. Check if any of the phone numbers in the INSTRUCTOR table have not been entered in the (###)###-#### format. Show the instructor last name and the phone number that is in the incorrect format. 17. Write an SQL statement that uses the CAST function that converts a number datatype to a varchar datatype. 18. Write a SQL statement that converts a date datatype to a char datatype. 19. Write a SQL statement that convert a number value to a character. Part 2 Please use demo.sql for questions Q1 through Q6 and remaining questions use createStudent.sql Execute the script demoaddrows.sql to add rows if necessary. Write SQL statements to solve the following requests. If you combined demo.sql and createStudent.sql under MIS562_xxxx database, then there is no need to change database. Question ( 2 points per question) SQL statement or answer 1. Show a list of different jobs. Eliminate repeating values. 2. How many employees are working at each job in each department and what the sums and averages are for the salary of those employees? 3. Show the employee name with the maximum salary 4. Show the average salary for all employees that are not managers. 5. What is the difference between the highest and lowest salary? 6. Select employee number, name for all employees with salaries above the average salary. Use a subquery. Using the ZIPCODES table from the text schema, write a SQL query that displays the following: Question ( 2 points per question) SQL statement or answer 7. Show the state and the number of zip codes by state. Order the result by number of zip codes in descending sequence. Use the ZIPCODES table. 8. Which city has the most zip codes assigned to it? 9. Show the state and the number of zip codes by state. Order the result by number of zip codes in descending sequence and exclude all states having less than 5 zip codes. Using the text schema, write a SQL query that displays the following: Question ( 2 points per question) SQL statement or answer 10. Show the Student_ID, last name, and the number of enrollments for the student. Show only students with more than 2 enrollments. Use an Inline view. 11. Show the number of students enrolled and zip code for New York and where the city begins with ‘W’. Use a Scalar subquery. 12. Display the course number and description of courses with no enrollment. Also include courses which have no section assigned. Download Full Course Solution: PSY 215 PSY215 PSY/215 Module Two Milestone. Shaina Dado.docx https://www.solvedcollegepapers.com/product/psy-215-psy215-psy-215-dado/
According to the findings of the Pew Research study, there are several potential costs and benefits that result from frequent exposure to social media. oDescribe one psychological benefitof frequent social media use. Social media usage can have several effects on us whether it be bad or beneficial. We use social media as a way to connect with others. Living alone after moving to a new place can be overwhelming and can make you feel lonely. Being able to connect with your loved ones, old colleagues and family through social media can help you rememberthat you aren’t alone. Seeing how others are doing through their posted photos or even through what they post can make you feel like you aren’t missing out on much. oDescribe one psychological costof frequent social media use. As there are positives to social media use, there are some costs that come with it. The frequent need for attention can become a cost when it comes to social media. Download Full Course Solution: POL 255-Entire course Help: Ashford University https://www.solvedcollegepapers.com/product/pol-255-entire-course-help-ashforduniversity/ POL 255 Entire Course NEW POL 255 Week 1 Assignment Theory, Arms Races, and the Prisoner’s Dilemma NEW (2 Sets) POL 255 Week 1 Discussion IR Theories Strengths and Weaknesses NEW POL 255 Week 1 Quiz NEW POL 255 Week 2 Assignment Levels of Analysis and the Crisis in Syria NEW POL 255 Week 2 Discussion Communicating National Interests NEW POL 255 Week 2 Quiz NEW POL 255 Week 3 Assignment Moral and Ethical Dilemmas from America’s Use of Drones NEW POL 255 Week 3 Discussion The Contemporary International System NEW POL 255 Week 3 Quiz NEW POL 255 Week 4 Assignment Easter Island Full of Mystery NEW POL 255 Week 4 DQ NEW POL 255 Week 5 DQ NEW
Download Full Course Solution: CIS 273 CIS273 CIS/273 ENTIRE COURSE HELPSTRAYER UNIVERSITY
https://www.solvedcollegepapers.com/product/cis-273-cis273-cis-273-web-design-anddevelopment-strayer-university/
CIS 273 Lab Assignment 2 Three Web Pages with Hyperlinks CIS 273 Lab Assignment 4 Nested Lists and Cascading Style Sheets CIS 273 Lab Assignment 5 Navigation Bars and Repeated Images CIS 273 Lab Assignment 6 Working with Tables CIS 273 Lab Assignment 7 Form Page CIS 273 Lab Assignment 8 Adding Sound CIS 273 Lab Assignment 9 JavaScript CIS 273 Lab Assignment 10 Techincal Project Business Website
Download Full Course Solution: CIS 407A CIS407A CIS/407A ENTIRE COURSE HELP – DEVRY UNIVERSITY https://www.solvedcollegepapers.com/product/cis-407a-cis407a-cis-407a-vry/ CIS407A entire course includes: CIS407A Week 1 iLab Annual Salary Calculator CIS407A Week 2 iLab User Input Web Pages CIS407A Week 3 iLab User activity monitoring CIS407A Week 4 iLab Web forms with database interaction CIS407A Week 5 iLab Transaction Processing CIS407A Week 6 iLab Login and Security Levels CIS407A Week 7 iLab Error Notification via E-MailEach tutorial includes Visual Studio ASP.NET 2013 Project.