Write an sql command to create the customer table

Assignment Help Basic Computer Science

Reference no: EM131269924

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 758. Write an SQL command to change that responsibility to Salesperson Number 311.

e. Write an SQL command to add a new record to the CUSTOMER table for Customer Number 9442. The Customer Name is Smith Hardware Stores, the responsible salesperson is Salesperson Number 577, and the HQ City is Chicago.

Reference no: EM131269924

Questions Cloud

Describe the purpose of the group by clause : Describe the purpose of the HAVING clause. How do you decide whether to place a row-limiting predicate in the WHERE clause or in the HAVING clause?

How the decentralized nature of terrorist networks impacts : Briefly describe how the decentralized nature of terrorist networks impacts the ability of the United States to combat terrorism. Prepare this assignment according to the APA guidelines found in the APA Style Guide, located in the Student Success..

Describe the web application software stack : What are the three categories of web application infrastructure elements? Describe the web application software stack. What is the role of a web application platform? What components does it contain?

Reduce unemployment in south africa : Discuss ANY THREE (3) measures that have been used to reduce unemployment in South Africa in the last decade. Recommend the curse of action which you think the government should take to reduce unemployment to an acceptable level.

Write an sql command to create the customer table : Write an SQL command to add a new record to the CUSTOMER table for Customer Number 9442. The Customer Name is Smith Hardware Stores, the responsible salesperson is Salesperson Number 577, and the HQ City is Chicago.

How the source is useful in your work on your research topic : Evaluation of source - a sentence or two discussing the goal of the source and how effectively it achieves that goal. Usefulness of the source for your purposes - a couple of sentences discussing how the source is useful in your work on your resear..

Why is it referred to as a decomposition process : Describe the data normalization process including its specific steps. Why is it referred to as a ‘‘decomposition process?''

Viable structural forms for the superstructure : Using annotated sketches, propose two distinct and viable structural forms for the superstructure and substructure. Indicate clearly the functional framing, load transfer and stability aspects of each

What data does the company have : What data does the company have? Who are the potential user groups and what information will they seek? What internal systems and databases does Dirt Bikes likely have that might interface with the portal?

User Account

All Pages