I'm really new to making databases, so I apologize if I say something really ... stupid.
I know that you're supposed to normalize your database, but I was wondering how far you should go.
For example: If I make a school database and in the student table I create a field called "Address", should that address be in a different table?
First rule is that no data should be repeated, right? So that means if that student has a sibling, they will also have the same address.
However, does that make it more difficult later on when doing data entry? I mean, you would need to enter the address before you can enter in the student's name.
I've been trying to figure out this type of problem for some time now and I keep going around in circles with it! Like I said before, I'm really new to all this.
I know that you're supposed to normalize your database, but I was wondering how far you should go.
For example: If I make a school database and in the student table I create a field called "Address", should that address be in a different table?
First rule is that no data should be repeated, right? So that means if that student has a sibling, they will also have the same address.
However, does that make it more difficult later on when doing data entry? I mean, you would need to enter the address before you can enter in the student's name.
I've been trying to figure out this type of problem for some time now and I keep going around in circles with it! Like I said before, I'm really new to all this.