Changes between Version 6 and Version 7 of RelationalDesign

Timestamp:

09/22/26 08:44:38 (7 days ago)

Author:

235018

Comment:

--

RelationalDesign

@@ -94 +94 @@
     Note: This AI tool was picked based on a short research through a different AI tool. The log of that is shown here: https://www.perplexity.ai/search/if-i-were-to-give-100-same-que-26PSOT6DTwCmRZHhK5OYWA#2
 
-== Final result ==
+= Final result =
 
 === Tables ===
@@ -101 +101 @@
 
 1. **PRODUCT** (**__{{{code}}}__**, {{{price}}}, {{{availability}}}, **{{{dimensions}}}**, ''{{{weight}}}'', ''{{{width_X_length_X_depth}}}'', {{{aprox_production_time}}}, {{{description}}},
-**{{{cathegory_id*}}}** (CATEGORY), {{{store_ID*}}} (STORE))
+**{{{cathegory_id*}}}** (CATEGORY))
    * image (multi-valued attribute, see table **COLORS**)
    * color (multi-valued attribute, see table **IMAGE**)
@@ -114 +114 @@
    * permissions (complex, multi-valued attribute, see table **PERMISSIONS**)
 
-6. **PERMISSIONS** (**__{{{personal_ID*}}}__** (PERSONAL), **__{{{type}}}__**, {{{authorisation}}})
-
-7. **BOSS** (**__{{{boss_ID*}}}__** (PERSONAL), {{{signature}}})
+6. **PERMISSIONS** (**__{{{personal_ID*}}}__** (PERSONAL), {{{type}}}, {{{authorisation}}})
+
+7. **BOSS** (**__{{{boss_ID*}}}__** (PERSONAL))
 
 8. **EMPLOYEES** (**__{{{employee_ID*}}}__** (PERSONAL), {{{date_of_hire}}})
@@ -123 +123 @@
    * delivery_address (multi-valued attribute, see table **DELIVERY_ADDRESS**)
 
-10. **DELIVERY_ADDRESS** (**__{{{client_ID}}}__** (CLIENT), **__{{{address}}}__**, {{{city}}}, {{{postcode}}}, {{{country}}}, {{{is_default}}})
-
-11. **ORDER** (**__{{{order_num}}}__**,{{{client_ID*}}} (CLIENT), {{{quantity}}}, {{{status}}}, {{{last_date_mod}}}, {{{payment_method}}}, {{{discount}}})
-
-12. **REPORT** (**__{{{date}}}__**, **__{{{store_ID*}}}__** (STORE), {{{overall_profit}}}, {{{sales_trend}}}, {{{marketing_growth}}}, {{{owner_signature}}})
+10. **DELIVERY_ADDRESS** (**__{{{client_ID}}}__** (CLIENT), {{{address}}}, {{{city}}}, {{{postcode}}}, {{{country}}}, {{{is_default}}})
+
+11. **ORDER** (**__{{{order_num}}}__**, {{{status}}}, {{{last_date_mod}}}, {{{payment_method}}}, {{{discount}}})
+   * review (multi-valued attribute, see table **REVIEW**)
+   * refund (attribute, see table **REFUND**)
+
+12. **REVIEW** (**__{{{order_num*}}}__** (ORDER), {{{comment}}}, {{{rating}}}, {{{last_mod_date}}})
+
+13. **REFUND** (**__{{{refund_id}}}__**, {{{order_num*}}} (ORDER), {{{amount}}}, {{{reason}}}, {{{status}}})
+
+14. **REPORT** (**__{{{date}}}__**, **__{{{store_ID*}}}__** (STORE), {{{overall_profit}}}, {{{sales_trend}}}, {{{marketing_growth}}}, {{{owner_signature}}})
     * monthly_profit (multi-valued attribute, see table **MONTHLY_PROFIT**)
 
