Using Normalized Databases

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

Using Normalized Databases A+ Tutorial use as guide

NOT RATED

Purchase the answer to view it