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;
20 Cards in this Set
- Front
- Back
Database |
Is a structure that contains different categories of information and the relationships between these categories. |
|
Database Design |
The process of determining the particular tables and columns that will comprise a database is known as a ___________.
|
|
Relational Database |
a database structured to recognize relations among stored items of information. |
|
Entity |
A _____ is like a noun; it is a person,place,thing. |
|
Attribute |
property/characteristic of a entity |
|
Relationship |
A ______ is the association between entities. |
|
Relation |
A ______ is a two -dimensional table in which the entries in the table contain only single values, each column has a distinct name, all values in a column, match this name, the order of the rows and columns is immaterial, and each row contains unique values. |
|
functional dependency
|
A_____________ is a constraint between two sets of attributes in a relation from a database. In other words, _________is a constraint that describes the relationship between attributes in a relation. |
|
Primary Key |
A unique identifier for a table. |
|
Candidate key |
A __________ is a column, or a set of columns in a table that can UNIQUELY identify a record within a database withoutreferring to any other data. |
|
Normalization |
A Process by which you identify the existence of potential problems, such as data duplication and redundancy , and implement ways to correct them. |
|
First normal form (1NF) |
Contains no repeating groups. |
|
Second normal form (2NF) |
Contains no partial dependencies |
|
Third normal form(3NF) |
Contains no Transitive dependencies |
|
Determinant |
Any column(or collection of columns) that determines another column is called a ________. |
|
Unnormalized relations |
The goal of normalization is to convert _______ (tables that satisfy the definition of a relation except that they might contain repeating groups)into various types of normal forms. |
|
Data redundancy |
_________ is when two or more pieces of the same data is held in two separate places. Occurs either by accident, but can also be done on purpose for back up and recovery reasons. |
|
Boyce-codd normal form |
_________normal form. |
|
Tuple |
A _____ is the same this as a record it is one row. |
|
Field |
A ______ is the smallest unit of information that you can access within a database. ____ Are also known as "cells" when dealing with spreadsheets. Also a _______ is a point at which a column and a row intersect. |