Microsoft Office Tutorials and References
In Depth Information
Appendix Summary
Review
In this appendix, you learned about tables and their characteristics, keys (primary, candidate,
alternate, composite, and foreign), relationships (one-to-many, many-to-many, one-to-one,
and entity subtypes), entity-relationship diagrams, integrity constraints (entity, referential,
and domain), dependencies and determinants, and anomalies. You also learned how to
design a database using normalization to place all tables in third normal form. Finally, you
learned about natural, artificial, and surrogate keys, and you examined naming conventions.
Key Terms
alternate key
anomalies
artificial key
attribute
Boyce-Codd normal
form (BCNF)
bubble diagram
candidate key
cascades
composite entity
composite key
concatenated key
data model diagram
data redundancy
database design
deletion anomaly
determinant
domain
domain integrity constraint
entity
entity integrity constraint
entity subtype
entity-relationship
diagram (ERD)
field
field name
first normal form (1NF)
foreign key
functional dependency
diagram
insertion anomaly
integrity
integrity constraint
intelligent key
intersection table
junction table
link table
logical key
many-to-many
relationship (M:N)
natural key
nonkey field
normal forms
normalization
null
nullifies
one-to-many
relationship (1:M or 1:N)
one-to-one relationship (1:1)
partial dependency
primary key
primary table
record
referential integrity
related table
relation
relational database
repeating group
restricted
second normal form (2NF)
semantic object modeling
surrogate key
synthetic key
table
third normal form (3NF)
transitive dependency
tuple
unnormalized relation
update anomaly
Search JabSto ::




Custom Search