Changes between Version 3 and Version 4 of LogicalPhysicalDesign

Timestamp:

12/22/25 15:56:20 (6 days ago)

Author:

221296

Comment:

--

LogicalPhysicalDesign

@@ -11 +11 @@
 
 1. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
-   * image (multi-valued attribute, see table **COLORS**)
-   * color (multi-valued attribute, see table **IMAGE**)
+    __id_user__*
 
-2. **IMAGE** (__**{{{product_code*}}}**__ (PRODUCT), __**{{{image}}}**__)
+2. **Instructor **(__'''UInstructor_ID'''__, '''Bio''', '''Expertise''')
 
-3. **COLOR** (**__{{{product_code*}}}__** (PRODUCT), **__{{{color}}}__**)   
+3. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')   
 
-4. **STORE** (**__{{{store_ID}}}__**, {{{name}}}, {{{date_of_founding}}}, {{{physical_address}}}, {{{store_email}}}, {{{rating}}})
+4. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-5. **PERSONAL** (**__{{{SSN}}}__**, **{{{name}}}**, ''{{{first_name}}}'', ''{{{last_name}}}'', {{{email}}}, {{{password}}})
-   * permissions (complex, multi-valued attribute, see table **PERMISSIONS**)
+5. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-6. **PERMISSIONS** (**__{{{personal_SSN*}}}__** (PERSONAL), **__{{{type}}}__**, {{{authorisation}}})
+6. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-7. **BOSS** (**__{{{boss_SSN*}}}__** (PERSONAL))
+7. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-8. **EMPLOYEES** (**__{{{employee_SSN*}}}__** (PERSONAL), {{{date_of_hire}}})
+8. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-9. **CLIENT** (**__{{{client_ID}}}__**, **{{{name}}}**, ''{{{first_name}}}'', ''{{{last_name}}}'', {{{email}}}, {{{password}}})
-   * delivery_address (multi-valued attribute, see table **DELIVERY_ADDRESS**)
+9. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-10. **DELIVERY_ADDRESS** (**__{{{client_ID}}}__** (CLIENT), **__{{{address}}}__**)
+10. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-11. **ORDER** (**__{{{order_num}}}__**,{{{client_ID*}}} (CLIENT), {{{quantity}}}, {{{status}}}, {{{last_date_mod}}}, {{{payment_method}}}, {{{discount}}})
+11. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-12. **REPORT** (**__{{{date}}}__**, **__{{{store_ID*}}}__** (STORE), {{{overall_profit}}}, {{{sales_trend}}}, {{{marketing_growth}}}, {{{owner_signature}}})
-    * monthly_profit (multi-valued attribute, see table **MONTHLY_PROFIT**)
+12. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-13. **MONTHLY_PROFIT** (**__{{{report_date*}}}__** (REPORT), **__{{{store_ID*}}}__** (REPORT), {{{month_and_year}}}, {{{profit}}})
+13. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
 
-14. **REQUEST** (**__{{{request_num}}}__**, {{{date_and_time}}}, {{{problem}}}, {{{notes_of_communication}}}, {{{costumer_satisfaction}}})
+14. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')