Consider you are instructed to create reports that extracted data from a customerrelationship management application.to be exact, the sales team wanted a list of allcustomers and their associated professions.Customers and professions tables look like this:CREATE TABLE customers (-> id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,-> name VARCHAR (255) NOT NULL,-> profession_id INTEGER UNSIGNED NOT NULL);CREATE TABLE professions (-> id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,-> name VARCHAR (255) NOT NULLA) Analyze What is the shared attribute that is linking these two tables?B) Outilne a Query and use JOIN to retrieve each customer name and the associatedprofession namec) Retrieve only customers whose professions are "Technical writers,"

A:-Profession_id is a shared attribute for linking two table B:- Select customers. name,…

Consider you are instructed to create reports that extracted data from a customer relationship management application.to be exact, the sales team wanted a list of all customers and their associated professions.

Consider you are instructed to create reports that extracted data from a customer relationship management application.to be exact, the sales team wanted a list of all customers and their associated professions.

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