IS Chapter 6 Part 2

24 July 2022
4.7 (114 reviews)
25 test answers

Unlock all answers in this set

Unlock answers (21)
question
the type of logical database model that treats data as if they were stored in two-dimensional tables is the
answer
relational DBMS
question
What are the relationships that the relational database is named for?
answer
relationship between entities
question
A characteristic or quality describing an entity is called
answer
attribute
question
The most basic business database is comprised of
answer
five tables: for customers, employees, suppliers, parts, and sales
question
in a table for customers, the information about a single customer would reside in a single
answer
row
question
in a relational database, a record is also called a
answer
Tuple
question
A field identified in a record as holding the unique identifier for that record is called the:
answer
Key field
question
A schematic of the entire database that describes the relationships in a database is called
answer
entity-relationship diagram
question
A one-to-one relationship between two entities in symbolized in a diagram by a line that ends
answer
in two short marks
question
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends
answer
with a crow's foot preceded by a short mark
question
A table that links two tables that have a many-to-many relationship is often called a
answer
intersection relation
question
the process of streamlining data to minimize redundancy and awkward many-to-many relationships is called
answer
normalization
question
A DBMS makes the:
answer
physical database available for different logical views
question
the logical view of a database
answer
presents data as they would be perceived by end users
question
Which of the following is not a typical feature of DBMS
answer
Query wizard tool
question
Access is a
answer
DBMS for desktop PC systems
question
In clustering, a data mining tool will:
answer
find new groupings within data
question
MySQL is a
answer
popular open-source DBMS
question
Data mining is more______ than OLAP
answer
discovery green
question
in a relational database, the three basic operations used to develop useful sets of data are:
answer
select, project, and join
question
The select operation
answer
creates a subset consisting of all records in the file that meet stated criteria
question
all of the following are tools or technologies for extracting information from unstructured data sets except
answer
SQL queries
question
The project operation
answer
creates a subset consisting of columns in a table
question
which of the following best describes the importance of creating an accurate data model for your businesses database?
answer
critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve
question
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.
answer
Data dictionary