Question

In: Computer Science

Please use an Access database with two tables to answer the following: use an example to...

Please use an Access database with two tables to answer the following: use an example to discuss the difference between a right, left, and inner join. Next, perform the left joint, right joint, and inner joint all on the each of the two tables.

Solutions

Expert Solution

INNER JOIN:
Inner Join is nothing but equi-join, it is the most common join, it is used to get common(matching) data from both the tables.

RIGHT JOIN:
Right join will take all the records from the right table but only take matching data from the left table.

LEFT JOIN:
Left Join is just the opposite of RIGHT JOIN, take all the records from the left table but only take matching data from the right table.

Don't be confused with it, in ACCESS it is the same concept as other,
It is very simple here we just have to drag and drop and use some options.

Let me explain with some example:

let say there is 2 Table, I am keeping it very simple. You can see in the below screenshot.

if it is not much visible don't worry, let me explain it, here is 2 tables Customers and Order Items with different attributes in it.

Now If I want to join this 2 tables I will have to select 1-2 column from both the table with is be a relation, lets see that screenshot:

Just like this.

Now if you double-click on that line you will get options.

here 1st option is INNER JOIN, 2nd option is LEFT JOIN and obviously 3rd is RIGHT JOIN.

I hope it is clear.

Thanks


Related Solutions

1. Download the EXCEL file: Access Exercise Tables 2. Open a new blank database in ACCESS...
1. Download the EXCEL file: Access Exercise Tables 2. Open a new blank database in ACCESS and name it “Exercise-Your Name” where you replace Your Name with your name. 3. Import each worksheet in the EXCEL file into ACCESS as a separate table as follows: a. External Data Tab -> Import Excel icon b. In the dialog box browse for the destination of the excel file you saved in step 1, it should default to “import the source data in...
Question 2. The following tables provide some example data that will be kept in the database....
Question 2. The following tables provide some example data that will be kept in the database. Write the INSERT commands necessary to place the following data in the tables that were created in Question 1. Alternatively provide the text files (copy and pasted into your final report) and the open/insert from file commands.. Table: actor act_id | act_fname | act_lname | act_gender 101 | James | Stewart | M 102 | Deborah | Kerr | F 103 | Peter |...
Please create the following tables for a tool rental database with appropriate primary keys & foreign...
Please create the following tables for a tool rental database with appropriate primary keys & foreign keys. Assumptions: 1. Each tool belongs to a category. 2. Each category may have a parent category but the parent category should not have a parent category (so at most two levels). E.g., a Tool A belongs to the electric mower, and electric mowers belong to mowers. Mower has no parent category. 3. Each tool can be rented at different time units. The typical...
PHP The database should have at least two tables with, at minimum, the following fields: Table...
PHP The database should have at least two tables with, at minimum, the following fields: Table customers: Fields: Table billing: Fields: customer_ID customer_ID customer_L_Name customer_L_Name customer_F_Name service customer_Title (Mr, Ms, Dr. etc,) customer_bill street_Address amt_paid city_State_Zip bill_date customer_Phone date_paid customer_Email Create a PHP page that will extract a customer’s bill amount and the amount paid. Then it will calculate the amount due. If the amount due is greater than 0, an email should be generated and sent to the customer...
Problem 1. Please create the following tables for a tool rental database with appropriate primary keys...
Problem 1. Please create the following tables for a tool rental database with appropriate primary keys & foreign keys. [30 points] Assumptions: Each tool belongs to a category. Each category may have a parent category but the parent category should not have parent category (so at most two levels). E.g., a Tool A belongs to electric mower, and electric mower belongs to mower. Mower has no parent category. Each tool can be rented at different time units. The typical time...
What are contingency tables? How do they work? Please give an example or two.
What are contingency tables? How do they work? Please give an example or two.
The following tables form part of a database (Flights Database) held in a relational DBMS: employee...
The following tables form part of a database (Flights Database) held in a relational DBMS: employee (empNo, empName, empSalary, empPosition) aircraft (aircraftNo, acName, acModel, acFlyingRange) flight (flightNo, aircraftNo, fromAirport, toAirport, flightDistance, departTime, arriveTime) certified (empNo, aircraftNo) Where:  employee contains details of all employees (pilots and non-pilots) and empNo is the primary key;  aircraft contains details of aircraft and C is the primary key.  flight contains details of flights and (flightNo, aircraftNo) form the primary key.  certified...
Database Design Design a database and show the relationship between each tables. I need multiple tables....
Database Design Design a database and show the relationship between each tables. I need multiple tables. *Must meet the requirements for Third Normal Form. These are the information for employee DB. Employee Number, First Name, Last Name, Date of birth, Address, city, state, zip, department, job title, supervisor, health insurance number, health insurance provider, dental insurance number, dental insurance provider, spouse/partner, children, children's ages.
Your organization's database needs include the following: Multiple departments will require access to the database, including...
Your organization's database needs include the following: Multiple departments will require access to the database, including eCommerce, manufacturing, sales, and customer service Employees will use the database to: Enter data Reference data Use data to auto-populate new orders and customer service records Analyze data and create reports Recommend three of the following six database architecture types that would work for your organization: Hierarchical Network Relational Distributed Relational Object-Oriented Cloud Include the following in your recommendation: Your top three recommended architectures,...
QUESTION: The following tables describe the content of a relational database: a) Identify and classify the...
QUESTION: The following tables describe the content of a relational database: a) Identify and classify the tables as either entity or relationship The first step in building an E-R model is to identify the entities. Having identified the entities, the next step is to identify all the relationships that exist between these entities. Using the content of the relational database above: b) Using the relations in the relational database, explain how one can transform relationship in E-R model into a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT