Store and Owner Registration

Authors: Registered Boss

1. The user selects the option to register as a store owner.

2. The system displays a registration form for personal and store data.

3. The user submits personal information.

4. The application inserts a new record into the personal table.

INSERT INTO personal (id, first_name, last_name, ssn, email, password) VALUES 
('0010001', 'Anna', 'Ivanova', '1234567890123', 'anna@store.com', 'hashed_pw');

5. The application registers the user as a boss in boss.

INSERT INTO boss (boss_ID) VALUES 
('0010001');

6. The boss is assigned to work in the store via works_in_store.

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

7. The application creates a new store entry in store.

INSERT INTO store (store_ID, name, date_of_founding, physical_address, store_email) VALUES 
('001', 'HandCraft001', '2024-01-01', 'st.Main num.5, Skopje 1000, MK', 'store001@shop.com');