Submitting a Custumer Request

Actors: Registered Shopper

1. The user submits a customer request to a specific store.

2. The request is stored in request.

INSERT INTO request (request_num, date_and_time, problem, customer_satisfaction) VALUES
('0010120241001', CURRENT_TIMESTAMP,'Military discount', -1);

3. The request is linked to the client in makes_request.

INSERT INTO makes_request (client_ID, request_num) VALUES 
(1001, '0010120241001');

4. The request is assigned to the specific store via for_store.

INSERT INTO for_store (request_num, store_ID) VALUES
('0010120241001', '001');