Question: Part 1: q18 and q19 18. Provide the SQL code that will create the AGENT table. Use appropriate data types and define the Primary Key

Part 1: q18 and q19

Part 1: q18 and q19 18. Provide the SQL code that

18. Provide the SQL code that will create the AGENT table. Use appropriate data types and define the Primary Key and Foreign Keys. Syntax counts.

19. Provide the SQL code that will create the CUSTOMER table. Use appropriate data types and define the Primary Key and Foreign Keys. Syntax counts.

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!

Part B Database Implementation ( 3 5 marks ) In this part, you should develop a database based on your logical ERD developed in Part A . You must populate the tables with realistic sample data. Task...

This needs to be done in Oracle SQL Database thank you. = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Task 4 Create tables [ 1 5 marks ) Create the...

1. (Use AP) Write a SELECT statement that returns six columns from three tables, all using alias names: VendorName column named Vendor, InvoiceDate column named Date of Invoice (include the spaces),...

The medical sector depends critically on the proper and efficient management of patient data, test findings, and associated paperwork. In this day of digital revolution, medical lab operations must...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative 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...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

OVERVIEW This lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. In the FLIX2YOU product...

The Sarbanes- Oxley Act of 2002 generally prohibits public accounting firms from a. Acting in a managerial decision- making role for an audit client. b. Auditing the firms own work on an audit...

Ignacio,Inc.,hadafter-taxoperatingincomelastyearof$1,196,500.Three sources of nancing were used by the company: $2 million of mortgage bonds paying 4 percent interest, $4 million of unsecured bonds...

Which of the following statements is true of a standard costing system? a. It can only be used in organizations where there are homogeneous work units. b. It establishes price and quantity standards...

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,...

1. How can the Center justify accepting money from a person who has so aggressively championed the cause of the tobacco industry? The moral inconsistency seems too obvious to consider, but apparently...

' How could you now improve your negotiating performance? If you were to participate in the same negotiation again, what would you do differently?

' Were you able to find mutually beneficial options? If so, what were they?