Tasks Query Description 1. Change to use the database airline 2. Insert into table cityState data...

Transcribed Image Text:

Tasks Query Description 1. Change to use the database airline 2. Insert into table cityState data from file cityState.sql 3. Insert into table employee data from file employée.sql 4. Insert into table employeePosition data from file employeePosition.sql 5. Write a join query to query join table employee, position and employeePosition to select the following: a. Columns firstName, lastName, phone, email from table employee b. Column description from table position c. Order by columns description and lastName 6. Generate an ER Diagram using MySQL Workbench, save as a .mwb file 7. Export database cruise using MySQL Workbench, save as a .sql file 8. Provide written source code in a .sql file Test Cases Test Case 1 Test Case 2 Test Case 3 Test Case 4 Test Case 5 select from employee should look like Figure 1 Note: different ID values are okay select from cityState should look like Figure 2 select from employeePosition should look similar to Figure 3 Join query result set should look like Figure 4 ER Diagram should look like Figure 5 Assignment Scope 1. Use database airline. 2. Insert data into tables. Write a join query. 3. 4. Generate an ER diagram. Tasks Query Description 1. Change to use the database airline 2. Insert into table cityState data from file cityState.sql 3. Insert into table employee data from file employée.sql 4. Insert into table employeePosition data from file employeePosition.sql 5. Write a join query to query join table employee, position and employeePosition to select the following: a. Columns firstName, lastName, phone, email from table employee b. Column description from table position c. Order by columns description and lastName 6. Generate an ER Diagram using MySQL Workbench, save as a .mwb file 7. Export database cruise using MySQL Workbench, save as a .sql file 8. Provide written source code in a .sql file Test Cases Test Case 1 Test Case 2 Test Case 3 Test Case 4 Test Case 5 select from employee should look like Figure 1 Note: different ID values are okay select from cityState should look like Figure 2 select from employeePosition should look similar to Figure 3 Join query result set should look like Figure 4 ER Diagram should look like Figure 5 Assignment Scope 1. Use database airline. 2. Insert data into tables. Write a join query. 3. 4. Generate an ER diagram.

Answer rating: 100% (QA)

Solutions Step 1 It looks like you have a series of tasks related to a database assignment Heres a breakdown of how you can approach each task Task 1 Change to use the database airline To switch to th... View the full answer