Sql Chapter 1 / 2

Front 1

Database

Back 1

Is a structure that contains different categories of information and the relationships between these categories.

Front 2

Database Design

Back 2

The process of determining the particular tables and columns that will comprise a database is known as a ___________.

Front 3

Relational Database

Back 3

a database structured to recognize relations among stored items of information.

Front 4

Entity

Back 4

A _____ is like a noun; it is a person,place,thing.

Front 5

Attribute

Back 5

property/characteristic of a entity

Front 6

Relationship

Back 6

A ______ is the association between entities.

Front 7

Relation

Back 7

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.

Front 8

functional dependency

Back 8

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.

Front 9

Primary Key

Back 9

A unique identifier for a table.

Front 10

Candidate key

Back 10

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.

Front 11

Normalization

Back 11

A Process by which you identify the existence of potential problems, such as data duplication and redundancy , and implement ways to correct them.

Front 12

First normal form (1NF)

Back 12

Contains no repeating groups.

Front 13

Second normal form (2NF)

Back 13

Contains no partial dependencies

Front 14

Third normal form(3NF)

Back 14

Contains no Transitive dependencies

Front 15

Determinant

Back 15

Any column(or collection of columns) that determines another column is called a ________.

Front 16

Unnormalized relations

Back 16

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.

Front 17

Data redundancy

Back 17

_________ 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.

Front 18

Boyce-codd normal form

Back 18

_________normal form.

Front 19

Tuple

Back 19

A _____ is the same this as a record it is one row.

Front 20

Field

Back 20

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.