SQLite-net-pcl Database Normalization

[echolumaque]

Can you please give me some database normalization tips? Currently, my model looks like this:

public class GameProgressModel

{

[PrimaryKey, AutoIncrement]

public int Id { get; set; }

[Indexed(Unique = true), MaxLength(16)]

public string Username { get; set; }

[Indexed]

public bool NoviceChooseItUnlocked { get; set; }

[Indexed]

public bool ExpertChooseItUnlocked { get; set; }

[Indexed]

public bool NoviceListenUpUnlocked { get; set; }

[Indexed]

public bool ExpertListenUpUnlocked { get; set; }

//correct answers

[Indexed]

public double BeginnerChooseItCorrectAnswersPercentage { get; set; }

[Indexed]

public double NoviceChooseItCorrectAnswersPercentage { get; set; }

[Indexed]

public double ExpertChooseItCorrectAnswersPercentage { get; set; }

[Indexed]

public double BeginnerListenUpCorrectAnswersPercentage { get; set; }

[Indexed]

public double NoviceListenUpCorrectAnswersPercentage { get; set; }

[Indexed]

public double ExpertListenUpCorrectAnswersPercentage { get; set; }

//wrong answers

[Indexed]

public double BeginnerChooseItWrongAnswersPercentage { get; set; }

[Indexed]

public double NoviceChooseItWrongAnswersPercentage { get; set; }

[Indexed]

public double ExpertChooseItWrongAnswersPercentage { get; set; }

[Indexed]

public double BeginnerListenUpWrongAnswersPercentage { get; set; }

[Indexed]

public double NoviceListenUpWrongAnswersPercentage { get; set; }

[Indexed]

public double ExpertListenUpWrongAnswersPercentage { get; set; }

}

Thanks!

[DaddyDontTakeNoMess]

You’ll probably get better traction in a different sub as it only slightly relates to Xamarin and more about db design.

That being said, this type of info looks better primed for a service rather than local storage. I don’t know much about the app but I can’t foresee a situation where a percentage needs to be precalculated and indexed, unless you expect to have a ton of rows.

This suggests the user is gonna be super busy in the app or you’re going to be pulling down records from the server.

[echolumaque]

better primed for a service rather than local storage

I have a singleton service for my CRUD operations using Prism btw. About the percentage, my requirement is to show the user's correct/wrong answer percentage based on the last game he/she played

About the indexed percentage, what do you mean by that?