27XbNDD6

1DROP TABLE IF EXISTS ShoppingCart;
2create table ShoppingCart (
3	customerNumber int,
4    productCode varchar(15),
5    quantity int NOT NULL,
6    dateAdded datetime default NOW(),
7    constraint pk_shoppingcart primary key(CustomerNumber, productcode),
8	constraint ck_quant check(quantity > 0),
9    constraint fk_cust_cust foreign key (customernumber) references customers(customernumber),
10    constraint ck_cart_prod foreign key (productcode) references products(productcode)
11);
12
13select * from customers;
14select * from products;
15select quantity from ShoppingCart where customerNumber=103 and productCode='S10_1678';