= Логички и физички дизајн == Релациска шема (мапирачка трансформација) * Примарни клучеви: bold и underline * Надворешни клучеви: bold и * до името на надворешниот клуч, во заграда табелата кон која покажува * Not null атрибути: bold ---- * User(**__User_id__, password**) * Admin(**__Admin_id__***(User)) * Seller_Admin(**__Seller_Admin_id__***(User),**Name,Surname,E-mail**, **User_id***(Admin), **Store_name***(Store)) * Distributor(**__Distributor_id__***(User),**Name, Surname, Contact_number**) * Client(**__User_id__***(User),**Name, Adress, Email) * Store(**__Store_name__,Location, Contact**) * Product (**__Prod_id__, Availability, Name, Price, Type, Description, quantity**, **Store_name***(Store)) * Delivery (**__Delivery_id__, Delivery_address, Date, Status**, **Distributor_id***(Distributor), **Client_id***(Client)) * Price_history (**__Price_history_id__, Dates**, **Prod_id***(Product)) * Wishlist (**__Wishlist_id__** , **__Client_id__***(Client)) * Cart(**__Cart_id__, **Client_id***(Client)) * Order (**__Order_id__, Total_price, Order_status**, **Delivery_id***(Delivery), **Client_id***(Client)) * Configuration (**__Config_id__, Name, Price, Type**) * Payment (**__Payment_id__, CreditCard_number**, **Order_id***(Order)) * view_product (**__Client_id__***(Client), **__Prod_id__***(Product), **Time_stamp**) * updates (**__Prod_id__***(Product), **__Seller_Admin_id__***(Seller_Admin), **Time_stamp**) * manages_configuration (**__Config_id__***(Configuration),** __Admin_id__***(Admin)) * contains_product (**__Prod_id__***(Product), **__Cart_id__***(Cart)) * contains_config (**__Config_id__***(Configuration),** __Cart_id__***(Cart)) * current_price (**__Price_history_id__***(Price_history), **__Order_id__***(Order), **num_products**) * orders_configuration (**__Order_id__***(Order), **__Config_id__***(Configuration)) * product_to_wishlist (**__Prod_id__***(Product), **__Wishlist_id__***(Wishlist)) * config_to_whishlist(**__Config_id__***(Configuration), **__Wishlist_id__***(Wishlist)) * checkout(**__Cart_id__***(Cart), **__Order-id__***(Order)) * config_contains_product(**__Prod_id__***(Product), **__Config_id__***(Configuration), **num_products_config**) == DDL скрипта за бришење на табелите и креирање на табелите '''[attachment:kreiranje.sql]''' == DML скрипта за полнење на табелите со податоци '''[attachment:polnenje.sql]''' == Релациски дијаграм од DBeaver [[Image(DDL3.2.png)]]