Deck 9: Data Design

Question 1

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

Answer 1

True

Question 2

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.

Answer 2

True

Question 3

Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity.

Answer 3

True

Question 4

Cipher codes distinguish items by using a series of subgroups of digits.​

Question 5

The basic elements of logical storage are alphabetic or numeric characters, such as the letter A or the number 9.

Question 6

Web-based designs are dependent on a specific combination of hardware and software.​

Question 7

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

A) Scalability
B) Compatibility
C) Cardinality
D) Functionality

Question 8

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

Question 9

Like a primary key, a foreign key must be unique.

Question 10

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.

Question 11

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

Question 12

Three main types of relationships can exist between entities: a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

Question 13

The three normal forms constitute a progression in which the second normal form represents the best design.

Question 14

A _____, which is a framework for organizing, storing, and managing data, consists of files or tables that interact in various ways.

A) data structure
B) data roster
C) data object
D) data log

Question 15

A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on one another.

Question 16

A common field is an attribute that appears in only one entity.

Question 17

A web-based data design requires users to have powerful workstations.

Question 18

A primary key is composed of exactly two fields.

Question 19

A(n) _____ is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data.

A) data logger framework
B) database management system
C) integrated development environment
D) advanced host controller system

Question 20

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Question 21

_____ enables Java applications to exchange data with any database that uses SQL statements and is compliant with its standard.

A) Java runtime environment (JRE)
B) Java eclipse framework connectivity (JEFC)
C) Java virtual machine (JVM)
D) Java database connectivity (JDBC)

Question 22

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.​

A) Scalability
B) Compatibility
C) Cardinality
D) Functionality

Question 23

The inherent efficiency of high-volume processing on larger computers is called _____.

A) monopoly
B) economy of scope
C) cardinality
D) economy of scale

Question 24

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

A) ActiveX data object (ADO)
B) Java virtual connector (JVC)
C) Open database connectivity (ODBC)
D) Open embedded connectivity (OEC)

Question 25

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

A) triangles
B) circles
C) rectangles
D) hexagons

Question 26

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

A) procedural language
B) query by example language
C) query language
D) imperative language

Question 27

In the accompanying figure, a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

A) secondary key
B) candidate key
C) combination key
D) foreign key

Question 28

With a _____, users provide an example of the data requested.

A) query language
B) data table
C) query by example language
D) data frame

Question 29

During the systems design phase, _____ are used to organize, access, and maintain data structures.

A) glossary fields
B) common fields
C) content fields
D) key fields

Question 30

A(n) _____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.

A) entity-relationship diagram (ERD)
B) illustration flow chart
C) query relationship diagram (QRD)
D) data chart

Question 31

If a primary key combines two or more fields, then it is called a _____.

A) foreign key
B) composite key
C) dedicated key
D) candidate key

Question 32

A _____ controls database operations, including storing, retrieving, updating, and deleting data.

A) data manipulation language
B) data device language
C) data definition language
D) data query language

Question 33

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.

A) middleware
B) stack
C) server
D) firmware

Question 34

In the accompanying figure, any field that serves as a primary key is called a _____.​

A) candidate key
B) secondary key
C) combination key
D) foreign key

Question 35

A _____, which is not unique, is a field or combination of fields that can be used to access or retrieve records.​

A) no-frills key
B) super key
C) secondary key
D) foreign key

Question 36

In the accompanying figure, a _____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

A) primary key
B) secondary key
C) candidate key
D) foreign key

Question 37

Any field that is not a primary key or a candidate key is called a _____.​

A) no-frills field
B) nonkey field
C) secondary field
D) foreign field

Question 38

Typically, a database management system is managed by a person called _____, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

A) database administrator
B) business intelligence analyst
C) database consumer
D) big data analyst

Question 39

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

A) candidate integrity
B) foreign integrity
C) referential integrity
D) combinatorial integrity

Question 40

The complete definition of a database, including descriptions of all fields, tables, and relationships, is called a _____.

A) viewport
B) schema
C) framework
D) cell

Question 41

A _____ is a set of letters or numbers that represents a data item.

A) business glossary
B) data dictionary
C) mnemonic
D) code

Question 42

_____ use a keyword to encode a number.

A) Cipher codes
B) Identifier codes
C) Action codes
D) Associative codes

Question 43

A table is in _____ if it does not contain a repeating group.

A) second normal form
B) first normal form
C) third normal form
D) fourth normal form

Question 44

_____, a coding method that uses one byte per character, is used on most personal computers.

A) ASCII (American Standard Code for Information Interchange)
B) EBCDIC (Extended Binary Coded Decimal Interchange Code)
C) Unicode
D) ISO (International Organization for Standardization) 10646

Question 45

A _____ specifies the fields and identifies the primary key in a particular file.

A) frame design
B) table design
C) viewport
D) window

Question 46

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) second normal form
B) zeroth normal form
C) third normal form
D) fourth normal form

Question 47

_____, a coding method that uses one byte per character, is used on mainframe computers and high-capacity servers.

A) ASCII (American Standard Code for Information Interchange)
B) EBCDIC (Extended Binary Coded Decimal Interchange Code)
C) Unicode
D) ISO (International Organization for Standardization)

Question 48

Some abbreviation codes are called _____ codes because they use a specific combination of letters that are easy to remember.​

A) harmonic
B) sequence
C) mnemonic
D) rhapsodic

Question 49

_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.​

A) Encapsulation
B) Normalization
C) Abstraction
D) Encryption

Question 50

Designing tables is easier if a _____ is used to show a table's structure, fields, and primary key.

A) distinct notation format
B) multifaceted notation format
C) viewport notation format
D) standard notation format

Question 51

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

