Changes between Version 6 and Version 7 of Normalization

Timestamp:

01/28/26 02:52:32 (12 days ago)

Author:

233144

Comment:

--

Normalization

@@ -90 +90 @@
 Because the universal relation combines users, builds, components, reviews, and suggestions, a minimal key must uniquely identify all of them.
 
-The artifical candidate key is {user_id, build_id, component_id, review_id, suggestion_id}
-
-Universal relation primary key = {user_id, build_id, component_id, review_id, suggestion_id}
+The artifical candidate key is {user_id, build_id, component_id, review_id, suggestion_id, build_component_id}
+
+Universal relation primary key = {user_id, build_id, component_id, review_id, suggestion_id, build_component_id}
 
 == 1NF Decomposition