Create as creenshot of each query and output

Question

Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.

Task 2: Add the 30 rows of data to the appropriate table in your database (using any appropriate method available).

Task 3: SELECT all columnsand all rowsof the 10 tables. Create ascreenshot of each query and output data, and submit them.

Task 4: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data):

Display the employee id, first_name, last_name, and department_name for all employees.

Rows returned

Display the employee id, first_name, last_name, and job title_name for all employees.

Rows returned

Display the employee id, first_name, last_name, department_name, and job title_name for all employees.

Rows returned

Answer 1

For the following database problem, perform the following tasks and show the work. Task 1: Prepare 3 rows of data for each and every table making sure that the referential integrity is valid. Task 2: Add 30 rows of data to the suitable table in your database (by employing any suitable technique available). Task 3: Choose all columns and all rows of the 10 tables. Create a screen-shot of each and every query and output data and present them. Task 4: Write down SELECT statements for the given (comprise a screenshot of the SQL and its execution, comprising the resulting data): a) Show the employee id, first_name, last_name and department_name for all the employees. b) Show the employee id, first_name, last_name and job title_name for all the employees. c) Show the employee id, first_name, last_name, department_name and job title_name for all the employees.