A) big O notation
B) dark resistor's notation
C) crow's foot notation
D) hash topology notation

Question 52

The data mining technique that relies on association rule learning is often called _____.

A) simulated analysis
B) virtual storage analysis
C) strategy-oriented analysis
D) market basket analysis

Question 53

A _____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

A) data warehouse
B) data frame
C) pseudo-data
D) metadata

Question 54

_____ are numbers or letters assigned in a specific order.

A) Sequence codes
B) Category codes
C) Significant digit codes
D) Derivation codes

Question 55

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

A) 12
B) 24
C) 30
D) 32

Question 56

A table design that contains a repeating group is called _____.

A) normalized
B) unnormalized
C) unsynchronized
D) synchronized

Question 57

A _____ is designed to serve the needs of a specific department, such as sales, marketing, or finance.

A) data mart
B) data frame
C) pseudo-data
D) metadata

Question 58

_____ is strictly hardware-related because it involves the process of reading and writing binary data to physical media, such as a hard drive, CD/DVD, or network-based storage device.

A) Logical storage
B) Virtual storage
C) Simulated storage
D) Physical storage

Question 59

Binary digits have only _____ possible value(s).

A) one
B) two
C) three
D) four

Question 60

_____ combine data from different item attributes, or characteristics, to build a code.

A) Sequence codes
B) Category codes
C) Significant digit codes
D) Derivation codes

Question 61

Which of the following are the advantages of a DBMS (database management system)?

A) Database systems can support enterprise-wide applications more effectively than file processing systems.
B) Effective database administration helps ensure that standards for data names, formats, and documentation are followed uniformly throughout an organization.
C) A DBMS is scalable which makes it easier to meet the rapidly changing needs of a business enterprise.
D) Systems that interact with a DBMS are relatively dependent of how the physical data is maintained.

Question 62

Matching
​Identify the letters of the choices that best match the phrases or definitions.
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
Defines only those portions of the database that a particular system or user needs or is allowed to access

Question 63

Case 9-1
​​Eamon is planning to start an online store that specializes in books and electronics. Since it's his first business, he has a lot of doubts. Help Eamon set up his business by answering the following questions.
Eamon wants to provide a discount to premium buyers who order in large quantities. He wants to create a code for each price and share it with them. Also, he wants to ensure that only the premium buyers can decipher the code shared. In this scenario, which of the following codes would you suggest Eamon to use?

A) Cipher code
B) Mnemonic code
C) Action code
D) Derivation code

Question 64

Matching
​Identify the letters of the choices that best match the phrases or definitions.
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
A field in one table that must match a primary key value in another table in order to establish the relationship between the two tables

Question 65

A combination key can also be called a _____.

A) composite key
B) concatenated key
C) foreign key
D) multivalued key

Question 66

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 _____.

A) Y2K issue
B) H2R issue
C) 2D issue
D) ​2DGT issue

Question 67

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

A) two digits for the year, two for the month, and two for the day (YYMMDD)
B) two digits for the day, two for the month, and four for the year (DDMMYYYY)
C) four digits for the year, two for the month, and two for the day (YYYYMMDD)
D) four digits for the year, two for the month, and four for the day (YYYYMMDDDD)

Question 68

Each _____ contains data about people, places, things, or events.

A) nonkey field
B) table
C) cardinality notation
D) file

Question 69

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

A) front end
B) back end
C) middleware
D) interface

Question 70

In the event of a file catastrophe, _____ can be used to restore the file or database to its current state at the time of the last backup.

A) recovery procedures
B) market basket analysis
C) crow's foot notation
D)
A standard notation format​

Question 71

Matching
​Identify the letters of the choices that best match the phrases or definitions.
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
A coding method used on mainframe computers and high-capacity servers

Question 72

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

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

Question 73

Matching
​Identify the letters of the choices that best match the phrases or definitions.
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
A set of rules that avoids data inconsistency and quality problems

Question 74

Matching
​Identify the letters of the choices that best match the phrases or definitions.
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
A technique used by analysts to define relationships in more detail, after drawing an initial entity-relationship diagram

Question 75

Matching
​Identify the letters of the choices that best match the phrases or definitions.
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
A person, place, thing, or event for which data is collected and maintained

Question 76

Case 9-2
​Emily is functioning with her customer, Anna, on the design of a new database. She describes to Anna that key fields are utilized to access, coordinate, and preserve the data records.
Anna asks if it is manageable to fetch records using a field or combination of fields that is not unique. Emily tells her that it is possible using one type of key. Identify the type of key used here.
a. Primary key
b. Secondary key
c. Foreign key
d. Super key

Question 77

Case 9-1
​​Eamon is planning to start an online store that specializes in books and electronics. Since it's his first business, he has a lot of doubts. Help Eamon set up his business by answering the following questions.
Eamon plans to operate three warehouses, in different cities, to support his business. To find the exact location of a product, he wants to establish a code that identifies a product's warehouse location, floor number, section number, aisle number, and bin number. By doing this, he can ship the ordered products faster. Which of the following codes would you suggest Eamon to use?

A) Significant digit code
B) Block sequence code
C)
Sequence code
D) Action code

Question 78

Compared with character-based formats, a _____ offers a more efficient storage method.​

A) foreign storage format
B) unary storage format
C) tertiary storage format
D) binary storage format

Question 79

Case 9-2
​Emily is functioning with her customer, Anna, on the design of a new database. She describes to Anna that key fields are utilized to access, coordinate, and preserve the data records.
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?

A) Candidate key
B) Ancillary key
C) Foreign key
D) Multifaceted key

Question 80

_____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

A) Encapsulation
B) Normalization
C) Standardization
D) Encryption