INMT 341 Exam 2 ACTUAL QUESTIONS
AND CORRECT ANSWERS
User Interface (UI) - CORRECT ANSWERS A set of commands or
menus through which a user communicates with a program
Can use a command-driven interface, in which a user enters commands, or
menu-driven interface in which the user selects common choices from various
menus displayed on the screen
Unary Relationship - CORRECT ANSWERS A relationship between the
instances of a single entity
Ex. an employee who supervises other employees
Ternary Relationship - CORRECT ANSWERS Model the simultaneous
relationship between instances from three or more entities
SQL (structured query language) - CORRECT ANSWERS A
programming language that you can use to directly interact with data
You can embed commands in application programs to access and process data
stored in databases
Schema - CORRECT ANSWERS Provide useful documentation
Shows the logical view of the entire database
Report Generators - CORRECT ANSWERS Used to define the format
and look of desired output
Relationships (between entities) - CORRECT ANSWERS Identifies the
sequence of the events and impacts the creation of electronic audit trail
,Relational Logical Structures / Databases - CORRECT ANSWERS Able
to create relationships and logical structures when necessary instead of having
to predefine relationships as the database is created. Can use all of the types of
maximum relationship cardinalities(1 to 1, 1 to M, and etc.)
Relation - CORRECT ANSWERS A two dimensional array(table) with
columns and rows.
Record Layout - CORRECT ANSWERS Details the record structure,
including record field names, the width of each field, and the type of data stored
in each field
Record - CORRECT ANSWERS The rows in database tables
QBE (query by example) - CORRECT ANSWERS A grid or replica of
an empty record is displayed and the user types search criteria in the applicable
columns
Primary Key (primary key attribute) - CORRECT ANSWERS Defined
after the set of relations have been identified
The attribute that will uniquely identify each record in a physical design table
Optional relationships - CORRECT ANSWERS If the relationship
between two entities is optional the minimum cardinality is zero
OLAP (online analytical processing) - CORRECT ANSWERS Used to
more easily and selectively extract and view data from different perspectives or
points-of-view
Able to analyze different dimensions of multidimensional data
, Ex. time series analysis and or trend analysis
Object and Object Oriented - CORRECT ANSWERS Database structure
that uses objects to store both data and the computer instructions for processing
the data into a single structure.
Major advantage is increased flexibility to represent very complex data
structures that capture the essence of complex objects that exist in reality.
Structures/Databases - CORRECT ANSWERS Method of storing data.
Helps reduce data redundancy, inconsistency, and maintenance
Normal Form, Normalization - CORRECT ANSWERS Normalization
involves applying a series of rules to create a database structure in normal form
Normal form meaning that pieces of data in any grouping should only describe
the object represented by the table
Network Logical Structures / Databases - CORRECT ANSWERS
Eliminates distinction between parent and child record (Hierarchical). Complex
network models were developed to model 1:1, 1:M, M:1, and M:M maximum
cardinalities.
Multivalued attribute - CORRECT ANSWERS Can have more than one
instance
Should use a separate relation to model multivalued attributes
New relation includes primary key of relation and multivalued attribute
Minimum Cardinality - CORRECT ANSWERS Zero if the relationship
is optional
One or more if the relationship is mandatory
AND CORRECT ANSWERS
User Interface (UI) - CORRECT ANSWERS A set of commands or
menus through which a user communicates with a program
Can use a command-driven interface, in which a user enters commands, or
menu-driven interface in which the user selects common choices from various
menus displayed on the screen
Unary Relationship - CORRECT ANSWERS A relationship between the
instances of a single entity
Ex. an employee who supervises other employees
Ternary Relationship - CORRECT ANSWERS Model the simultaneous
relationship between instances from three or more entities
SQL (structured query language) - CORRECT ANSWERS A
programming language that you can use to directly interact with data
You can embed commands in application programs to access and process data
stored in databases
Schema - CORRECT ANSWERS Provide useful documentation
Shows the logical view of the entire database
Report Generators - CORRECT ANSWERS Used to define the format
and look of desired output
Relationships (between entities) - CORRECT ANSWERS Identifies the
sequence of the events and impacts the creation of electronic audit trail
,Relational Logical Structures / Databases - CORRECT ANSWERS Able
to create relationships and logical structures when necessary instead of having
to predefine relationships as the database is created. Can use all of the types of
maximum relationship cardinalities(1 to 1, 1 to M, and etc.)
Relation - CORRECT ANSWERS A two dimensional array(table) with
columns and rows.
Record Layout - CORRECT ANSWERS Details the record structure,
including record field names, the width of each field, and the type of data stored
in each field
Record - CORRECT ANSWERS The rows in database tables
QBE (query by example) - CORRECT ANSWERS A grid or replica of
an empty record is displayed and the user types search criteria in the applicable
columns
Primary Key (primary key attribute) - CORRECT ANSWERS Defined
after the set of relations have been identified
The attribute that will uniquely identify each record in a physical design table
Optional relationships - CORRECT ANSWERS If the relationship
between two entities is optional the minimum cardinality is zero
OLAP (online analytical processing) - CORRECT ANSWERS Used to
more easily and selectively extract and view data from different perspectives or
points-of-view
Able to analyze different dimensions of multidimensional data
, Ex. time series analysis and or trend analysis
Object and Object Oriented - CORRECT ANSWERS Database structure
that uses objects to store both data and the computer instructions for processing
the data into a single structure.
Major advantage is increased flexibility to represent very complex data
structures that capture the essence of complex objects that exist in reality.
Structures/Databases - CORRECT ANSWERS Method of storing data.
Helps reduce data redundancy, inconsistency, and maintenance
Normal Form, Normalization - CORRECT ANSWERS Normalization
involves applying a series of rules to create a database structure in normal form
Normal form meaning that pieces of data in any grouping should only describe
the object represented by the table
Network Logical Structures / Databases - CORRECT ANSWERS
Eliminates distinction between parent and child record (Hierarchical). Complex
network models were developed to model 1:1, 1:M, M:1, and M:M maximum
cardinalities.
Multivalued attribute - CORRECT ANSWERS Can have more than one
instance
Should use a separate relation to model multivalued attributes
New relation includes primary key of relation and multivalued attribute
Minimum Cardinality - CORRECT ANSWERS Zero if the relationship
is optional
One or more if the relationship is mandatory
