Deck 9: Data Design

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

Systems that interact with a DBMS are relatively independent of how the physical data is maintained.

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

Most magazine subscription codes are action codes.

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

A subschema is a view of the database used by one or more systems or users.

Question 17

A primary key is composed of exactly two fields.

Question 18

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.

Question 19

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 20

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 21

A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs.

Question 22

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 23

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 24

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

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

Question 26

A logical record is a set of field values that describes a single person,place,thing,or event.

Question 27

Mainframe storage refers to data that a user can view,understand,and access,regardless of how or where that information actually is organized or stored.

Question 28

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

Question 29

College course numbers usually are assigned using a block sequence code.

Question 30

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 31

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 32

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

An M:N relationship is different from 1:1 or 1:M relationships because the event or transaction that links the two entities is actually a third entity,called an associative entity,that has its own characteristics.

Question 34

The database and the Internet speak the same language.

Question 35

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 36

A secondary key 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.

Question 37

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 38

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 39

Common fields can be used to link entities in various types of relationships.

Question 40

Typically,a database management system is managed by a person called a _____,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 41

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 42

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 43

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 44

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 45

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 46

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 47

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 48

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 49

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 50

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

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

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

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

Question 53

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 54

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

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

Question 55

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 56

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 57

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

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

Question 58

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

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

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

Question 60

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 61

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

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

Question 62

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 63

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 64

_____ are numbers or letters assigned in a specific order.

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

Question 65

_____ use a keyword to encode a number.

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

Question 66

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 that Eamon use?

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

Question 67

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 that Eamon use?

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

Question 68

_____,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 69

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

_____ 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

Question 71

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

A) A data warehouse
B) A data frame
C) Pseudo-data
D) Metadata

Question 72

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

A) A data mart
B) A data frame
C) Pseudo-data
D) Metadata

Question 73

Explain the importance and process of system file backup.

Question 74

List and discuss at least five specific database management system (DBMS)advantages.

Question 75

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 76

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

Explain why large firms use data warehouses.

Question 78

Binary digits have only _____ possible value(s).

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

Question 79

Briefly describe the seven coding methods used by companies with examples.

Question 80

Describe how middleware is used.