How to construct the database needed in this project?

[JacobLiou]

while using correct connectionString, i cannnot build the correct database, tables etc...

[dxpux]

you can create an empty database, then run website, it will create tables.

[kfrancis]

You need to run update-database in your package manager console against the SocialGoal project

[sergiokml]

The class that determines how the database is created or updated is:

public class GoalsSampleData : CreateDatabaseIfNotExists<SocialGoalEntities> { }

https://www.entityframeworktutorial.net/code-first/database-initialization-strategy-in-code-first.aspx

In any case, you can go directly to the "Register" link to create a user.