Changes between Version 15 and Version 16 of Normalization


Ignore:
Timestamp:
02/04/26 00:43:00 (5 days ago)
Author:
233144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Normalization

    v15 v16  
    12341234|| Cooler_Cpu_Sockets || Composite || 0 attributes || NO || ✓ IN 3NF ||
    12351235
     1236== BCNF Analysis
     1237
     1238|| Relation =||= Primary Key =||= FD =||= Determinant =||= Is Determinant a CK? =||= Dependent Attributes =||= BCNF Satisfied =||
     1239|| Cpu || component_id || FD4 || component_id || YES (PK) || cpu_socket, cpu_cores, cpu_threads, cpu_base_clock, cpu_boost_clock, cpu_tdp || ✓ YES ||
     1240|| Gpu || component_id || FD5 || component_id || YES (PK) || gpu_vram, gpu_tdp, gpu_base_clock, gpu_boost_clock, gpu_chipset, gpu_length || ✓ YES ||
     1241|| Memory || component_id || FD6 || component_id || YES (PK) || memory_type, memory_speed, memory_capacity, memory_modules || ✓ YES ||
     1242|| Storage || component_id || FD7 || component_id || YES (PK) || storage_type, storage_capacity, storage_form_factor || ✓ YES ||
     1243|| Power_Supply || component_id || FD8 || component_id || YES (PK) || power_supply_type, power_supply_wattage, power_supply_form_factor || ✓ YES ||
     1244|| Motherboard || component_id || FD9 || component_id || YES (PK) || motherboard_socket, motherboard_chipset, motherboard_form_factor, motherboard_ram_type, motherboard_num_ram_slots, motherboard_max_ram_capacity, motherboard_pci_express_slots || ✓ YES ||
     1245|| Pc_Case || component_id || FD10 || component_id || YES (PK) || pc_case_cooler_max_height, pc_case_gpu_max_length || ✓ YES ||
     1246|| Cooler || component_id || FD11 || component_id || YES (PK) || cooler_type, cooler_height, cooler_max_tdp_supported || ✓ YES ||
     1247|| Memory_Card || component_id || FD12 || component_id || YES (PK) || memory_card_num_slots, memory_card_interface || ✓ YES ||
     1248|| Optical_Drive || component_id || FD13 || component_id || YES (PK) || optical_drive_form_factor, optical_drive_type, optical_drive_interface, optical_drive_write_speed, optical_drive_read_speed || ✓ YES ||
     1249|| Sound_Card || component_id || FD14 || component_id || YES (PK) || sound_card_sample_rate, sound_card_bit_depth, sound_card_chipset, sound_card_interface, sound_card_channel || ✓ YES ||
     1250|| Cables || component_id || FD15 || component_id || YES (PK) || cables_length_cm, cables_type || ✓ YES ||
     1251|| Network_Adapter || component_id || FD16 || component_id || YES (PK) || network_adapter_wifi_version, network_adapter_interface, network_adapter_num_antennas || ✓ YES ||
     1252|| Network_Card || component_id || FD17 || component_id || YES (PK) || network_card_num_ports, network_card_speed, network_card_interface || ✓ YES ||
     1253
     1254|| Users || user_id || FD1 || user_id || YES (PK) || username, password, email || ✓ YES ||
     1255|| Admins || admin_user_id || FD2 || admin_user_id || YES (PK) || (none) || ✓ YES ||
     1256|| Components || component_id || FD3 || component_id || YES (PK) || component_name, component_brand, component_price, component_type, component_img_url || ✓ YES ||
     1257|| Build || build_id || FD18 || build_id || YES (PK) || build_user_id, build_name, build_created_at, build_description, build_total_price, build_is_approved || ✓ YES ||
     1258|| Review || review_id || FD22 || review_id || YES (PK) || review_build_id, review_user_id, review_content, review_created_at || ✓ YES ||
     1259
     1260|| Build_Component || (build_id, component_id) || FD19 || (build_id, component_id) || YES (PK) || build_component_num_components || ✓ YES ||
     1261|| Rating_Build || (build_id, user_id) || FD20 || (build_id, user_id) || YES (PK) || rating_build_value || ✓ YES ||
     1262|| Favorite_Build || (build_id, user_id) || FD21 || (build_id, user_id) || YES (PK) || (none) || ✓ YES ||
     1263|| Suggestions || suggestion_id || FD23 || suggestion_id || YES (PK) || suggestion_user_id, suggestion_admin_id, suggestion_link, suggestion_admin_comment, suggestion_description, suggestion_status, suggestion_component_type || ✓ YES ||
     1264
     1265|| Case_Storage_Form_Factors || (component_id, pc_case_storage_form_factor) || FD24 || (component_id, pc_case_storage_form_factor) || YES (PK) || pc_case_storage_num_slots || ✓ YES ||
     1266|| Case_Ps_Form_Factors || (component_id, pc_case_ps_form_factor) || FD26 || (component_id, pc_case_ps_form_factor) || YES (PK) || (none) || ✓ YES ||
     1267|| Case_Mobo_Form_Factors || (component_id, pc_case_mobo_form_factor) || FD25 || (component_id, pc_case_mobo_form_factor) || YES (PK) || (none) || ✓ YES ||
     1268|| Cooler_Cpu_Sockets || (component_id, cooler_cpu_socket) || FD27 || (component_id, cooler_cpu_socket) || YES (PK) || (none) || ✓ YES ||
     1269
    12361270== 6. Final BCNF Decomposed Schema
    12371271