I tried to understand this question. it says:An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly?Can someone help me with this problem? Figure 2-48 Query to Select the Client Name, Project ID,and DescriptionQuery!ClientsProjectsTaskMasterList? ClientiDV ProjectiD? TaskIDClientNameProjectStartDateDescriptionStreetClientIDCategoryIDZipEmployeelDPerGovernmentProjectNotesEstimateField: ClientNameTable: ClientsProjectIDProjectsDescriptionTaskMasterlistSortShow.Criteria:or

Answer :- The given query is not enough to get the correct result as : There is no relation between the TaskMasterList and Projects and the database engine will not be able to match the only records which related to particular projects: Solution: The solution to get the correct query is to add a reference of project using ProjectID in TaskMasterList which will tell for which project the particular task is added. It can be done with below steps: a) Close all relationships, tables and queries. b) Open the design view of TaskMaterList table. c) Add an attributes ProjectID as below and save and close it: d) Go to DatabaseTools -> Relationships and add a relationship between Projects and TaskMasterList by dragging ProjectID from Projects to TaskMasterList as below: e) Save the relationship. Execution of given query: After adding the above relationship, the query given in figure 2-48 created by an employee will work fine.

Answered: Figure 2-48 Query to Select the Client…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

I tried to understand this question. it says:

An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly?

Can someone help me with this problem?