Changes between Version 33 and Version 34 of Normalization


Ignore:
Timestamp:
05/04/26 11:21:43 (3 weeks ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v33 v34  
    192192From the initial set of functional dependencies, the attributes that are not functionally determined by any other attribute are:
    193193
     194These attributes do not appear on the right-hand side of any functional dependency, which means they cannot be derived from other attributes and must be included in every candidate key.
     195
    194196payment_id, ticket_id, category_id, attempt_id, certificate_id
    195197
    … …  
    199201
    200202attempt_id → quiz_id
     203
    201204quiz_id → lesson_id
     205
    202206lesson_id → module_id
     207
    203208module_id → course_id
    204209
    … …  
    211216Since there is no alternative determinant for any of these required attributes in the initial set of functional dependencies, there are no other candidate keys.
    212217
     218Therefore, based on the given functional dependencies and the analysis of attribute closures, K is the only minimal superkey, and thus the only candidate key of the universal relation R.
    213219=== Chosen primary key
    214220We select the candidate key above as the primary key of the initial de-normalized relation: