CIS 301 section ch 5

25 terms by aspinieo

Create a new folder

Advertisement Upgrade to remove ads

Final Exam

A grouping of characters into a word, a group of words, or a complete number is called a record.

false

In normalization, complex groupings of data are streamlined to eliminate awkward many-to-many relationships.

true

Many applications today require databases that can store and retrieve multimedia.

true

OODBMS are slower than relational DBMS.

true

A data warehouse is typically comprised of several smaller data marts.

false

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to infer future behavior.

false

predictive analysis is a technique of data mining

false

common Gateway interface is a specification for processing data on a Web server

true

a firm's information policy lays out who is responsible for updating and maintaining the information in a database system

true

data cleansing is the same process as data scrubbing

true

what is the first step you should take in managing data for a firm?

identify the data needed to run the business

Which of the following best illustrates the relationship between entities and attributes?

The entity CUSTOMER with the attribute ADDRESS

What are the relationships that the relational database is named for?

Relationships between entities

The most basic business database is comprised of:

five tables: for customers, employees, suppliers, products, and sales.

In a relational database, a record is also called a(n):

tuple

A field identified in a record as holding the unique identifier for that record is called the:

key field

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

in two short marks

A table that links two tables that have a many-to-many relationship is often called a(n):

intersection relation

a DBMS makes the:

physical database available for different logical views.

Which of the following is not a typical feature of DBMS?

Query wizard tool

access is a

DBMS for desktop systems

Microsoft SQL Server is a(n):

DBMS for midrange computers

the selection operation:

creates a subset consisting of all records in the file that meets stated criteria.

the project operation:

creates a subset consisting of columns in a table

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

data dictionary

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set