You have two tables in your database design: Customers, which lists all your customers, and Orders, which lists all the sales transactions that your customers have made over the years. The two tables each have a field called Customer$\_$ID$.$ Which of the following correctly describe the relationship between the two tables?

$1$ point

Both the Customer$\_$ID field in the Customers table and the Customer$\_$ID

field in the Orders table are Primary Keys.

The Customer$\_$ID field in the Customers table is a Primary Key and the

Customer$\_$ID field in the Orders table is a Foreign Key.

The Customer$\_$ID field in the Customers table is a Foreign Key and the

Customer$\_$ID field in the Orders table is a Primary Key.

Both the Customer$\_$ID field in the Customers table and the Customer$\_$ID

field in the Orders table are Foreign Keys.

$3.$

Question $3$

What is the SQL DDL command can be used for adding primary keys to an existing table in a database?

$1$ point

SQL QUERY

CREATE TABLE

UPDATE TABLE

ALTER TABLE

$4.$

Question $4$

What is the recommend SQL command for loading small to medium amounts of data into a database?

$1$ point

LOAD command

IMPORT command

LOAD or IMPORT $($there is no difference$)$