Database Design

You have been asked to design the following database diagram:

We would like to store a list of users 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. Users 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