SQL Server 2008 (3)

Common terminology for database tables

Relationship--that is, a two-dimensional table. Each relationship has a relationship name, which is the table name

Domain: Range of values

Record--line

Fields, properties--Columns

Association--the way that data between tables in a database is connected to each other

Keyword: A combination of attributes or attributes that uniquely identifies a record

External keywords: If a field in a table is not a keyword for this table, it is a keyword for another table, called an external keyword

Data redundancy: Duplicate data in a data table

Data integrity: Data Consistency (date-date strings are not consistent, data integrity is compromised)

Insert exception

Update exception

Delete exception