Chapter 1, Problem 15E

Explanation of Solution

Tables used to store the information about the Facebook:

Generally in social networking site, the following are the tables that might be used to store the information about the user such as,

• User_account table
• User_friend table
• User_upload table
• User_preference table

User_account table:

This table is used to store the information about the user such as full name, login ID, password, age, gender, location, and so on.

User_friend table:

This table is used to store the information about the user friends whomever connected to the user and it stores the values about types of friends (such as school, friend, or family), login ID of friend...