Year 12s: what will be the first way you research your future options? >>

Can someone help me with Databases?

Hello, i need some help on this topic. I need to identify problems in Databases, but i know very little of Databases.

The problems i have to do are
Changing of data types
Accidental deletions
Renaming of fields
Poor normalisation

Why do they occur and how can you prevent and solve them?

Thanks for any help.

Reply 1

Async

These problems listed are not the databases fault. It's the fault of the clueless developer.

Reply 2

mikeabc

One way is to come up with a design plan (erd) good enough to avoid these mistake in the first place.

For poor normalisation it is all in the repeating groups, for example having one whole table for student and courses. one student can take many courses (having student name listed down several times (not good), so you remove them to create 2 tables. one for student and one for course. Of course having any relationships as well (i.e foreign key so student id is a foreign key in the course table).

Hope it helps

As said above- it is to do with the developers.