Changes between Version 4 and Version 5 of UseCase001
- Timestamp:
- 05/12/26 23:35:49 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase001
v4 v5 10 10 11 11 {{{#!div style="text-align: justify; width: 100%;" 12 1.User provides their required registration details, including a {{{email}}}, {{{password}}} and {{{username}}}, and submits the registration form.12 **1.** User provides their required registration details, including a {{{email}}}, {{{password}}} and {{{username}}}, and submits the registration form. 13 13 14 2.System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards.14 **2.** System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards. 15 15 16 {{{#!div style="margin-left: 20px;" 16 17 {{{ 17 18 SELECT COUNT(*) … … 19 20 WHERE email = 'user@example.com'; 20 21 }}} 22 }}} 21 23 22 3.System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}.24 **3.** System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}. 23 25 24 26 {{{ … … 27 29 }}} 28 30 29 4.System initializes a corresponding entry in the {{{Consumer table}}}, setting the {{{points_collected}}} to zero and establishing the one-to-one relationship with the new {{{user_id}}}.31 **4.** System initializes a corresponding entry in the {{{Consumer table}}}, setting the {{{points_collected}}} to zero and establishing the one-to-one relationship with the new {{{user_id}}}. 30 32 31 33 {{{ … … 34 36 }}} 35 37 36 5.System confirms the successful account creation and automatically logs the user in.38 **5.** System confirms the successful account creation and automatically logs the user in. 37 39 }}}
