Relational Migration

Suppose that you work for a small social network startup. Due to the rapid increase in users and a demand for better analytics tools along with an increase in complaints due to data inconsistency, your company has decided to move from a document database into a relational database.

Currently, the application supports the following features:

• User Authentication
• Friends (i.e., connections in-between users)
• Interactions (example: likes)

Currently, in the document store, data is stored in a non-normalized manner. For example in the User entity:

{ 'userID':1,
	'firstName': 'John',
	'lastName': 'Doe',
	'friendsID': [2, 3, 4, 5],
	'postsID': [4, 12, 9, 10],
	'interaction': [{'type': 'like', 'id': 44}]
}

How would you approach this project?