Study your flashcards anywhere!

Download the official Cram app for free >

  • 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/12

Click to flip

12 Cards in this Set

  • Front
  • Back
Every relation has
a name,
a set of attributes, and
each attribute associated with a domain.
Relation
An instance of a relation is a finite set of tuples.
Keys for a Relation
A minimal set of attributes whose values uniquely
identify a tuple in any instance of the relation. No proper
subsets of the attributes retain the property.
Types of Indexes
B-tree: Fits most common situations
Hash: Only handles equality comparisons
GiST: Generalized Search Tree is a balanced tree
structure
GIN: Generalized Inverted Index is designed for
composite value keys
Transaction
a single logical database operation.
ACID Properties of Relational Databases
Atomicity, Consistency, Isolation, Durability
Atomicity
Insert/update/delete is performed completely or not at all
Consistency
No part of a transaction can violate constraints
Isolation
Each application runs transactions independently
Durability
Completed transactions persist
SQL Savepoints
used to record intermediate points within a transaction, but before a commit.
RELEASE
has the effect of deleting the save point, but keeping results of the statements that followed.