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

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

Primary key: underline
Foreign key: *
not null: bold

---

• user_table(user_id, username, name_user, email, password, phone_number, user_id*(administrator))
• administrator(user_id*(user))
• customer(user_id*(user))
• delivery_man(user_id*(user))
• service_man(user_id*(user))
• warehouseman(user_id*(user))
• warehouse(warehouse_id, warehouse_location)
• vehicle(vehicle_id, vehicle_model, vehicle_service, delivery_man_id*(delivery_man))
• delivery(delivery_id, delivery_status, delivery_address, delivery_man_id*(delivery_man))
• review(review_id, review_rating, review_description, customer_id*(customer), product_id*(product))
• order_table(order_id, order_status, order_date, customer_id*(customer))
• category(category_id, category_name)
• subcategory(subcategory_id, subcategory_name, category_id*(category))
• manufacturer(manufacturer_id, manufacturer_name)
• product(product_id, product_name, product_description, product_price, product_image, manufacturer_id*(manufacturer), service_man_id*(service_man))
• vehicle_is_used_for_delivery(vehicle_id*(vehicle), delivery_id*(delivery))
• product_is_in_stock_in_warehouse(product_id*(product), warehouse_id*(warehouse),quantity)
• order_table_contains_product(order_id*(order_table), product_id*(product))
• product_is_in_category(product_id*(product), category_id*(category))

DDL скрипта за бришење и креирање на табелите

kreiranje​

DML скрипта за полнење на табелите со податоци

polnenje​

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