Relational Design

Notation

• Primary keys are bolded and underlined.
• Foreign keys are marked with * at the end of their name and the referenced entity is written in parentheses.
• Required (not optional) attributes are bolded.

Tables

1. Users (id, username, password, email)

2. Admins (user_id* (Users))

3. Components (id, name, brand, price, type, img_url)

4. CPU (component_id* (Components), socket, cores, threads, base_clock, boost_clock, tdp)

5. GPU (component_id* (Components), vram, tdp, base_clock, boost_clock, chipset, length)

6. Memory (component_id* (Components), type, speed, capacity, modules)

7. Storage (component_id* (Components), type, capacity, form_factor)

8. Power_Supply (component_id* (Components), type, wattage, form_factor)

9. Motherboard (component_id* (Components), socket, chipset, form_factor, ram_type, num_ram_slots, max_ram_capacity, pci_express_slots)

10. PC_Case (component_id* (Components), cooler_max_height, gpu_max_length)

11. Case_Storage_Form_Factors (case_id*(PC_Case), form_factor, num_slots)

12. Case_PS_Form_Factors (case_id*(PC_Case), form_factor)

13. Case_Mobo_Form_Factors (case_id*(PC_Case), form_factor)

14. Cooler (component_id* (Components), type, height, max_tdp_supported)

15. Cooler_CPU_Sockets (cooler_id*(Cooler), socket)

16. Memory_Card (component_id* (Components), num_slots, interface)

17. Optical_Drive (component_id* (Components), form_factor, type, interface, write_speed, read_speed)

18. Sound_Card (component_id* (Components), sample_rate, bit_depth, chipset, interface, channel)

19. Cables (component_id* (Components), length_cm, type)

20. Network_Adapter (component_id* (Components), wifi_version, interface, num_antennas)

21. Network_Card (component_id* (Components), num_ports, speed, interface)

22. Build (id, user_id* (Users), name, created_at, description, total_price, is_approved)

23. Build_Component (build_id*(Build), component_id*(Component))

24. Favorite_Build (build_id*(Build), user_id*(Users))

25. Rating_Build (build_id*(Build), user_id*(Users), value)

26. Review (id, build_id* (Build), user_id* (Users), content, created_at)

27. Suggestions (id, user_id* (Users), admin_id* (Admins), link, admin_comment, description, status, component_type)

DDL script for creating the database schema

schema_creation.sql​

DML script for filling tables with data

data_load.sql​

Relational diagram