• 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

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/3

Click to flip

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;

3 Cards in this Set

  • Front
  • Back

Logical operators in database queries


< Less than


> Greater than


NOT


AND


OR


SELECT* FROM pets


WHERE Age < 7 AND Type NOT (Dog)

Primary and Foreign keys


Primary and Foreign keys are used to link related records in different tables.


Primary key is a unique identifier.


Foreign key is a value which is the primary key of a record in another table.

Data validation


Data validation is used to make sure the data entered meets set rules


Length check=Data entered is correct length eg 6 characters for a password


Format check=Data is in the correct format


Range check=Data is within a specific range eg age is between 1-150


Presence check=Data has been entered eg user must enter a password


Match checker=Data must be one of a number of specific options eg male or female

??