Changes between Version 11 and Version 12 of Normalization

Timestamp:

03/09/22 00:28:13 (3 years ago)

Author:

193113

Comment:

--

Normalization

@@ -99 +99 @@
 R,,17,,(movie_id, person_id) \\
 
+Во приказ е дадено преименување на R во соодветни табели: \\
 
+R,,1,,(genre_id, genre_type) - Genres(genre_id, genre_type) \\
+R,,2,,(person_id, person_fullname, person_type, date_of_birth, person_image_url, person_description) - Persons(person_id, person_fullname, person_type, date_of_birth, person_image_url, person_description) \\
+R,,3,,(movie_id, movie_title, movie_description, movie_image_url, imdb_rating, airing_date) - Movies(movie_id, movie_title, movie_description, movie_image_url, imdb_rating, airing_date) \\
+R,,4,,(username, user_id, user_fullname, password, email) - Users(username, user_id, user_fullname, password, email) \\
+R,,5,,(user_id, person_id, person_stars_rated, person_reason) - Users_rate_persons(user_id, person_id, person_stars_rated, person_reason) \\
+R,,6,,(user_id, movie_id, movie_stars_rated, movie_reason) - Users_rate_movies(user_id, movie_id, movie_stars_rated, movie_reason) \\ 
+R,,71,,(discussion_id, discussion_text, discussion_title, discussion_date, movie_id, person_id) - Discussions(discussion_id, discussion_type, discussion_text, discussion_title, discussion_date, movie_id, person_id) \\
+R,,72,,(movie_id, discussion_type) - Movies_discussion_type(movie_id, discussion_type) \\
+R,,73,,(person_id, discussion_type) - Persons_discussion_type(person_id, discussion_type) \\
+
+R,,8,,(discussion_id, reply_id, reply_text, reply_date) - Replies(discussion_id, reply_id, reply_text, reply_date) \\
+R,,9,,(genre_id, movie_id) - Movies_from_genres(genre_id, movie_id) \\
+R,,10,,(genre_id, user_id) - Users_like_genres(genre_id, user_id) \\
+
+R,,11,,(user_id, movie_id) - Users_like_movies(user_id, movie_id) \\
+R,,12,,(user_id, discussion_id) - Users_like_discussions(user_id, discussion_id) \\ 
+R,,13,,(user_id, discussion_id, reply_id) - Users_like_replies(user_id, discussion_id, reply_id) \\
+R,,14,,(movie_id, person_id) - Person_is_director_in_movies(movie_id, person_id) \\
+R,,15,,(user_id, discussion_id) - Users_created_discussions(user_id, discussion_id) \\
+R,,16,,(user_id, discussion_id, reply_id) - Users_created_replies(user_id, discussion_id, reply_id)  \\
+R,,17,,(movie_id, person_id) - Persons_are_actors_in_movies(movie_id, person_id) \\