Database Design and Development Flashcards
1
Q
What does a “flat file database” consist of?
A
A flat file database consists of one big table, with all the info inside it.
2
Q
What is an “insert anomaly”?
A
An insert anomaly occurs when information that needs to be added has to have extra information added into the database.
3
Q
What is a “delete anomaly”?
A
A delete anomaly occurs when you try to delete specific information but you would be forced into deleting all the info related to it.
4
Q
What is an “update anomaly”?
A
An update anomaly occurs when you try to update one specific bit of information, and if it’s located anywhere in the database you would have to update it there too to keep information consistent.
