List the number and name of all customers

Assignment Help Basic Computer Science
Reference no: EM131092074

In the following exercises, you will use the data in the TAL Distributors database (If you use a computer to complete these exercises, use a copy of the original TAL Distributors database so you will still have the original data when you complete Chapter 4.) In each step, use SQL to obtain the desired results. You can use a DBMS to complete the exercises using a computer, or you can simply write the SQL command to com-plete each step. Check with your instructor if you are uncertain about which approach to take.

1. List the number and name of all customers.

2. List the complete Item table.

3. List the number and name of every customer represented by rep 15.

4. List the number and name of all customers that are represented by rep 15 and that have credit limits of $10.000.

5. List the number and name of all customers that are represented by rep 15 or that have credit limits of $10,000.

6. For each order, rist the order number, order date, number of the customer that placed the order, and name of the customer that placed the order.

7. List the number and name of all customers represented by Megan Gradey.

8. How many customers have a credit limit of $15,000?

9. Find the total of the balances for all customers represented by rep 30.

10. Give the item number. description, and on-hand value (Onlland • Price) for each item in category GME.

11. List all columns and all rows in the Item table. Sort the results by Item description.

Reference no: EM131092074

Explain how dynamic allocation of memory works

Describe the process of creating a dynamically allocated object. Specifically, discuss the roles of a pointer variable and the new operator in creating a dynamically allocat

Type of fuel should you mix

Suppose a car can run on ethanol and gas and you have a 15 gallons tank to fill. You can buy fuel that is either 30 percent ethanol or 80 percent ethanol. How much of each t

Application of artificial intelligence in different fields

What are application of artificial intelligence in different fields and also explain it and what are application of artificial intelligence in computer science give an example

Develop a training schedule for hoosier burgers end users

Develop a training schedule for Hoosier Burger's end users, develop a hardware and software installation schedule for Hoosier Burger and develop User Documentation for the Del

User computer by a web server-contains information

A cookie-a simple text file that is placed on a user's computer by a Web server-contains information about the user's visit to that website. It might also contain personal i

Design a modified priority encoder

Design a modified priority encoder that receives an 8-bit input, A7:0, and produces two 3-bit outputsm Y2:0 and Z 2:0 Y indicates the most significant bit of the input that

Tour operator agency database

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer

Develop object designs for important classes

Apply the OOD approach discussed in this chapter to flesh out the design for the SafeHome system. Define all relevant subsystems and develop object designs for important cla

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd