||What is the relationship between table and entity?|
A table contains information about an entity. An entity can be a person, a thing, a place, or an event.
||What is NULL?|
NULL is a special value used to identify a missing value. You specify which columns can accept NULL values. Primary keys cannot contain NULLs.
||What are other names for record and field?|
Another name for record is row. Another name for field is column.
||True/False. A primary key can only contain one column.|
False. A primary key can contain many columns (in SQL Server, a primary key cannot exceed 256 bytes), although most tables have a primary key with a single column.
||What's a foreign key?|
|| A foreign key occurs when a table has a ...|
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.