Question: Create 5 (or more) tables that correspond to the entities in your ERD. Choose tables that are in relationship with each other so you
Create 5 (or more) tables that correspond to the entities in your ERD. Choose tables that are in relationship with each other so you can use the tables for the following queries. Show the SQL statements. (Do not forget the primary and foreign keys, and any appropriate constraints.) Insert some data into each of the tables (at least 10 rows per table). Show the SQL statements, and the content of each table after all the tables are being populated. Come up with one query of your database that requires an inner join of at least two tables. State the purpose of the query, show the SQL statement and the output. Come up with one query of your database that requires an outer join of at least two tables. State the purpose of the query, show the SQL statement and the output. Come up with one query of your database that requires a subquery. State the purpose of the query, show the SQL statement and the output. Come up with one query of your database that requires an aggregate function. State the purpose of the query, show the SQL statement and the output. Come up with one query of your database that requires the OVER clause. State the purpose of the query, show the SQL statement and the output. Come up with a view of your database that limits the user's access to specific rows and columns. State the purpose of the view, show the SQL statement, an example of how the view is invoked, and the output.
Step by Step Solution
There are 3 Steps involved in it
It seems like youve uploaded multiple images related to SQL queries and table creation Ill assist with the details of these tasks based on the information youve provided Lets break it down step by ste... View full answer
Get step-by-step solutions from verified subject matter experts
