Changes between Version 1 and Version 2 of RelationalDesign


Ignore:
Timestamp:
01/29/24 20:42:49 (8 months ago)
Author:
201171
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v1 v2  
    11= Логички и физички дизајн
    22
    3 === Релациска шема
     3=== Релациска шема (со мапирачка трансформација)
    44
    55> Primary key: __underline [[br]]
     
    99----
    1010
    11 * User('''__user_id__''', '''username''', '''name_user''', '''email''', '''password''', phone_number)
    12 * Administrator('''__user_id__'''*(user))
    13 * Custimer('''__user_id__'''*(user))
    14 * Delivery Man('''__user_id__'''*(user))
    15 * Warehouseman('''__user_id__'''*(user))
    16 * Warehouse('''__warehouse_id__''', '''warehouse_location''')
    17 * Product('''__product_id__''', '''product_name''', '''product_description''')
    18 * Manufacturer('''__manufacturer_id__''', '''manufacturer_name''')
    19 * Price('''__price_id__''', '''amount''')
    20 * Category('''__category_id__''', '''category_name''')
    21 * Vehicle('''__vehicle_id__''', '''vehicle_model''')
    22 * Delivery('''__delivery_id__''', '''delivery_status''', '''delivery_address''')
    23 * Location('''__location_id__''', '''location_address''')
    24 * Review('''__review_id__''', '''review_rating''', '''review_description''')
    25 * Order('''__order_id__''', '''order_status''', '''order_date''')
    26 * Subcategory('''__subcategory_id__''', '''subcategory_name''')
    27 * Picture('''__picture_id__''', '''picture_filepath''')
     11* user_table('''__user_id__''', '''username''', '''name_user''', '''email''', '''password''', phone_number '''user_id'''*(administrator))
     12* administrator('''__user_id__'''*(user))
     13* customer('''__user_id__'''*(user))
     14* delivery_man('''__user_id__'''*(user))
     15* service_man('''__user_id__'''*(user))
     16* warehouseman('''__user_id__'''*(user))
     17* warehouse('''__warehouse_id__''', '''warehouse_location''')
     18* vehicle('''__vehicle_id__''', '''vehicle_model''', '''vehicle_service''', '''delivery_man_id'''*(delivery_man))
     19* delivery('''__delivery_id__''', '''delivery_status''', '''delivery_address''', '''delivery_man_id'''*(delivery_man))
     20* review('''__review_id__''', '''review_rating''', '''review_description''', '''customer_id'''*(customer), '''product_id'''*(product))
     21* order_table('''__order_id__''', '''order_status''', '''order_date''', '''customer_id'''*(customer))
     22* category('''__category_id__''', '''category_name''')
     23* subcategory('''__subcategory_id__''', '''subcategory_name''', '''category_id'''*(category))
     24* manufacturer('''__manufacturer_id__''', '''manufacturer_name''')
     25* product('''__product_id__''', '''product_name''', '''product_description''', '''product_price''', '''product_image''', '''manufacturer_id'''*(manufacturer), '''service_man_id'''*(service_man))
     26* vehicle_is_used_for_delivery('''__vehicle_id__'''*(vehicle), '''__delivery_id__'''*(delivery))
     27* product_is_in_stock_in_warehouse('''__product_id__'''*(product), '''__warehouse_id__'''*(warehouse),'''quantity''')
     28* order_table_contains_product('''__order_id__'''*(order_table), '''__product_id__'''*(product))
     29* product_is_in_category('''__product_id__'''*(product), '''__category_id__'''*(category))
     30
    2831
    2932=== DDL скрипта за бришење и креирање на табелите
    30 > [attachment:kreiranje_v1.jpg kreiranje]
     33> [attachment:kreiranje_v1.sql kreiranje]
    3134=== DML скрипта за полнење на табелите со податоци
    32 > [attachment:polnenje_v1.jpg polnenje]
     35> [attachment:polnenje_v1.sql polnenje]
    3336=== Релациски дијаграм
    3437> [attachment:schema_v1.jpg schema]