University:
Southern New Hampshire University
Course:
DAD220 | Introduction to Structured Database Environments
Academic year:

2023
Views:

220

Pages:

7
Author:

Cameron T.

Cameron Thistle SNHU DAD-220 03/19/2023 3-2 a. chmod +x change_perm.sh and then b. ./change_perm.sh c. Then, enter a command line session with MySQL and reconnect to the employee information you entered in the previous lab. d. Write a SELECT statement for the Employee table to check that you have reconnected to the right information. Update the name of the Branches table that you created in the previous lab to say “Department.” a. Use an ALTER statement to successfully RENAME the “Branches” table to “Department.” b. Capture these outputs in a screenshot to validate that you have successfully completed this step. Insert fields to the Department table so that you will be able to perform joins on them. a. INSERT INTO Department VALUES (1, ‘Accounting’), (2, ‘Human Resources’), (3, ‘Information Systems’), (4, ‘Marketing’); b. Write a SELECT statement for this table to prove this step and validate that it ran correctly with a screenshot. Now, perform joins between the Department and Employee tables and show results for how many employees work in each one of the four departments. This will only provide information on the records that are already there. a. Department 1 = Accounting i. Command: select First_Name, Last_Name, Department.Department_Name from Employee inner join Department on Employee.Department_ID = Department.Department_ID where Employee.Department_ID = 1; b. Using SELECT statements like the one above, perform joins to produce results for the following tables: i. Department 2 = Human Resources ii. Department 3 = Information Services iii. Department 4 = Marketing c. Capture the results of these joins and validate your work by providing a screenshot. You should have the same number of records as you do employees. Perform a join across the Employee and Department Tables for each of the four departments. New and existing records should be displayed in the results. Take a screenshot to capture the updated results that the Employee and Department joins show to validate that they have run correctly. You should have the same number of records as you do employees. Identify the resultant outputs of the commands that you have written: a. How many records are returned for employees in each department? Account – 4, Human Resources – 5, IS – 4, Market – 4 17 all together Explain how the joins you used in this assignment worked. To display all the employees from the same department in the various department tables, we were able to join the department and employee databases using the joins we used for this assignment. Describe why the commands you used were able to retrieve the Department table when you selected the Department name. We were able to select the employees' First and Last names as well as their Employee ID using the commands we used. This permitted us to snatch their name and put it in the table that their Employee ID was relegated as well. File creation and extraction The CSV file that I made contained nine records. Provide a detailed explanation of how the process of extracting data to a flat file works We need to be able to arrange raw data in a way that makes sense for it to have an effect when we work with it. We can make it easier to use the data in other tables and spreadsheets by creating a flat file and exporting it from SQL into the CSV format.