-13. **MONTHLY_PROFIT** (**__{{{report_date*}}}__** (REPORT), **__{{{store_ID*}}}__** (REPORT), {{{month_and_year}}}, {{{profit}}})
-
-14. **REQUEST** (**__{{{request_num}}}__**, {{{date_and_time}}}, {{{problem}}}, {{{notes_of_communication}}}, {{{costumer_satisfaction}}})
-
-15. **MAKES_REQUEST** (**__{{{client_ID*}}}__** (CLIENT), **__{{{order_num*}}}__** (ORDER))
-
-16. **ANSWERS** (**__{{{request_num*}}}__** (REQUEST), **__{{{personal_ID*}}}__** (PERSONAL))
-
-17. **FOR_STORE** (**__{{{request_num*}}}__** (REQUEST), **__{{{store_ID*}}}__** (STORE))
-
-18. **REVIEW** (**__{{{order_num*}}}__** (ORDER), {{{comment}}}, {{{rating}}}, {{{last_mod_date}}})
-
-19. **CHANGE** (**__{{{date_and_time}}}__**, **__{{{product_code*}}}__**  (PRODUCT), {{{changes}}})
-
-20. **MAKES_CHANGE** (**__{{{personal_ID*}}}__** (PERSONAL), **__{{{change_date_time*}}}__** (CHANGE))
-
-21. **MADE_ON** (**__{{{product_code*}}}__** (PRODUCT), **__{{{change_date_time*}}}__** (CHANGE))
+15. **MONTHLY_PROFIT** (**__{{{report_date*}}}__** (REPORT), **__{{{store_ID*}}}__** (REPORT), {{{month_and_year}}}, {{{profit}}})
+
+16. **REQUEST** (**__{{{request_num}}}__**, {{{date_and_time}}}, {{{problem}}}, {{{notes_of_communication}}}, {{{costumer_satisfaction}}})
+
+17. **MAKES_REQUEST** (**__{{{client_ID*}}}__** (CLIENT), **__{{request_num*}}}__** (REQUEST))
+
+18. **ANSWERS** (**__{{{request_num*}}}__** (REQUEST), **__{{{personal_ID*}}}__** (PERSONAL))
+
+19. **FOR_STORE** (**__{{{request_num*}}}__** (REQUEST), **__{{{store_ID*}}}__** (STORE))
+
+20. **MAKES_CHANGE** (**__{{{personal_ID*}}}__** (PERSONAL), **__{{{product_code*}}}__** (PRODUCT), {{{date_and_time}}}, {{{changes}}})
+
+21. **ORDERS** (**__{{{client_ID*}}}__** (CLIENT), **__{{{order_num*}}}__** (ORDER))
 
 22. **WORKS_IN_STORE** (**__{{{personal_ID*}}}__** (PERSONAL), **__{{{store_ID*}}}__** (STORE))
@@ -154 +156 @@
 24. **SELLS** (**__{{{product_code*}}}__** (PRODUCT), **__{{{store_ID*}}}__** (STORE), {{{discount}}})
 
-25. **INCLUDES** (**__{{{order_num*}}}__** (ORDER), **__{{{product_code*}}}__** (PRODUCT))
+25. **INCLUDES** (**__{{{order_num*}}}__** (ORDER), **__{{{product_code*}}}__** (PRODUCT), {{{quantity}}})
 
 26. **APPROVES** (**__{{{boss_ID*}}}__** (BOSS), **__{{{report_date*}}}__** (REPORT), **__{{{store_ID*}}}__** (REPORT), {{{owner_signature}}})
@@ -160 +162 @@
 27. **EXCHANGES_DATA** (**__{{{report_date*}}}__** (REPORT), **__{{{store_ID*}}}__** (STORE), {{{monthly_profit}}}, {{{date}}}, {{{sales}}}, {{{damages}}})
 
-28. **REFUND** (**__{{{refund_id}}}__**, {{{order_num*}}} (ORDER), {{{amount}}}, {{{reason}}}, {{{status}}})
 
 === DDL Final Script ===
@@ -173 +174 @@
 = DBeaver Final Diagram =
 
-[[Image(final-handcrafts-marketplace-with-help-of-AI-after-corections-edit4.1.png)]]
+[[Image(final-handcrafts-marketplace-with-help-of-AI-after-corections-edit5.png)]]