Use the links below to access information about the World Wide Importers Database.

World Wide Importers Sample Database OverviewLinks to an external site.

World Wide Importers Data DictionaryLinks to an external site.

Use the information about the database to answer the following questions.

John is an employee working in HR for WWI. Which database schemas should John have access to in order to do his job? Write an SQL statement that gives John the access he needs.

Olive is a warehouse employee for WWI. Which database schemas should Olive have access to in order to do her job? Write an SQL statement that gives Olive the access she needs.

Rory is a salesperson for WWI. Which database schemas should Rory have access to in order to do her job? Write an SQL statement that gives Rory the access she needs.

For the three people above, are there any items $($tables$,$ views, or schemas$)$ they should not have access to$?$ Write an SQL statement that removes their access to those items.

Write the steps for a transaction that orders a new product for the warehouse. You do not need to write the entire SQL statement for each step.

Write the steps for a transaction that processes a customer order. You do not need to write the entire SQL statement for each step.