Chapter 4 CS

What is a Primary Key?

A field that has a unique value for each record, such as

What is a Foreign Key?

A primary key on one table is called foreign key in the other table.

What is Normalization?

A process in database design to reduce redundancy in a database and improve data integrity: namely each piece of information is stored in one place

How are two table related in data

By a Primary key and a foreign key

What is a data warehouse?

Large scale electronic repository of data that contains and organizes all the data related to an organization in one place.

What are the disadvantages of a Data Base

Complex to build and maintained Time consuming • Expensive• Privacyconcerns

"data about data" is called: ___________.

Metadata

_________ packages generally provide an interface to view and change the design of the database, create queries, and develop reports.

DBMS

One of the important reasons to define a ____________ is so that the proper amount of storage space is allocated for the data.

Data Type

The process of analyzing data to find previously unknown trends, patterns and associations in order to make decisions is called ___________.

Data mining

A __________ is an organized collection of related information.

Database

What is a Relational Data Base?

Organizes data in two-dimensional tables, rows and columns, format by logically grouping similar data in a relation

An instance of a set of fields in a table is called a _______________.

Record

What are types of data bases?

Relational, Object-oriented, Multidimensional

Almost all applications that work with databases make use of _________ as a way to analyze and manipulate data.

SQL

What is a Data Mart?

Small slices of data warehouse used in single department or by specific employee group to meet the particular demands of a specific group of users within the organization.

What are the advantages of a Data Base

Store and retrieve large quantities of information • Enable information sharing• Provide data centralization• Promote data integrity, Allow flexible use of data

What is a multidimensional Data Base?

Stores data in more than two dimensions

What is a Object-oriented data base?

Stores data in objects rather than in tables

The term __________ is used to describe the process that organizations use to take data they are collecting and analyze it in hopes of obtaining a competitive advantage.

business intelligence

To _______ a database means to design it in a way that: 1) reduces duplication of data between tables and 2) give the table as much flexibility as possible.

normalize

For each table one of the fields is identified as a ______________.

primary key

What is Data mining?

process by which great amount of data are analyzed and investigated to spot customer trends. Is a process used by companies to turn raw data into useful information. By using software to look for patterns in large batches of data, businesses can learn more about their customers and develop more effective marketing strategies as well as increase sales and decrease costs.