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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Optimization And Data Science Trends And Applications 5th Airoyoung Workshop And Airo Phd School 2021 Joint Event
Authors: Adriano Masone ,Veronica Dal Sasso ,Valentina Morandi
1st Edition
3030862887, 978-3030862886
