Логички и физички дизајн

Релациска шема (мапирачка трансформација)

• Примарни клучеви: bold и underline
• Надворешни клучеви: bold и * до името на надворешниот клуч, во заграда табелата кон која покажува
• Not null атрибути: bold

---

Admin(user_id*(User))

Cart(Cart_id,Config_list, Product_list)

Checkout(cart_id*(Cart), Order-id*(Order))

Client(user_id*(User),Name, Adress, Email, Wishlist_id*(Wishlist))

Config_to_whishlist(Config_id*(Configuration), Wishlist_id*(Wishlist))

Configuration (Config_id, Name, Price, Type)

Contains (Prod_id*(Product), Config_id*(Configuration))

contains_config (Config_id*(Configuration), Cart_id*(Cart))

contains_product (Prod_id*(Product), Cart_id*(Cart))

current_price (Price_history_id*(Price_history), Order_id*(Order))

Delivery (Delivery_id, Delivery_address, Date, Status, User_id*(Distributor), User_id*(Client))

Distributor(user_id*(user),Name, Surname, Contact_number)

manages_configuration (Config_id*(Configuration), User_id*(Admin))

Order (Order_id, Total_price, Order_status, Delivery_id*(Delivery))

Orders_configuration (Order_id*(Order), Config_id*(Configuration))

Payment (Payment_id, CreditCard_number, Order_id*(Order))

Price_history (Price_history_id, Price_history_list, Dates, Prod_id*(Product))

Product (Prod_id, Availability, Name, Price, Type, Description, quantity, Store_name*(Store), Wishlist_id*(Wishlist))

Seller_Admin(user_id*(User),Name,Surname,E-mail, User_id*(Admin), Store_name*(Store))

Store(Store_name,Location, Contact)

updates (Prod_id*(Product), User_id*(Seller_Admin), Time_stamp)

User(User_id, password)

view_product (User_id*(Client), Prod_id*(Product), Time_stamp)

Whishlist (Wishlist_id, Config_list, Product_list)

Релациски дијаграм од DBeaver