Changes between Version 11 and Version 12 of Normalization


Ignore:
Timestamp:
02/02/26 17:46:04 (6 days ago)
Author:
233144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v11 v12  
    1111power_supply_type, power_supply_capacity, power_supply_form_factor,
    1212motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots,
    13 pc_case_coooler_max_height, pc_case_gpu_max_length,
     13pc_case_cooler_max_height, pc_case_gpu_max_length,
    1414pc_case_storage_form_factor, num_slots
    1515pc_case_ps_form_factor,
    … …  
    4949FD8: component_id(motherboard) -> motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots
    5050
    51 FD9: component_id(pc_case) -> pc_case_coooler_max_height, pc_case_gpu_max_length
     51FD9: component_id(pc_case) -> pc_case_cooler_max_height, pc_case_gpu_max_length
    5252
    5353FD10: component_id(cooler) -> cooler_type, cooler_height, cooler_max_tdp_supported
    … …  
    8282
    8383Right:
    84 username, password, email, component_name, brand, component_price, component_type, img_url, cpu_socket, cpu_cores, cpu_threads, cpu_base_clock, cpu_boost_clock, cpu_tdp, gpu_vram, gpu_tdp, gpu_base_clock, gpu_boost_clock, gpu_chipset, gpu_length, memory_type, memory_speed, memory_capacity, memory_modules, storage_type, storage_capacity, storage_form_factor, power_supply_type, power_supply_capacity, power_supply_form_factor, motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots, pc_case_coooler_max_height, pc_case_gpu_max_length, num_slots, pc_case_storage_form_factor, pc_case_ps_form_factor, pc_case_mobo_form_factor, cooler_cpu_socket, cooler_type, cooler_height, cooler_max_tdp_supported, memory_card_num_slots, memory_card_interface, optical_drive_form_factor, optical_drive_type, optical_drive_interface, optical_drive_write_speed, optical_drive_read_speed, sound_card_sample_rate, sound_card_bit_depth, sound_card_chipset, sound_card_interface, sound_card_channel, cables_length_cm, cables_type, network_adapter_wifi_version, network_adapter_interface, network_adapter_num_antennas, network_card_num_ports, network_card_speed, network_card_interface, build_name, build_created_at, build_description, build_total_price, build_is_approved, rating_build_value, review_content, review_created_at, suggestion_admin_id, suggestion_link, suggestion_admin_comment, suggestion_description, suggestion_status, suggestion_component_type
     84username, password, email, component_name, brand, component_price, component_type, img_url, cpu_socket, cpu_cores, cpu_threads, cpu_base_clock, cpu_boost_clock, cpu_tdp, gpu_vram, gpu_tdp, gpu_base_clock, gpu_boost_clock, gpu_chipset, gpu_length, memory_type, memory_speed, memory_capacity, memory_modules, storage_type, storage_capacity, storage_form_factor, power_supply_type, power_supply_capacity, power_supply_form_factor, motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots, pc_case_cooler_max_height, pc_case_gpu_max_length, num_slots, pc_case_storage_form_factor, pc_case_ps_form_factor, pc_case_mobo_form_factor, cooler_cpu_socket, cooler_type, cooler_height, cooler_max_tdp_supported, memory_card_num_slots, memory_card_interface, optical_drive_form_factor, optical_drive_type, optical_drive_interface, optical_drive_write_speed, optical_drive_read_speed, sound_card_sample_rate, sound_card_bit_depth, sound_card_chipset, sound_card_interface, sound_card_channel, cables_length_cm, cables_type, network_adapter_wifi_version, network_adapter_interface, network_adapter_num_antennas, network_card_num_ports, network_card_speed, network_card_interface, build_name, build_created_at, build_description, build_total_price, build_is_approved, rating_build_value, review_content, review_created_at, suggestion_admin_id, suggestion_link, suggestion_admin_comment, suggestion_description, suggestion_status, suggestion_component_type
    8585
    8686Attributes that never appear on the right side(only left) are component_id, review_id, suggestion_id. This means that they must be a part of the candidate key because nothing else can determine them.
    … …  
    100100power_supply_type, power_supply_capacity, power_supply_form_factor,
    101101motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots,
    102 pc_case_coooler_max_height, pc_case_gpu_max_length,
     102pc_case_cooler_max_height, pc_case_gpu_max_length,
    103103cooler_type, cooler_height, cooler_max_tdp_supported,
    104104memory_card_num_slots, memory_card_interface,
    … …  
    160160motherboard_pci_express_slots
    161161
    162 component_id -> pc_case_coooler_max_height, pc_case_gpu_max_length
     162component_id -> pc_case_cooler_max_height, pc_case_gpu_max_length
    163163
    164164component_id -> cooler_type, cooler_height, cooler_max_tdp_supported, cooler_cpu_socket
    … …  
    212212R9 { component_id, motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots } where PK = component_id - BCNF
    213213
    214 R10 { component_id,  pc_case_coooler_max_height, pc_case_gpu_max_length } where PK = component_id - BCNF
     214R10 { component_id,  pc_case_cooler_max_height, pc_case_gpu_max_length } where PK = component_id - BCNF
    215215
    216216R11 { component_id, cooler_type, cooler_height, cooler_max_tdp_supported } where PK = component_id - BCNF
    … …  
    273273Motherboard { component_id, motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots }
    274274
    275 Pc_Case { component_id,  pc_case_coooler_max_height, pc_case_gpu_max_length }
     275Pc_Case { component_id,  pc_case_cooler_max_height, pc_case_gpu_max_length }
    276276
    277277Cooler { component_id, cooler_type, cooler_height, cooler_max_tdp_supported }