Database design test 1 study guide

The element that is used to select one specific entity instance from an entity class is called a(n) (one word answer):

Identifier

Datathat describes thestructure of the database data is called

Metadata

The second is (two word answer): where the data for two or more distinct elements are stuck together on the same line of a list.

Multiple Themes

List 1 characteristics of a relation

Rows contain data about an entity

List 3 characteristics of a relation

The order of the columns is unimportant

List 4 characteristics of a relation

The order of the rows is unimportant

Another type of list modification problem can occur when trying to change existing information in a list. This type of problem is called (one word answer):

Update

What are the four key components to a data base system

User, Database, Database Application, Database Management System

The property that ensures that the values of a column in one table are valid based on the values in another table is called

foreign key

The type of key that requires multiple columns to select a single row is called (two word answer):

Composite Key

In addition to users, one other components of a database system, defined as a self-describing collection of related records is called

Database

One type of list modification problem can occur when trying to remove information from a list. This type of problem is called (one word answer):

Deletion

List 2 characteristics of a relation

Each column has a unique name

In the ER Model has four important elements. The first represents one important theme or topic that is represented in the database. This element is called (one word answer):

Entity

The element that describes the topic's characteristics is called (one word answer):

Attribute

The type of key that is actually used to select a single row in a table is called (two word answer):

Primary Key

There are two problems when managing data using plain lists. The first is (one word answer):_____where the same piece of information occurs in multiple places in the list.

Redundancy

The type of key that links tables together is called (two word answer, watch spelling!):

Referential integrity

The element that describes the connections between topics/themes is called (one word answer):

Relationship

The international standard for creating, processing and querying databases and their tables is called (three word answer or one word acronym):

SQL (Structured Query Language)

The type of key that adds an extra, numerically valued, column to serve as the actual key to select single rows is called (two word answer):

Surrogate Key