Question: Consider the General Hardware relational database shown in Figure 7.19. a. Write an SQL command to create the CUSTOMER table. b. Write an SQL command

Consider the General Hardware relational database shown in Figure 7.19.

a. Write an SQL command to create the CUSTOMER table.

b. Write an SQL command to create a view of the CUSTOMER table that includes only the Customer Number and HQ City attributes.

c. Write an SQL command to discard the OFFICE table.

d. Assume that Customer Number 8429 is the responsibility of Salesperson Number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Management Systems Questions!

Q:

Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was...

Q:

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

Q:

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

Q:

Use the following tables to answer the questions: WRITE OUT THE SQL COMMANDS NEEDED TO LIST OR RETRIEVE THE BELOW INFORMATION (use SELECT, FROM, WHERE, JOIN, ON, etc) - write the full SQL commands 7....

Q:

Use Figure 6.17 above to answer the following questions: 5. In the General Hardware Corp. relational database of Figure 6.17: a. How many foreign keys are there in each of the six relations? b. List...

Q:

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

Q:

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

Q:

The database model in Figure 6.1 reflects the following business rules: - A customer may generate many invoices. Each invoice is generated by one customer. - An invoice contains one or more invoice...

Q:

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

Q:

CHAPTER 14 PROBLEMS: Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory,...

Q:

Is artificial learning intelligence important for computer science students?

Q:

You own a parcel of vacant land. You can develop it now, or wait. a. What is the advantage of waiting? b. Why might you decide to develop the property immediately?

Q:

High - low method and regression analysis. Mars Co . , a cooperative of organic family owned farms, has recently started a fresh produce club to provide support to the group s member farms and to...

Q:

Find the formulae of the quadratic functions f(x) such that (a) f(1) = 3, f (2) = 7 and f(4) = 19 (b) f(1) = 1, f(1) = 1 and f(4) = 2

Q:

Read The Impact of Capacity-Building Programs on Nonprofits:A Random Assignment Evaluation. What five critical areas did the federal governments Compassion Capital Fund (CCF) Demonstration Program...

Q:

Read The Impact of Capacity-Building Programs on Nonprofits: A Random Assignment Evaluation. What were the results of the Impact Evaluation performed by the authors to assess capacity?

Q:

In deciding whether to recognize the tax-exempt status of a new nonprofit, should the Internal Revenue Service consider whether or not it will duplicate the services of other, existing organizations...

Q:

Required information [The following information applies to the questions displayed below.] In 2020, Sheryl is claimed as a dependent on her parents' tax return. Her parents report taxable income of...

Q:

es Prepare journal entries to record transactions a through h. a. Raw materials purchased on credit, $82,000. b. Direct materials used, $37,500. Indirect materials used, $17,200. c. Direct labor...

Q:

Kesterson Corporation has provided the following information: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Sales commissions Variable administrative...