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 NAME:
TABLE ATTRIBUTES: column1, column2, column3
FOREIGN KEYS: column1 to .column1