task 1 create 3 rows of data for each table


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

Request for Solution File

Ask an Expert for Answer!!
Database Management System: task 1 create 3 rows of data for each table
Reference No:- TGS0501276

Expected delivery within 24 Hours