(Solution) If Two Tables Have A Relationship Between Them, A Join Will Connect The Data In The Tables. For This Exercise You Will Work In A Sample Car... | Snapessays.com


(Solution) If two tables have a relationship between them, a join will connect the data in the tables. For this exercise you will work in a sample car...


Please see attachedIntroduction 

 

In this assignment you will learn about joining tables together to increase the power of the

 

database.

 

If two tables have a relationship between them, a join will connect the data in the tables.

 

For this exercise you will work in a sample car dealership database that tracks customers,

 

salespeople, vehicles, and sales.

 

Step 1:  Preparing for the assignment. 

 

Your first task is to download the base database file from ANGEL. This file is called MIS 204

 

HOA11 Base Customer Database for Windows.

 

Download the file to some location that you will

 

easily remember.

 

Once downloaded, open the file.

 

Step 2:  Reviewing the database. 

 

This database is relatively simple in its current form.

 

There are four tables in the database:

 

CUSTOMERS, SALES, SALESPEOPLE, and VEHICLES.

 

The tables contain the following:

 

?

 

CUSTOMERS:

 

first name, last name, and id data for customers.

 

?

 

SALES:

 

a sales id, the employee id of the salesperson involved in the transaction, the

 

customer id of the customer involved in the transaction, and the vehicle id of the vehicle

 

sold in the transaction.

 

?

 

SALESPEOPLE:

 

first name, last name, id, and commission rate data for sales personnel.

 

?

 

VEHICLES:

 

id, make, model, and price data for vehicles in the dealership’s inventory.

 

Open each table and look around to familiarize yourself with the data but do not make any

 

changes at this time.

 

Step 3:  Creating relationships between the tables. 

 

In order to be able to join data in a database, tables must have relationships between them.

 

Otherwise, each table represents a discrete entity with no connection to any other entity in the

 

database.

 

ACCESS provides tools to create relationships between tables.

 

1.

 

Click on the Database Tools tab on the ribbon.

 

2.

 

Double Click on Relationships.

 

A dialog box will open asking you which tables you want to

 

show:

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147721091.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote