Employee Registration

Actors: Registered Boss

1. The boss selects “Add Employee”.

2. System opens form for entering employee's personal data.

3. Employee personal data is entered.

4. The application inserts the data into personal.

INSERT INTO personal (id, first_name, last_name, ssn, email, password) VALUES
('0010002', 'Marko', 'Petrov', '9876543210123', 'marko@store.com', 'hashed_pw');

5. The employee is registered in employees.

INSERT INTO employees (employee_ID, date_of_hire) VALUES
('0010002', CURRENT_DATE);

6. The employee is assigned to a store via works_in_store.

INSERT INTO works_in_store (personal_ID, store_ID) VALUES 
('0010002', '001');