== 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.

{{{#!sql
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}}}.

{{{#!sql
INSERT INTO boss (boss_ID) VALUES 
('0010001');

}}}

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

{{{#!sql
INSERT INTO works_in_store (personal_ID, store_ID) VALUES 
('0010001', '001');

}}}


**7.** The application creates a new store entry in {{{store}}}.

{{{#!sql
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');

}}}