HarryRocks
Badges: 0
Rep:
?
#1
Report Thread starter 4 years ago
#1
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.
0
reply
Async
Badges: 19
Rep:
?
#2
Report 4 years ago
#2
These problems listed are not the databases fault. It's the fault of the clueless developer.
0
reply
mikeabc
Badges: 2
Rep:
?
#3
Report 4 years ago
#3
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.
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • Cardiff Metropolitan University
    Undergraduate Open Day - Llandaff Campus Undergraduate
    Sat, 19 Oct '19
  • Coventry University
    Undergraduate Open Day Undergraduate
    Sat, 19 Oct '19
  • University of Birmingham
    Undergraduate Open Day Undergraduate
    Sat, 19 Oct '19

Why wouldn't you turn to teachers if you were being bullied?

They might tell my parents (26)
7.22%
They might tell the bully (34)
9.44%
I don't think they'd understand (55)
15.28%
It might lead to more bullying (139)
38.61%
There's nothing they could do (106)
29.44%

Watched Threads

View All