- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
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
|
