Back to category: Technology

Limited version - please login or register to view the entire paper.

DATABASE CONCEPTS

Abstract
Understanding how databases work is an important process. Key elements of databases contain attribute, column, field, file, record, relation, row, table, and tuples. Deletion anomaly and Insertion anomaly can occur, but have since been eliminated. Binary relationships exist in databases. Domain Key / Normal Form is part of modern database Normalization. Parent / Child relationships exist as well as Strong / Weak relationships, Cardinality and Constraints.


DATABASE CONCEPTS
Learning how databases are built is an important lesson. You are better off teaching a man to fish than giving him fish. With that said, understanding database concepts will advance how we can apply our gained knowledge of databases.
Databases contain attribute, column, field, file, record, relation, row, table, and tuples. Attributes are columns of the table of the same type of information. An attribute of a table (Calendar) would contain entries like January, February, March, April, and s...

Posted by: Alyscia Yellowman

Limited version - please login or register to view the entire paper.