FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Data Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A widely used method of visualizing and documenting software systems design

A) Unified Modeling Language (UML)
B) Cardinality
C) Foreign key
D) Data mining
E) Referential integrity
F) Subschema
G) Extended Binary Coded Decimal Interchange Code (EBCDIC)
H) Entity
I) Logical record
J) Logical storage

K) B) and C)
L) A) and C)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

EBCDIC and ASCII both require _____ bits for storage of each character.

A) six
B) eight
C) twelve
D) sixteen

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Migrating a traditional database design to the web can require design modification, additional software, and some added expense.

One type of validity check, called _____, is a set of rules that avoids data inconsistency and quality problems.

At the beginning of the twenty-first century, many firms that used only two digits to represent the year were faced with a major problem called the _____.

_____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.

A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value.

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A coding method used on mainframe computers and high-capacity servers

Emily tells Anna that a primary key is a field or combination of fields that individually and minimally recognizes a specific entity. She mentions that there may be an option of fields or field combinations to use as the primary key. Which of the following is the term used for a feasible primary key?

In an entity-relationship diagram, entities are commonly represented as _____.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A set of field values that describes a single person, place, thing, or event

Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

In a web-based design, the Internet serves as the _____ for the database management system.

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

A common method of cardinality notation is called _____ because of the shapes, which include circles, bars, and symbols that indicate various possibilities.

Most date formats now are based on the model established by the International Organization for Standardization (ISO) , which requires a format of _____.

In a table or file, each column represents a record and each row represents a field.

To bridge the gap between a database and the Internet, it is necessary to use a _____, which is software that integrates different applications and allows them to exchange data.