wiki:RelationalDesign

Version 4 (modified by 201171, 8 months ago) ( diff )

--

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

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

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

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

Attachments (5)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.