A retailer maintains a database with four tables: Customers,…
A retailer maintains a database with four tables: Customers, DealershipInfo, SaleTransactions, and ProductList. The Entity Relationship Model (ERM) below illustrates the primary and foreign key relationships among the four database tables. Each table is accompanied by a detailed schema that lists attribute names along with their corresponding data types. In the diagram, a gold key icon identifies the primary key of a table, while a silver key icon marks a foreign key, representing referential connections to related entities. Suppose a product (product_id=5) was discontinued: Complete the query below to enable deletion of all records associated with that product ID across the entire database (let’s assume the existing foreign key constraint has been removed): ALTER TABLE salestransactions ADD CONSTRAINT fk_product_trnFOREIGN KEY (product_id) REFERENCES __(1)__ ( product_id ) ___(2)____;