Store and Owner Registration

Authors: Registered Boss

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

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

The user submits personal information.

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');

The application registers the user as a boss in boss.

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

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
');