MIS 562 MIS562 MIS/562 Lab 4 in MySQL – DeVry University

DOWNLOAD SOLUTION https://www.solvedcollegepapers.com/product/mis-562-mis562-mis-562-dev/ Please use the template below to provide your answers. Be sure to add your SQL Query and executed output from your input SQL Query. Any answers without executed output WILL NOT earn any credit. Part 1 Using the tables created in week 2: Question ( 4 pts per question) SQL Statement or Answer 1. Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join. 2. Select all employee names and their department names. Be sure to show all employees whether they are assigned to a department or not. Use an outer join. Using the student schema: Question ( 3 pts per question) SQL Statement or Answer 3. Write a query that that performs an inner join of the grade, student, and grade_type tables. 4. 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

MIS 562 Lab 4 in MySQL – DeVry University Please use the template below to provide your answers. Be sure to add your SQL Query and executed output from your input SQL Query. Any answers without executed output WILL NOT earn any credit. Part 1 Using the tables created in week 2: Question ( 4 pts per question) SQL Statement or Answer 1. Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join. 2. Select all employee names and their department names. Be sure to show all employees whether they are assigned to a department or not. Use an outer join. Using the student schema: Question ( 3 pts per question) SQL Statement or Answer 3. Write a query that that performs an inner join of the grade, student, and grade_type tables. 4. Write a query that that performs an inner join of inner join of the grade, student, and grade_type tables using inner join convention. 5. List all the zip codes in the ZIPCODE table that are not used in the STUDENT or INSTRUCTOR tables. 6. Write a SQL statement using a set operator to show which students enrolled in a section that are not enrolled in any classes. Exclude students with student id greater than 300. Part 2 Question ( 5 pts per question) SQL Statement or Answer 1. Write and execute two INSERT statements to insert rows into the ZIPCODE table for the following two cities of your choice. After your INSERT statements are successful, make the changes permanent. 2. Create a sequence called STUDENT_ID_NEW that begins with 900 and increments by 1. If the sequence already exists, drop the sequence and recreate it. 3. Make yourself a student by writing and executing an INSERT statement to insert a row into the STUDENT table with data about you. Use one of the zip codes you inserted in Exercise 1. Only insert values into the columns STUDENT_ID using the sequence you created in step 2, FIRST_NAME, LAST_NAME, ZIP, REGISTRATION_DATE (use a date that is five days after today), CREATED_BY, CREATED_DATE, MODIFIED_BY, and MODIFIED_DATE. Issue a COMMIT command afterwards. 4. Write an UPDATE statement to update the data about you in the STUDENT table. Update the columns SALUTATION, STREET_ADDRESS, PHONE, and EMPLOYER. Be sure to also update the MODIFIED_DATE column and make the changes permanent

5. Delete the row in the STUDENT table and the two rows in the ZIPCODE table you created. Be sure to issue a COMMIT command afterwards 6. Create a table called TEMP_STUDENT with the following columns and constraints: a column STUDID for student ID that is NOT NULL and is the primary key, a column FIRST_NAME for student first name; a column LAST_NAME for student last name, a column ZIP that is a foreign key to the ZIP column in the ZIPCODE table, a column REGISTRATION_DATE that is NOT NULL 7. Write an INSERT statement violating at least two of the constraints for the TEMP_STUDENT table you just created. 8. Write another INSERT statement that succeeds when executed, and commit your work. 9. Alter the TEMP_STUDENT table to add two more columns called EMPLOYER and EMPLOYER_ZIP. The EMPLOYER_ZIP column should have a foreign key constraint referencing the ZIP column of the ZIPCODE table. Update the EMPLOYER column. Use Google as your employer and use zip code 94043 10. Alter the table once again to make the EMPLOYER column NOT NULL. 11. Write a statement that drops the EMPLOYER_ZIP column. 12. Drop the TEMP_STUDENT table once you’re done with the exercise. 13. Create a non unique index called crse_modified_by_i on the MODIFIED_BY column of the course table 14. Change the registration date of Regina Gates to today’s date. Create a view called CURRENT_REGS reflecting all students that registered today. (You will need to execute this query in question 6 on the same day you change the date) 15. Create a view called roster reflecting all students taught by the instructor Marilyn Frantzen. Query the view. 16. Given the MY_EMPLOYEE view, what information is the user allowed to retrieve? Who can update the SALARY column through the view? Hint: The USER function returns the name of the currently logged in user. CREATE OR REPLACE VIEW my_employee AS SELECT employee_id, employee_name, salary, manager FROM employee WHERE manager = USER WITH CHECK OPTION CONSTRAINT my_employee_ck_manager 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.

Turn static files into dynamic content formats.

Create a flipbook

MIS 562 MIS562 MIS/562 Lab 4 in MySQL – DeVry University

Published on Feb 7, 2022Programming

solvedcp

https://www.solvedcollegepapers.com/product/mis-562-mis562-mis-562-dev/ Please use the template below to provide your answers. Be sure to add your SQL Query and executed output from your input SQL Query. Any answers without executed output WILL NOT earn any credit. Part 1 Using the tables created in week 2: Question ( 4 pts per question) SQL Statement or Answer 1. Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join. 2. Select all employee names and their department names. Be sure to show all employees whether they are assigned to a department or not. Use an outer join. Using the student schema: Question ( 3 pts per question) SQL Statement or Answer 3. Write a query that that performs an inner join of the grade, student, and grade_type tables.