Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions