Changes between Version 29 and Version 30 of Normalization
- Timestamp:
- 04/27/26 03:06:09 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v29 v30 323 323 The resulting relations after the 3NF step are: 324 324 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) 329 329 330 330 `SubscriptionPlan`(plan_id, plan_name, price, duration_months, plan_description, access_type)
