• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
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

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/19

Click to flip

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