#database-normalization

[goodanswerbiz]

Resolved: First-time database design: am I overengineering? #answer #it #solution

Resolved: First-time database design: am I overengineering? #answer #it #solution

First-time database design: am I overengineering? Background

I’m a first year CS student and I work part time for my dad’s small business. I don’t have any experience in real world application development. I have written scripts in Python, some coursework in C, but nothing like this.

My dad has a small training business and currently all classes are scheduled, recorded and followed up via an…

View On WordPress

[sevennet-blog]

How to: Is storing a delimited list in a database column really that bad?

How to: Is storing a delimited list in a database column really that bad?

Is storing a delimited list in a database column really that bad?

Imagine a web form with a set of checkboxes (any or all can be selected). I chose to save them in a comma separated list of values stored in one column of the database table.

Now, I know that the correct solution would be to create a second table and properly normalize the database. It was quicker to implement the easy solution,…

View On WordPress

[sevennet-blog]

How to: First-time database design: am I overengineering?

First-time database design: am I overengineering? Background

I’m a first year CS student and I work part time for my dad’s small business. I don’t have any experience in real world application development. I have written scripts in Python, some coursework in C, but nothing like this.

My dad has a small training business and currently all classes are scheduled, recorded and followed up via an…

View On WordPress