image: multi-valued attribute

video: multi-valued attribute

likesCount: single-valued attribute

timestamp: single-valued attribute

UserLogin (login ID, loginUserName, loginPassword)

UserLikes (postID, userID)

UserProfile has UserFriends (n:n)
UserProfile has UserPost (1:n). UserPost will always be associated with a UserProfile, therefore total participation.
UserProfile has UserLogin (1:1)
UserProfile has UserLikes (1:n). UserLikes will always be associated with a UserProfile, therefore total participation.
UserFriends have UserPost (1:n). UserPost will always be associated with a UserProfile, therefore total participation.
UserFriends has UserLogin (1:1)
UserFriends has UserLikes (1:n). UserLikes will always be associated with a UserProfile, therefore total participation.

User Profile:
- Attributes: User ID (Primary Key), Username (Composite Attribute), Email, Profile Picture, DOB (Stored Attribute), Age (Derived Attribute).
- Relationships:
  - User Login: One-to-one. Each user profile is associated with one login.
  - User Posts: One-to-many. A user can create multiple posts, but each post is associated with one user.
  - User Likes: One-to-many. A user can like many posts, but each like is associated with one user.
  - User Friends: Many-to-many. Users can follow multiple other users, and multiple other users can follow each user.
User Friends:
- Attributes: Follower ID (Primary Key), Follower Name, User ID (Foreign Key).
- Relationships:
  - User Posts: Many-to-many. Users can view posts from the users they follow.
  - User Login: One-to-one. Each friend must log in using their unique credentials.
  - User Likes: One-to-many. Friends can like posts from other users.
User Posts:
- Attributes: Post ID (Primary Key), Caption, Image (Multivalued Attribute), Video (Multivalued Attribute), Likes Count, Timestamp.
- Relationships:
  - User Likes: One-to-many. A post can receive multiple likes from different users.
User Login:
- Attributes: Login ID (Primary Key), Username, Password (Multivalued Attribute).
- Relationships:
  - User Profile: One-to-one. Each user login is tied to a unique user profile.
User Likes:
- Attributes: Post ID (Primary Key), User ID (Foreign Key).
- Relationships:
  - User P