Making a query to produce all clients for one of the sales

Assignment Help Database Management System

Reference no: EM13693284

Developed a database with 10 clients, 3 sales, and 10 contacts. I am having trouble with

Part 1: making a query to produce all clients for one of the sales that are assigned to multiple clients.

Part 2: Produce a full client list by each sales person.

Part 3: Add contact summary to one client then odify, then delete.

Reference no: EM13693284

Questions Cloud

Program that prompts the user to enter the mass of a person : Write a program that prompts the user to enter the mass of a person in kilograms and outputs the equivalent weight in pounds.

Program that contains two functions in addition to main : Write a program that contains two functions in addition to main. The first one takes 2 arguments (an int array and an int) and returns nothing.

Draw the ms visio crows feet e-r model : A county wishes to create a database to control its local libraries. Each library has a number of employees, one of whom is designated as the manager of the library and is responsible for supervising employees and the general day-to-day management..

Performance measurement guide to information security : Performance Measurement Guide to Information Security. Using this document, identify five measures you would be interested in finding the results from based on your home computing systems and/or network.

Making a query to produce all clients for one of the sales : Making a query to produce all clients for one of the sales that are assigned to multiple clients - Produce a full client list by each sales person.

Write a program to track hourly employee arrival : A company hires you to write a program to track hourly employee arrival and departure times from work. In essence, you are tasked to make an online time clock - If the user enters an incorrect value more than 3 times, display a prompt that the prog..

Write a for loop header that will count backwards : Write a statement to call a function named getAge that returns an integer and takes no parameters. Assign the returned value to the already declared variable child.

Declare element array of chars named letters : Declare a 12-element array of chars named letters and what does the following program segment display?

Evaluate the expression : How many times will "jump" be displayed in the following program segment? If the loop doesn't terminate, write "infinite" Evaluate the expression.

User Account

All Pages