Question: Question 3 Data in a database is stored in separate tables, where each table stores a certain type of information. A join allows you to

 Question 3 Data in a database is stored in separate tables,

Question 3 Data in a database is stored in separate tables, where each table stores a certain type of information. A join allows you to write a query that gets information from two or more tables and view the columns in a single set of results. Consider the tables A and B below and answer the questions that follow. Table A Table B 3.1. Briefly explain INNER and OUTER JOINs and differentiate between INNER and OUTER JOINs (6 Marks) 3.2. Write the SQL queries to perform an INNER JOIN of the tables and show the output of the joining. (7 Marks) 3.3. Write the SQL queries to perform left OUTER JOIN of the tables and show the output of the joining. (7 Marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!