Using the data for the JC Consulting database shown in Figure 2-1 and your answers from the previous question, which tables would need to be involved if you wanted to create a query that showed the EmployeeID and LastName fields from the Employees table as well as all TaskID and Description fields from the TaskMasterList table that were related to that employee?

Transcribed Image Text:

TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03 Code Ruby on Rails CODE04 Code SQL CODE05 Code HTML CODE06 Code CSS CODE07 Code JavaScript CODE08 Perform analytics CODE09 Select technology stack CODE 10 Apply SEO CODE12 Create prototype Code WordPress CODE13 CODE14 Code Python CODE15 Create shopping cart CODE16 Code Other DB01 DB02 DB03 Design relational database Convert data Install MySQL database Install SQL Server database Install Access Database MEETOO Initial customer meeting DB04 DB05 CategoryID Per Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Database Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Project Database Hour Database Project Database Project Database Project Meeting Project Estimate $150.00 $150.00 $150.00 $150.00 $100.00 $100.00 $125.00 $100.00 $200.00 $125.00 $150.00 $100.00 $150.00 $125.00 $150.00 $1,000.00 $125.00 $500.00 $500.00 $400.00 $0.00