Chapter 4 Database Design Using Normalization

Null Value

an attribute value that has never been supplied. Such values are ambiguous and can mean the a the value is unknown the value is not appropriate or the value is known to be blank

SQL COUNT(*) function

count all rows

Empty Set

in a SQL query, a query response that contains no records, in dictating that there is no data in the database that matches that query

SQL INSERT statment

put data in a table

SQL SELECT * statment

select all

SQL TOP {NumberOfRows} property

select the top (#) you what to see. Sample of data

SQL DROP TABLE statment

the SQL command used to remove a table form a database view

Denormalize

to intentionally create a set of database tables that are not normalized to BCNF and 4NF