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

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


Play button


Play button




Click to flip

40 Cards in this Set

  • Front
  • Back
A named two-dimentional table of data
Primary key
An attribute (or combonation of attributes) that uniquely identifies each row in a relation
Composite key
A primary key that consists of more than one attribute
Foreign key
An attribute in a relation of a database that serves as the pimary key of another relation in the same database
A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown
Entity integrity rule
No primary key attribute (or component of a primary key attribute) can be null
Referential integrity constraint
A rule that states that either each foreign key value must match a primary key value in another relation or the foriegn key value must be null
Well-structured relation
A relation that contains minimal redundancy and allows users to insert, modify, and delete the rows in a table without errors or inconsistencies
An error or inconsistency that may result when a user attempts to update a table that contains redundant data. The three types of anomalies are insertion, deletion and modification
Recursive foreign key
A foriegn key in a relation that references the primary key values of that same relation
The process of decomposing relations with anomalies to produce smaller,well-structured relations
Normal form
A state fo a relation that results from applying simple rules regarding functional dependancies (or relationships between attributes) to that relation.
First Normal form
Any multivalue attributes have been removed, so there is a simgle value at the intersection of each row and column of the table
Second Normal form
Any partial functional dependencies have been removed
Third Normal form
Any transitive dependencies have been removed
Boyce-Codd normal form
Any remaining anomalies that result from finctional dependencies have been removed
Fourth normal form
Any multivalued dependencies have been removed
Fifth normal form
Any remaining anomalies have been removed
Functional dependency
A constraint between two attributes or two sets of attributes
The attribute on the left-hand side of the attow in a functional dependency
Two (or more) attributes having different names but the same meaning, as whne they describe the same characteristic of an entity (Student_ID and Student_No)
An alternative name used for an attribute
An attribute that may have more than one meaning (account could mean checking acct, savings acct, loan acct, etc.)
Enterprise key
A primary key whose value is qnique across all relations
Candidate key
An attribute, or combonation of attributes, that uniquely identifies a row in a relation
Partial functional dependency
A functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key)
Transitive dependency
A functional dpendency between two (or more) nonkey attributes
Relational DBMS (RDBMS)
A database management system that manages data as a collection of tables in which all data relationshops are represented by common value in related tables
Base table
A table in the relational data model containing the inserted raw data. Base tables correspond to the relations that are identified in the database's conceptual schema
Dynamic view
A virtual table that is created dynamically upon request by a user
Materialized view
Copes or replicas of data based on SQL queries created in the same manner as dynamic views
Referential integrity
An integrity constraint specifying that the value (or existence) of an attribute in one relation depends on the value (or existence) of a primary key in the same or another relation
A relational operation that causes two tables with a common domain to be combined into a single table or view
A join in which the joining condition is based on equality between values in the common columns. Common columns appear (redundantly) in the result table
Natural join
Same as equi-join except one of the duplicate columns is elimated in the result table
Outer join
A join in which rows that do not have matching values in common columns are nevertheless included in the result table
Switchboard Manager
A Microsoft Access tool that helps you create and customize a switchboard
Switchboard Items
A table created by the Switchboard Manager describing the command buttons on the switchboard
Default page, or main page
The switchboard page that will appear when you open the switchboard form
Ampersand & (in switchboard)
Creates a hot key