urgenttttt

- Each user must register beforehand in order to use the system. The user is identified by a name, surname, date of birth, e-mail address (which will also serve for authentication) and a password. - Any user can make a post which contains a text and / or an image. Post is identified by a unique code, the 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 the post. Also a user may like a comment or a post. The system should keep track which use has liked the post/comment eto. - 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 seer the message or not i) Using the business rules described above write the relational schema in 1NF, identify all primary keys and dependencies including all partial and transitive dependencies. (3 points) ii) Using the answer to i) remove all partial dependencies and write the relational schema in 2NF, by identifying in each case all primary keys and dependencies. (3 points) iii) Using the answer to ii) remove all transitive dependencies and write the relational schema in 3NF ( 3 points) iv) Using the results of iii) draw the Entity Relationship Diagram based on Chen's Notation. (3 points) v) Using the results of iii) draw the Entity Relationship Diagram based on Crow's Foot Notation, identifying the primary, foreign keys, the cardinality and ordinality of the relationships, ( 3 points)