Database Design

You have been asked to design the following database diagram:

“We would like to store a list of user’s in the database with their corresponding network of friends, groups, as well as any messages which are swapped between them. A user consists of a username, password, first name, last name and profile picture. A message is a string. User’s can have many friends but usually start off with none or only 1 friend. A user can join or create a group and there can only be 1 creator for any group”

Please draw up a draft database schema for the above description with as much detail using the following annotation

TABLE ATTRIBUTES: column1, column2, column3
FOREIGN KEYS: column1 to .column1

Questions by AMBird


This Question is not yet answered!


Related Answered Questions


Related Open Questions