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

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;

30 Cards in this Set

  • Front
  • Back
DBMS
Database Management System
DML
Data-Manipulation Language
CLI
Call-Level Interface
metadata
the schema information for the database
PSM
Persistent Storage Manager
DDL
Data Definition Language

It is part of the SQL language responsible for defining and managing all objects in a database.
ACID
Atomicity: all-or-nothing execution of transations.
Consistency: constraints among data elements.
Isolation: each transaction must appear to execute with no other transactions.
Durability: the effect of a transaction must never be lost.
ODL
Object Definition Language
UML
Unified Modeling Language
DDL
Data Definition Language
what are are the Data Model definition and parts
a notion for describing data or information.

1. Structure of the data
2.Operations on the data
3. Constraints on the data
what does the relational data model allow us to do?
a way to represent data as a two-dimensional table called a relation.
What is relational algebra?
It is a formal system for manipulating relations.

* Operands are relations.
* Operations include the usual set and special operations defined for relations
-selection
-projection
-join
What is a Projection?
used to produce a new relation that has some of the original attributes.
What is a Selection?
The selection of tuples that meet the conditions of the select statement
What is a Join?
The result of the natural join is the set of all combinations of tuples in R and S that are equal on their common attribute names.

Theta-Join allows for pairing of relations with multiple conditions
What is a Cartesian Product?
is a result of adding the two relations together. the result is longer than the original relations because all tuples are from both relations are included in the product.
What is an attribute?
A column of a relation containing information specific to each tuple
What is a schema?
The name of a relation and the set of attributes for a relation.
What is a tuple?
a row containing one component for each attribute of a relation.
What is the role of the domain of an attribute?
To insure that each tuple component is of the proper data type. types must be atomic.
What is an instance of a relation?
A snapshot of the current state of the relation.
What is the key of a relation?
An attribute or set of attributes that are not the same for any tuple in a relation.
What is a constraint?
Constraints restrict the data that can be stored in relations. further restricting the domain of an attribute.
What is a referential integrity constraint?
Asserts that a value appearing in one context also appears in another, related context.
What is the other name given to referential integrity constraints?
Foreign key
What is a superkey?
A set of attributes that together make a key.
What is a key?
an attribute that functionally determines all other attributes of the relation.
Can a key be a superkey?
Yes
Can a superkey be used as a primary key? Why or why not?
Yes, the collection of attributes have no duplicated values. Therefore they can uniquely identify any tuple in the relation.