Changes between Version 2 and Version 3 of DML final

Timestamp:

09/29/25 20:56:42 (3 weeks ago)

Author:

213231

Comment:

--

DML final

@@ -116 +116 @@
   FeedbackID integer PRIMARY KEY,
   CustomerID integer,
-  ProductID integer,
   Rating integer CHECK (Rating BETWEEN 1 AND 5),
   Comment text,
@@ -122 +121 @@
   TransactionID integer,
   CONSTRAINT feedback_customer_fk FOREIGN KEY (CustomerID) REFERENCES customer(CustomerID),
-  CONSTRAINT feedback_product_fk FOREIGN KEY (ProductID) REFERENCES product(ProductID),
   CONSTRAINT feedback_transaction_fk FOREIGN KEY (TransactionID) REFERENCES procurement(TransactionID)
 );
@@ -136 +134 @@
 );
 
-CREATE TABLE customer_product (
-  CustomerID integer NOT NULL,
-  ProductID integer NOT NULL,
-  CONSTRAINT customer_product_id PRIMARY KEY (CustomerID, ProductID),
-  CONSTRAINT customer_product_customer_fk FOREIGN KEY (CustomerID) REFERENCES customer(CustomerID),
-  CONSTRAINT customer_product_product_fk FOREIGN KEY (ProductID) REFERENCES product(ProductID)
-);
 
 CREATE TABLE product_maintenance (
@@ -159 +150 @@
   CONSTRAINT employee_maintenance_maintenance_fk FOREIGN KEY (MaintenanceID) REFERENCES maintenance(MainID)
 );
-
 }}}