Question: The following table structure represents the data stored in a messaging app. Use that information to write the relational schema and create a set of

The following table structure represents the data stored in a messaging app. Use that information to write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes, and create new entities and attributes as necessary. If so, also explain your reasoning for the renaming and creation of attributes and entities. Attribute name Sample value Sample value Sample value tahir susan amir user_name user_password Cmk8uWuU9F X3Hf49ytbF alice, alyssa, andre user_friends kiara, malik, fahtima, amir tqmAmaZ43M susan, shen, mark, wenlan message_text Cool. That is awesome. Lol! Me too Where are you? message_from tahir susan amir message_to alice amir mark
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
