Examine the Employees table Note that the data in the Title field contains redundant values and therefore is a candidate for a one field lookup table Use your Access Query Design View or SQL skills to create a lookup table named Titles with the unique values in the Title field of the Employees table List the steps you performed to create the lookup table EmployeelD LastName FirstName HireDate Title Salary 19 Kohn Ali 01 Jan 20 Project Leader $5,000 00 22 Kaplan Franco 01 Feb 20 Programmer $5,500 00 35 Prohm Nada 29 Feb 20 Customer Support Specialist $4,000 00 47 Alvarez Benito 31 Mar 20 Front End Developer $5,200 00 51 Shields Simone 30 Apr 20 Network Specialist $7,000 00

The Answer is in the image, click to view ...

Question: Examine the Employees table. Note that the data in the Title field contains redundant values and therefore is a candidate for a one-field lookup table.

Examine the Employees table. Note that the data in the Title field contains redundant values and therefore is a candidate for a one-field lookup table. Use your Access Query Design View or SQL skills to create a lookup table named Titles with the unique values in the Title field of the Employees table. List the steps you performed to create the lookup table.

EmployeelD	LastName	FirstName	HireDate	Title	Salary
19	Kohn	Ali	01-Jan-20	Project Leader	$5,000.00
22	Kaplan	Franco	01-Feb-20	Programmer	$5,500.00
35	Prohm	Nada	29-Feb-20	Customer Support Specialist	$4,000.00
47	Alvarez	Benito	31-Mar-20	Front End Developer	$5,200.00
51	Shields	Simone	30-Apr-20	Network Specialist	$7,000.00

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!

You will not need to use a DBMS to complete this activity. In an effort to further optimize the RDBMS you are developing for the JCC company, you noticed there was redundant data within the Employee...

JC Consulting database tables: 1. Categories ( Category ) 2. Client ( ClientID, CientName, Street, Zip, Government ) 3. Employees ( EmployeeID, LastName, FirstName, HireDate, Title, Salary ) 4....

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Have to pick a business like motorcycle shop or pool company. Then make a spreadsheet with different tables and other things needed. For example need a Employee table or a customers table. That has...

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Open the Sales table and add three records to the table with the following data. ( Hint: The first field in the table, SaleID, is an AutoNumber field, so there is nothing to enter for each record. )...

Ch 11 excel exercise Open the Problem_Data_CH11.xlsx EXCEL workbook. Review the four worksheets, then a create table for the data in each worksheet (Hint: Insert > Tables > Table. Name each table the...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Apex Corporation manufactures eighteenth-century, classical-style furniture. It uses a job costing system that applies factory overhead on the basis of direct labor-hours. Budgeted factory overhead...

Determine the marginal rate of substitution between cost and warranty of product in the Table below. Comment on you result Alternatives iPhone 8 6 Samsung 5 4 Attributes Cost(AED K) Warranty (yrs)...

Consider which option results in a higher effective rate. Bank A offers 4% compounded annually. Bank B offers 4% compounded quarterly. Multiple choice question. Bank A Bank B

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Although benefits account for a large share of employee compensation, many feel there is little evidence on whether an employer receives an adequate return on the benefits investment. One suggestion...

Your company, like many others, is experiencing doubledigit percentage increases in health care costs. What suggestions can you offer that may reduce the rate of cost increases?