Changes between Version 29 and Version 30 of Normalization


Ignore:
Timestamp:
04/27/26 03:06:09 (5 days ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Normalization

    v29 v30  
    323323The resulting relations after the 3NF step are:
    324324
    325 `UserEntity`(user_id, first_name, last_name, email, password, role)
    326 `Users`(user_id)
    327 `Administrators`(admin_id, user_id)
    328 `Instructors`(instructor_id, user_id)
     325- `UserEntity`(user_id, first_name, last_name, email, password, role)
     326- `Users`(user_id)
     327- `Administrators`(admin_id, user_id)
     328- `Instructors`(instructor_id, user_id)
    329329
    330330`SubscriptionPlan`(plan_id, plan_name, price, duration_months, plan_description, access_type)