Description

Instructions:
• Submit a text file or a pdf file with your answers. Name your file as last- nameFirstnameW6.fileExtension (e.g. chaturvediRituW6.pdf or chaturvediRituW6.txt).

1. Draw an ER diagram for a facebook database, given the following requirements:

A facebook user must have an account that stores the userid, name, email and phone number of the user. A user can have friends, who are also facebook users. Users can post messages and can like like posts of other facebook users. Each post has an id and its content.

2a. Given the constraints shown in the ER schema, respond to the following statements with True, False, or Maybe. Assign a response of Maybe to statements that, while not explicitly shown to be True, cannot be proven False based on the schema as shown. Justify each answer.

iv. A property can be sold by a minimum of 1 staff member and a maximum of M staff members.

2b. Convert the above ER model to a relational model. You must indicate the primary key and foreign key constraints.

4. Convert the following relational model to an ER model.