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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!