Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
19 Cards in this Set
- Front
- Back
|
View
|
a users picture of that database - contains what they can see and access
|
|
|
defining query
|
indicates what to include in the view
|
|
|
How do you create a view?
|
Create a query - this is a view
|
|
|
index
|
computer generated field that iterates all the entries in a table
|
|
|
index key
|
field or group of fields upon which the index is built
|
|
|
Security
|
prevention of unauthorized users in the database
|
|
|
Integrity rules
|
Entity and Referential Integrity
|
|
|
Entity integrity
|
No field that is part of the primary key may accept null values
|
|
|
Referential integrity
|
If table A contains a foreign key that matches the primary key of table B, the values of this foreign key mus either match the primary key, or be null
|
|
|
Foreign Key
|
Field or collection of fields in a table whose value is required to match the value of the primary key for a second table
|
|
|
Legal-values integrity
|
No record can exist in the database with a value other than the legal values
|
|
|
validation rule
|
rule to determine which values are legal
|
|
|
validation text
|
text to inform the user of the reason for rejection of an invalid value
|
|
|
System catalog
|
Information about tables in the database
|
|
|
Systables
|
information about the tables known to SQL
|
|
|
Syscolumns
|
Information about the columns within the tables
|
|
|
Sysindexes
|
information about the defined indexes
|
|
|
Sysviews
|
Information about the views that have been created
|
|
|
Documenter
|
allows printing of documentation concerning objects in the database
|
