Логички и физички дизајн
Релациска шема (со мапирачка трансформација)
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 скрипта за бришење и креирање на табелите
DML скрипта за полнење на табелите со податоци
Релациски дијаграм
Last modified
7 months ago
Last modified on 04/10/24 19:41:17
Attachments (5)
- kreiranje_v1.sql (5.6 KB ) - added by 9 months ago.
- polnenje_v1.sql (4.9 KB ) - added by 9 months ago.
- schema_v1.jpg (113.7 KB ) - added by 9 months ago.
- schema_v2.jpg (113.7 KB ) - added by 9 months ago.
- kreiranje_v2.sql (5.7 KB ) - added by 7 months ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.