Changes between Version 1 and Version 2 of Normalization

Timestamp:

03/03/22 01:16:16 (3 years ago)

Author:

193113

Comment:

--

Normalization

@@ -1 @@
-== func
+== Функциски зависности
+ Атрибутите name и surname кај users се споени во user_fullname
+ Атрибутите name и surname кај  persons се споени во person_fullname
+
+FD = { movie_title -> movie_id, movie_title -> movie_description, movie_title -> movie_image_url, movie_title -> airing_date, movie_title -> imdb_rating, movie_title -> discussion_type,
+ movie_id -> movie_title, movie_id -> movie_description, movie_id -> movie_image_url, movie_id -> airing_date, movie_id -> imdb_rating, movie_id -> discussion_type,
+ user_id -> username, user_id -> user_fullname, user_id -> email, user_id -> password,
+ username -> user_id, username -> user_fullname, username -> email, username -> password,
+  email  -> user_id, email -> user_fullname, email -> username, email -> password,
+ person_id -> person_fullname, person_id -> person_type, person_id -> date_of_birth, person_id -> person_image_url, person_id -> person_description, person_id -> discussion_type,
+genre_id -> genre_type, genre_type -> genre_id,
+movie_id user_id -> movie_reason, movie_id user_id -> movie_stars_rated,
+person_id user_id -> person_reason, person_id user_id -> person_stars_rated,
+discussion_id -> discussion_type, discussion_id  -> discussion_text, discussion_id -> discussion_title, discussion_id -> date, discussion_id -> movie_id, discussion_id -> person_id,
+discussion_id reply_id -> reply_text, discussion_id reply_id -> reply_date, discussion_id reply_id -> user_id }
+
+== Нормална форма на актуелен дизајн
+
+Базата се наоѓа во BCNF нормална форма бидејќи сите атрибути кои повлекуваат зависности се кандидати клучеви во соодветните табели и го задоволуваат условот за оваа нормална форма.
+