Question

Create a table sales_man ( salesman_no primary key, s_name not null, place, phone unique)
Create table sales_order (order_no primary key
order_date not null
salesman_no foreign key references salesman_no in sales_man

Answer 1

Answer:

Here is your answer mate

Hope you this helps you

If really my answer helped so plz mark it as brainlist for me to let me know really that it helps!!

Answer 2

Step-by-step explanation:

Create a table sale_man ( salesman_no primary key, s_name not null, place, phone unique) Create table sales_order (order_no primary key order_date not null salesman_no foreign key references salesman_no in sales_man del_type values should be either P or F (check constraints) order_status values should be 'Inprocess','Fullfilled','Backorder', 'Cancelled' (check constraints)) a) Insert few records in both tables b) Delete primary key from sales_man table c) Delete Foreign key and Check constraints from sales_order table d) Add primary key in sales_man using ALTER TABLE e) Add foreign key and CHECK constraints in sales_order table using ALTER TABLE