Upgrade to remove ads
Only $35.99/year

MIS ch 6

Terms in this set (60)

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

· The entity PRODUCT with the attribute PURCHASE
· The entity PRODUCT with the attribute CUSTOMER
· The entity CUSTOMER with the attribute PRODUCT
· The entity PURCHASE with the attribute CUSTOMER
· The entity CUSTOMER with the attribute PURCHASE
· The entity CUSTOMER with the attribute PURCHASE

Entity: is a person, place, thing, or event on which we store and maintain information.

Attribute: each characteristic or quality describing a particular entity.
All of the following are issues with the traditional file environment except:

· data sharing.
· data inconsistency.
· inability to develop specialized applications for functional areas.
· lack of flexibility in creating ad-hoc reports.
· poor security.
inability to develop specialized applications for functional areas.

Problems with traditional file environment:
Data redundancy
Data inconsistency
Program-data dependence
Lack of Flexibility
Poor Security
Lack of Data Sharing and availability
A characteristic or quality that describes a particular database entity is called a(n):

attribute.
tuple.
relationship.
field.
key field.
Attribute
A database ________ describes a database entity.

record
field
file
byte
value
record

Record: a group of related fields, such as the student's name, the course taken, the date, and the grade

You set up a database to maintain the information. For each customer, you create a record. Within each record you have the following fields: customer first name, customer last name, street address, city, state, zip, ID, and date last paid. Smith, Jones, and Brooks are the records within a file you decide to call Paper Delivery. The entities then are Smith, Jones, and Brooks, the people about whom you are maintaining information. The attributes are customer's name (first and last), address (street, city, state, zip code), ID, and date last paid
________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Data quality
Online processing
Data redundancy
Data independence
Batch processing
Data redundancy

:is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location. Occurs when different groups in a firm independently collect the same piece of data and store it independently of each other. Wastes storage resources and leads to data inconsistency.
Data ________ occurs when the same data is duplicated in multiple files of a database.

independence
partitions
discrepancy
repetition
redundancy
redundancy

data redundancy: is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location. Occurs when different groups in a firm independently collect the same piece of data and store it independently of each other. Wastes storage resources and leads to data inconsistency.
Which of the following occurs when the same attribute in related data files has different values?

Data dependence
Data discrepancy
Data duplication
Data redundancy
Data inconsistency
Data inconsistency

Data inconsistency: the same attribute (characteristic or quality) may have different values.
Which of the following is a grouping of characters into a word, a group of words, or a complete number?

File
Table
Tuple
Entity
Field
Field

Field: a grouping of characters into a word, a group of words, or a complete number (such as a person's name or age). (IS 101)

You set up a database to maintain the information. For each customer, you create a record. Within each record you have the following fields: customer first name, customer last name, street address, city, state, zip, ID, and date last paid. Smith, Jones, and Brooks are the records within a file you decide to call Paper Delivery. The entities then are Smith, Jones, and Brooks, the people about whom you are maintaining information. The attributes are customer's name (first and last), address (street, city, state, zip code), ID, and date last paid
The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems?

Lack of flexibility
Data redundancy
Program-data dependence
Lack of data sharing
Poor security
Lack of Flexibility

Lack of Flexibility: specific information requested may take finesse and take weeks to compile because reports aren't flexible. It cannot deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion.
Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

Data duplication
Data redundancy
Data normalization
Data accuracy
Data inconsistency
Data inconsistency
A record is a group of related fields.

True or false
True

Field: a grouping of characters into a word, a group of words, or a complete number (such as a person's name or age). (IS 101)

You set up a database to maintain the information. For each customer, you create a record. Within each record you have the following fields: customer first name, customer last name, street address, city, state, zip, ID, and date last paid. Smith, Jones, and Brooks are the records within a file you decide to call Paper Delivery. The entities then are Smith, Jones, and Brooks, the people about whom you are maintaining information. The attributes are customer's name (first and last), address (street, city, state, zip code), ID, and date last paid
Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data.

True or False
True

One program might be modified from a five-digit zip code to a nine digit zip code. If the original data file were changed from five-digit to nine-digit zip codes, then other programs that required the five digit zip code would no longer work properly.
You have been asked to design a new contracts database for a small publishing company. What fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?
Author first name, author last name, author address, agent name, and address, title of book, book ISBN, date of contract, amount of money, payment schedule, date contract ends. Other databases might be an author database (author name, address, and agent details), a book title database (title and ISBN #), and financial database (payment schedule, amount of money).
List at least three conditions that contribute to data redundancy and inconsistency.
1. different jargon used in the departments of the company
2. multiple spellings of the same name may be used
3. descriptions of things may vary
Field names may be different and attributes can differ
Which of the following enables a DBMS to reduce data redundancy and inconsistency?

Ability to couple program and data
Ability to enforce referential integrity
Ability to minimize isolated files with repeated data
Ability to create two-dimensional tables
Use of a data dictionary
Ability to minimize isolated files with repeated data

DBMS Solves Traditional File Environment problems by reducing data redundancy and inconsistencies. It enables the firm to centrally manage data, their use, and security. Data sharing is easier because data are presented to users as being in a single location.
Sets found in the same folder