DATA BASE

Draw an EER diagram that models the data described below.

Users have a (unique) username, password, name, address, and email. Posts are identified by a combination of the username of the user who created them, plus an ID value. We also store each posts title, text, time posted, and username for the user the post was directed at. Every post is written by one user to another. Users can create and receive multiple posts. Posts can be shared with any number of other users (i.e., users the post wasnt originally directed at). Some users may be banned from the site. In addition to the usual user information, we store a restoration date for users who are temporarily banned. We also store a link to the post that caused the user to be banned, for every banned user. Very few posts cause users to be banned. Users can be friends with other users. In addition to the users involved, we also store a relationship status (good, BFFs, its complicated, etc.). A single user may have many (or no) friends.