| | 1 | == Store and Owner Registration |
| | 2 | |
| | 3 | === Authors: **Registered Boss** |
| | 4 | |
| | 5 | The user selects the option to register as a store owner. |
| | 6 | |
| | 7 | The system displays a registration form for personal and store data. |
| | 8 | |
| | 9 | The user submits personal information. |
| | 10 | |
| | 11 | The application inserts a new record into the {{{personal}}} table. |
| | 12 | |
| | 13 | |
| | 14 | {{{#!sql |
| | 15 | INSERT INTO personal (id, first_name, last_name, ssn, email, password) |
| | 16 | VALUES ('0010001', 'Anna', 'Ivanova', '1234567890123', 'anna@store.com |
| | 17 | ', 'hashed_pw'); |
| | 18 | |
| | 19 | }}} |
| | 20 | |
| | 21 | The application registers the user as a boss in {{{boss}}}. |
| | 22 | |
| | 23 | |
| | 24 | {{{#!sql |
| | 25 | INSERT INTO boss (boss_ID) |
| | 26 | VALUES ('0010001'); |
| | 27 | |
| | 28 | }}} |
| | 29 | |
| | 30 | The application creates a new store entry in {{{store}}}. |
| | 31 | |
| | 32 | |
| | 33 | {{{#!sql |
| | 34 | INSERT INTO store (store_ID, name, date_of_founding, physical_address, store_email) |
| | 35 | VALUES ('001', 'HandCraft001', '2024-01-01', |
| | 36 | 'st.Main num.5, Skopje 1000, MK', |
| | 37 | 'store001@shop.com |
| | 38 | '); |
| | 39 | |
| | 40 | }}} |