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

Релациска шема

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

---

• User(user_id, username, name_user, email, password, phone_number)
• Administrator(user_id*(user))
• Custimer(user_id*(user))
• Delivery Man(user_id*(user))
• Warehouseman(user_id*(user))
• Warehouse(warehouse_id, warehouse_location)
• Product(product_id, product_name, product_description)
• Manufacturer(manufacturer_id, manufacturer_name)
• Price(price_id, amount)
• Category(category_id, category_name)
• Vehicle(vehicle_id, vehicle_model)
• Delivery(delivery_id, delivery_status, delivery_address)
• Location(location_id, location_address)
• Review(review_id, review_rating, review_description)
• Order(order_id, order_status, order_date)
• Subcategory(subcategory_id, subcategory_name)
• Picture(picture_id, picture_filepath)

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

kreiranje

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

polnenje

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

schema​