MANAGEMENT INFORMATION SYSTEMS IS SUBJECT WAS UNSURE WHERE TO PUT IT.

1. If a DBMS enforces a DELETE CASECADE OPTION on the referential integrity constraint between SALES_REP and TERRITORY show the records in tables SALES_REP and TERRITORY after a user tries to delete the first record (1, Joe,E) from SALES_REP.

2. Display the ProductID, ProductName, ProductPrice, VendorName for all procuts. Sort the results by Product ID. (WRITE SQL queries that accompish this task.)

It's request that we write the query twice once by JOIN and once by SUBQUERY. This is what i wrote i'm not sure if it classifies for subquery or join but here it is.

SELECT ProductID, ProductName, ProductPrice,

FROM Product p, Category c,

WHERE p.CategoryID= c.CategoryID

AND c.CategoryName= Camping

ORDER BY ProductID;

Help on these two problems would be greatly appreciated :)

SALES REP TERRITORY SRIDSRName TerID TerID TerName oe Sue Meg Bob Joe Pat Lee Joe East West South North Central 3 5 8