Question

Write a query to create the orders table with salesman_id as foreign key.

Answer 1

CREATE TABLE ORDER

(

SALESMAN_ID FOREIGN KEY

);

hope it's helpful.....

Answer 2

Answer:

Explanation:

CREATE TABLE order

(

column1    data_type[(size)] ,  

column2    data_type[(size)] ,

salesman_id INT FOREIGN KEY REFERENCES [primary_key_table] (column_list_of_primary_key_table)

);