| | 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 | |
