Question 1

Most magazine subscription codes are action codes.

Accepted Answer

A) True 
 B)False  False

Question 2

Describe how middleware is used.

Accepted Answer

To access data in a web-based system,the database must be connected to the Internet or intranet.The database and the Internet speak two different languages,however.Databases are created and managed by using various languages and commands that have nothing to do with HTML,which is the language of the web.The objective is to connect the database to the web and enable data to be viewed and updated.
To bridge the gap,it is necessary to use middleware,which is a software that integrates different applications and allows them to exchange data.Middleware can interpret client requests in HTML form and translate the requests into commands that the database can execute.When the database responds to the commands,middleware translates the results into HTML pages that can be displayed by the user's browser.

Question 3

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.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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.

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Most magazine subscription codes are action codes.

Describe how middleware is used.

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.

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

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

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

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(n)_____ allows a user to specify a task without specifying how the task will be accomplished.

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

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

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

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

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

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

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

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

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 web-based data design requires users to have powerful workstations.

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.

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

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Engineering

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Communication-Tools

Case-Tools

Financial-Analysis-Tools

Internet-Resource-Tools

Filters

Exam 9: Data Design

Most magazine subscription codes are action codes.

Describe how middleware is used.

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.

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

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

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

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(n)_____ allows a user to specify a task without specifying how the task will be accomplished.

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

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

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

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

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

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

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

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

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 web-based data design requires users to have powerful workstations.

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.

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

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Engineering

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Communication-Tools

Case-Tools

Financial-Analysis-Tools

Internet-Resource-Tools

Filters