Changes between Version 11 and Version 12 of Normalization
- Timestamp:
- 02/02/26 17:46:04 (6 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v11 v12 11 11 power_supply_type, power_supply_capacity, power_supply_form_factor, 12 12 motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots, 13 pc_case_coo oler_max_height, pc_case_gpu_max_length,13 pc_case_cooler_max_height, pc_case_gpu_max_length, 14 14 pc_case_storage_form_factor, num_slots 15 15 pc_case_ps_form_factor, … … 49 49 FD8: 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 50 50 51 FD9: component_id(pc_case) -> pc_case_coo oler_max_height, pc_case_gpu_max_length51 FD9: component_id(pc_case) -> pc_case_cooler_max_height, pc_case_gpu_max_length 52 52 53 53 FD10: component_id(cooler) -> cooler_type, cooler_height, cooler_max_tdp_supported … … 82 82 83 83 Right: 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_coo oler_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_type84 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_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 85 85 86 86 Attributes 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. … … 100 100 power_supply_type, power_supply_capacity, power_supply_form_factor, 101 101 motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots, 102 pc_case_coo oler_max_height, pc_case_gpu_max_length,102 pc_case_cooler_max_height, pc_case_gpu_max_length, 103 103 cooler_type, cooler_height, cooler_max_tdp_supported, 104 104 memory_card_num_slots, memory_card_interface, … … 160 160 motherboard_pci_express_slots 161 161 162 component_id -> pc_case_coo oler_max_height, pc_case_gpu_max_length162 component_id -> pc_case_cooler_max_height, pc_case_gpu_max_length 163 163 164 164 component_id -> cooler_type, cooler_height, cooler_max_tdp_supported, cooler_cpu_socket … … 212 212 R9 { 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 213 213 214 R10 { component_id, pc_case_coo oler_max_height, pc_case_gpu_max_length } where PK = component_id - BCNF214 R10 { component_id, pc_case_cooler_max_height, pc_case_gpu_max_length } where PK = component_id - BCNF 215 215 216 216 R11 { component_id, cooler_type, cooler_height, cooler_max_tdp_supported } where PK = component_id - BCNF … … 273 273 Motherboard { component_id, motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots } 274 274 275 Pc_Case { component_id, pc_case_coo oler_max_height, pc_case_gpu_max_length }275 Pc_Case { component_id, pc_case_cooler_max_height, pc_case_gpu_max_length } 276 276 277 277 Cooler { component_id, cooler_type, cooler_height, cooler_max_tdp_supported }
