Changes between Version 1 and Version 2 of Proof of 1N form

Timestamp:

01/27/26 23:35:10 (13 days ago)

Author:

213087

Comment:

--

Proof of 1N form

@@ -20 +20 @@
 
 -A relation is in 1NF if all attributes contain atomic values
+
+
 -No repeating groups or multivalued attributes exist
+
+
 -Each row is uniquely identifiable by a key
+
+
 
 The relation is decomposed based on entity responsibility while preserving all data.
@@ -38 +44 @@
 Justification:
 -All attributes are atomic
+
+
 -All attributes depend only on user_id
+
+
 -user_id uniquely identifies a system user
+
+
 -No repeating groups exist
 
@@ -61 +73 @@
 Justification:
 -Each wedding is uniquely identified by wedding_id
+
+
 -user_id represents ownership of the wedding
+
+
 -All non-key attributes depend solely on wedding_id
 
@@ -80 +96 @@
 Justification:
 -Venue attributes describe a single independent entity
+
+
 -Attributes are static and not dependent on other relations
+
+
 -venue_id uniquely identifies a venue
 
@@ -103 +123 @@
 Justification:
 -A booking represents a reservation of a venue for a specific wedding
+
+
 -booking_id uniquely identifies each reservation
+
+
 -All attributes depend directly on booking_id
+
+
 
 Conclusion: