Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

12/12/21 18:24:13 (3 years ago)

Author:

193038

Comment:

--

RelationalDesign

@@ -1 @@
-== Relational Design
+= Логички и физички дизајн
+
+== Релациска шема (со мапирачка трансформација) 
+
+•  Примарни клучеви - bold и underline
+•  Надворешни клучеви: bold и * до името на надворешниот клуч, во заграда табелата кон која покажува
+•  Останати атрибути: bold
+
+
+
+----
+
+
+''User''(**__user_id__, name, surname, email, username, password**)
+
+''Client''(**__client_number_id__**)
+
+''Shipping_employee''(**__shipping_employee_id__**)
+
+''Role''(**__id_role__**, **role_name, role_desc**)
+
+''Online_stores''(**__store_id__, name, web_address, phone_number, email, social_media**)
+
+''Shipping''(**__shipping_id__, location, date_from, date_to**)
+
+''Payment''(**__payment_id__, info**)
+
+''Category''(**__category_id__, category_name**)
+
+''Store_employee''(**__store_employee_id__**, store_id*(online_stores))
+
+''Catalogue''(**__catalogue_id__, catalogue_from, catalogue_to, type**, store_id*(online_stores))
+
+''Shopping_bag''(**__shopping_id__, order_date, shipping_date, modified,client_number_id***(client))
+
+''Product_in_store''(**__product_in_store_id__**, store_id*(online_stores), product_id*(product))
+
+''Product''(**__product_id__, name, in_store, size, color**, category_id*(category))
+
+''Price''(**__price_id__, price, price_from, price_to, product_in_store_id***(product_in_store))
+
+''Works_as''(**__id_role*__**(role), **__store_employee_id*__**(store_employee), **works_from**, **works_to**)
+
+''Carries''(**__shipping_employee_id*__**(shipping_employee), **__shipping_id*__**(shipping))
+
+''Exists''(**__catalogue_id*__**(catalogue),**__product_in_store_id*__**(product_in_store))
+
+''Order''(**__shopping_id*__**(shopping_bag), **__product_in_store_id*__**(product_in_store))