Question

SQL problem solving help; First 3 tables are finnished; Need help understanding on how to do steps after.

First 3 tables are after the first 2 images for reference if needed.

PROBLEM SOLVING EXERCIO Ex4A-1. Create a table kr_customer with ate a table kr_customer with the following attributes as shown below. Status | Name Jackie Foods Tom Construction Indie Professional City Memphis Kansas City Memphis Name attribute is the primary key of the table. Choose appropriate data types for attributes. EX4A-2. Create a table kr salesperson with the following attributes as shown below. Name Tom Selleck Jeremy Mack Anita Raina Kerry Kao Age Salary Salary 40 50150 35 100300 38 65500 28 35600 45110500 Joe Walton Name attribute is the primary key of the table. Choose appropriate data types for attributes.

//1//
CREATE TABLE kr_customer (

Name VARCHAR(40) NOT NULL PRIMARY KEY,

City VARCHAR(20),

Status CHAR(1)

);

//2//

CREATE TABLE kr_salesperson (

Name VARCHAR(40) NOT NULL PRIMARY KEY,

Age INT,

Salary DECIMAL(8, 2)

);

//3//

CREATE TABLE kr_order (

Order_Number number(3) NOT NULL PRIMARY KEY,

Customer_Name VARCHAR(40),

Salesperson_Name VARCHAR(40),

Amount DECIMAL(5, 2),

FOREIGN KEY (Customer_Name) References kr_customer(Name),

FOREIGN KEY (Salesperson_Name)References kr_salesperson(Name)

);

Answer 1

Following is the script which can be used to insert the values in the above-made tables.

INSERT INTO kr_customer (Name, City, Status)
VALUES ('Jackie Foods', 'Memphis', 'P');
INSERT INTO kr_customer (Name, City, Status)
VALUES ('Tom Construction', 'Kansas City', 'R');
INSERT INTO kr_customer (Name, City, Status)
VALUES ('Indie Professional', 'Memphis', 'P');

INSERT INTO kr_salesperson (Name, Age, Salary)
VALUES ('Tom Selleck', 40, 50150);
INSERT INTO kr_salesperson (Name, Age, Salary)
VALUES ('Jeremy Mack', 35, 100300);
INSERT INTO kr_salesperson (Name, Age, Salary)
VALUES ('Anita Raina', 38, 65500);
INSERT INTO kr_salesperson (Name, Age, Salary)
VALUES ('Kerry Kao', 28, 35600);
INSERT INTO kr_salesperson (Name, Age, Salary)
VALUES ('Joe Walton', 45, 110500);

INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (100, 'Jackie Foods', 'Anita Raina', 700);
INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (200, 'Indie Professional', 'Tom Selleck', 1200);
INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (300, 'Tom Construction', 'Joe Walton', 1500);
INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (400, 'Jackie Foods', 'Tom Selleck', 850);
INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (500, 'Indie Professional', 'Jeremy Mack', 455);
INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (600, 'Jackie Foods', 'Joe Walton', 1500);
INSERT INTO kr_order (Order_Number, Customer_Name, Salesperson_Name, Amount)
VALUES (700, 'Tom Construction', 'Anita Raina', 860);

Being a Chegg expert, I am obliged to do only one question at a time.
I hope you understand.
Thanks