Question: Part 2: q20 to q23 20. Provide SQL code to Insert one row into the CUSTOMER table you just created. Use values of your choice.

Part 2: q20 to q23

20. Provide SQL code to Insert one row into the CUSTOMER table you just created. Use values of your choice.

21. Provide SQL code to create a sequence that could be used to generate the primary key for the AGENT table. Syntax counts.

22. Write an SQL statement that will delete the CUST_ZIP column in the CUSTOMER table.

23. Write an SQL statement to remove the AGENT table and all its contents.

Part 2: q20 to q23 20. Provide SQL code to Insert one

USE THESE TABLES FOR QUESTIONS 18 THRU 23 CUSTOMER CUS CODE CUS NAME CUS ZIP AGENT CODE 1132445 Walker 32145 231 1217782 Adares 32145 125 1312243 Rakowski 34129 167 32134 1321242 Rodriguez 125 37134 421 1542311 Smithson 32145 1657399 Vanloo 231 AGENT AGENT CODE AGENT PHONE 6152439887 125 167 6153426778 231 6152431124 333 9041234445

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 Databases Questions!

Here are the directions I need only the SQL code not the database itself: 1. Basic CREATE TABLE Statement Requirements Use the table descriptions in the Intercollegiate Database background document....

Background You are to design a scenario of your choosing. This scenario will be modelled initially as an ERD, and then implemented in SQL statements. As well as creating the requisite SQL Tables, you...

design a scenario . This scenario will be modelled initially as an ERD, and then implemented in SQL statements. As well as creating the requisite SQL Tables ,need to manufacture data that is imported...

1 . What are all of the rules for primary keys in a table. Provide an example that is different from one in the book. 2 . What is the main purpose of a foreign key in a table? What are all of the...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

pleass hslp ms on hos to complete this assignment with the steps i also attached Font 10 N Company Name Actual Expenses Sheet First Two Quarters of 2021 February June Trends May Total lan Percent of...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

The integral xa dx converges when a

Brando has two children from his previous marriage; Norman who is 5 years old and Kristina who is 8. They live with their mother Marie, Brando's estranged first wife. Brando pays Marie $550 a month...

21. Recently, European Union (EU) governments approved a five-year EU trade protection against grain-oriented electrical steel (GOES) from Russia, Japan, China, South Korea, and the United States....

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...