Please design a simple social media network that contains the following items: U
ID: 3869402 • Letter: P
Question
Please design a simple social media network that contains the following items: User Information, Relationship, Messages, Person’s Photos, and Person’s posts on their wall In the relationship, we use the following code for showing a relationship between to people: Status Codes Code Meaning 0 Pending 1 Accepted 2 Declined 3 Blocked Note: Using numbers instead of strings for representing status might speed up the database operations. In your group, you should accomplish the following options:
1- Draw an ERD for your database (Paper, MS Visio or anything is acceptable)
2-Show your tables and their fields
3-Use SQL commands to create your tables and their relationships
4-For each table, use number of constraints (Primary key, Foreign key, Unique, …)
5-Insert a few rows for each table
6-Suppose a person sends a friend request to someone else. What should be the SQL code for that? Moreover, write a line of code for the case that a person who received friendship request accepts it.
7-Write a code that a person posts a text on their wall.
8-Write a code for chatting between two people. Suppose user1 sends a text to user2. How this should be implemented using SQL codes? Assignment Regulation: For part #1 please use any software/tools (even pen and paper) to draw your ERD diagram. Then place it on your word document. Please take snapshots from your SQL Developer environment and copy your code in the provided word document for all the tables, queries, and all the needed commands.
Explanation / Answer
hello dear,
i have solution of you all of point but i am unable to send files to you and it is very long size of coding so unable to paste here please give me your email id so that i can send you my own created social networking site it is very good and sime you can edit it and add more features
unfortunately there is no option to add PHP files and .db file