Функциски зависности

Атрибутите 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 нормална форма бидејќи сите атрибути кои повлекуваат зависности се кандидати клучеви во соодветните табели и го задоволуваат условот за оваа нормална форма.