Facebook is one of the most popular social networks where users can post posts to different (text or image) and comment on them • Each user must register beforehand in order to use the system. The user is identified by a name, surname, date of birth, email address (which will also serve for authentication) and a password. • Any user can make a post which contains a text and/or image. Post is identified by a unique code, text used, an identification code for the image and date of post. • A user (including the author of the post) can comment on the post. The comment is characterized by an identification code, text, and date of post. Also, a user may like a comment or post. The system should keep track which user has liked the post/comment, etc. • Users can also exchange messages with each other. Each message is characterized from the unique code, text, date and time of sending as well as information if the recipient has seen the message or not. Write the rational schema, normalization - draw its dependency diagram and identify all dependencies, including all Partial and Transitive Dependencies.
Facebook is one of the most popular social networks where users can post posts to different (text or image) and comment on them • Each user must register beforehand in order to use the system. The user is identified by a name, surname, date of birth, email address (which will also serve for authentication) and a password. • Any user can make a post which contains a text and/or image. Post is identified by a unique code, text used, an identification code for the image and date of post. • A user (including the author of the post) can comment on the post. The comment is characterized by an identification code, text, and date of post. Also, a user may like a comment or post. The system should keep track which user has liked the post/comment, etc. • Users can also exchange messages with each other. Each message is characterized from the unique code, text, date and time of sending as well as information if the recipient has seen the message or not. Write the rational schema, normalization - draw its dependency diagram and identify all dependencies, including all Partial and Transitive Dependencies.
Step by step
Solved in 4 steps with 3 images
