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

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

11. Case_Storage_Form_Factors (case_id, form_factor)

12. Case_PS_Form_Factors (case_id, form_factor)

13. Case_Mobo_Form_Factors (case_id, form_factor)

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

15. Cooler_CPU_Sockets (cooler_id, 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)

19. Sound_Card_Channels (sound_card_id, channel)

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

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

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

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

24. Build_Component (build_id, component_id)

25. Favorite_Build (build_id, user_id)

26. Rating_Build (build_id, user_id, value)

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

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

DDL script for creating the database schema

https://develop.finki.ukim.mk/projects/pc-forge/attachment/wiki/WikiStart/schema_creation.sql

DML script for filling tables with data

https://develop.finki.ukim.mk/projects/pc-forge/attachment/wiki/WikiStart/data_load.sql

Relational diagram