INMT 341 EXAM 2 VERIFIED STUDY GUIDE
User Interface (UI) - 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 - Answers - A relationship between the instances of a single entity
Ex. an employee who supervises other employees
Ternary Relationship - Answers - Model the simultaneous relationship between
instances from three or more entities
SQL (structured query language) - 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 - Answers - Provide useful documentation
Shows the logical view of the entire database
Report Generators - Answers - Used to define the format and look of desired output
Relationships (between entities) - Answers - Identifies the sequence of the events and
impacts the creation of electronic audit trail
Relational Logical Structures / Databases - 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 - Answers - A two dimensional array(table) with columns and rows.
Record Layout - Answers - Details the record structure, including record field names,
the width of each field, and the type of data stored in each field
Record - Answers - The rows in database tables
QBE (query by example) - 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) - 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 - Answers - If the relationship between two entities is optional the
minimum cardinality is zero
OLAP (online analytical processing) - 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 - 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 - Answers - Method of storing data.
Helps reduce data redundancy, inconsistency, and maintenance
Normal Form, Normalization - 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 - 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 - 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 - Answers - Zero if the relationship is optional
One or more if the relationship is mandatory
Maximum Cardinality - Answers - Denotes the maximum number of related instances
Mandatory Relationships - Answers - Minimum cardinality of one or more in a
relationship
Logical Views / Schemas - Answers - Used to define user views of the data in (DDL)
Used to create, alter, and delete table structures
Schemas also provided useful documentation showing the logical view of the entire
database
User Interface (UI) - 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 - Answers - A relationship between the instances of a single entity
Ex. an employee who supervises other employees
Ternary Relationship - Answers - Model the simultaneous relationship between
instances from three or more entities
SQL (structured query language) - 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 - Answers - Provide useful documentation
Shows the logical view of the entire database
Report Generators - Answers - Used to define the format and look of desired output
Relationships (between entities) - Answers - Identifies the sequence of the events and
impacts the creation of electronic audit trail
Relational Logical Structures / Databases - 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 - Answers - A two dimensional array(table) with columns and rows.
Record Layout - Answers - Details the record structure, including record field names,
the width of each field, and the type of data stored in each field
Record - Answers - The rows in database tables
QBE (query by example) - 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) - 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 - Answers - If the relationship between two entities is optional the
minimum cardinality is zero
OLAP (online analytical processing) - 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 - 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 - Answers - Method of storing data.
Helps reduce data redundancy, inconsistency, and maintenance
Normal Form, Normalization - 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 - 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 - 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 - Answers - Zero if the relationship is optional
One or more if the relationship is mandatory
Maximum Cardinality - Answers - Denotes the maximum number of related instances
Mandatory Relationships - Answers - Minimum cardinality of one or more in a
relationship
Logical Views / Schemas - Answers - Used to define user views of the data in (DDL)
Used to create, alter, and delete table structures
Schemas also provided useful documentation showing the logical view of the entire
database
