The most common format used for data modeling is ________ diagramming.
Entity-relationship
Entity-class
Entity-object
Entity-subject
Entity-relationship
A common mistake many people make when they are just learning to draw E-R diagrams, especially if they already know how to do data flow diagramming, is to confuse data entities with ________ and relationships with data flows.
Classes
Sinks
Relationships
A
Sinks
A(n) ________ is an attribute whose value can be computed from related attribute values.
Derived attribute
Composite attribute
Required attribute
Optional attribute
Derived Attribute
A(n) ________ is an attribute that may take on more than one value for each entity instance.
Multi-valued attribute
Single-valued attribute
Identifier
Candidate key
Multi-valued attribute
A(n) ________ is an attribute that must have a value for every entity instance.
Derived attribute
Composite attribute
Required attribute
Optional attribute
Required attribute
In logical database modeling and design, we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.
Summation
Integration
Addition
Combination
Integration
A well-structured relation is a relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies and is also known as a ________.
Column
Row
Table
Key
Table
During logical database design, you must account for every data element on a system input or output form or report and on the ________.
E-R diagram
Conceptual design
Physical design
Logical design
E-R Diagram
Logical and ________ database design is typically performed in parallel with other systems design steps.
Normal
Physical
Conceptual
Normalized
Physical
One purpose of database design is to structure the data in stable structures, called normalized tables, that are not likely to change over time and that have minimal ________.
Data
Space
Redundancy
Columns
Redundancy
Which relation is created by placing the primary key of either entity in the relation for the other entity or by doing this for both entities?
Binary 1:N relationship
Unary 1:1 relationship
Weak entity
Associative entity with additional key
Unary 1:1 relationship
Each entity type in the E-R diagram becomes a relation. The identifier of the entity type becomes the ________ of the relation, and other attributes of the entity type become non-primary key attributes of the relation.
Foreign key
Index
Unique key
Primary
Primary key
A binary one-to-many (1:N) relationship in an E-R diagram is represented by adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a(n) ________ in the relation that is on the many side of the relationship.
P
Foreign key
________ is a process for converting complex data structures into simple, stable data structures.
De-normalization
Normalization
Database modeling
Relation
Normalization
The result of normalization is that every ________ key attribute depends upon the whole primary key.
Candidate
Unique
Primary
Non-primary
No-primary
A(n) ________ is a specification that indicates how many objects participate in a given relationship.
Association role
Multiplicity
Association
Object class
Multiplicity
A(n) ________ is an operation that does not have any side effects; it accesses the state of an object but does not alter the state.
Encapsulation
Constructor operation
Update operation
Query operation
Query operation
A relation is a named, ________-dimensional table of data. Each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows.
Two
One
Three
Four
Two
In logical database modeling and design, we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.
Summation
Integration
Addition
Combination
Integration
A recursive relationship is also known as a ________ relationship.
Binary
Ternary
Secondary
Unary
Unary
The most common format used for data modeling is ________ diagramming.
Entity-relationship
Entity-class
Entity-object
Entity-subject
Entity-relationship
A common mistake many people make when they are just learning to draw E-R diagrams, especially if they already know how to do data flow diagramming, is to confuse data entities with ________ and relationships with data flows.
Classes
Sinks
Relationships
A
Sinks
A(n) ________ is an attribute whose value can be computed from related attribute values.
Derived attribute
Composite attribute
Required attribute
Optional attribute
Derived Attribute
A(n) ________ is an attribute that may take on more than one value for each entity instance.
Multi-valued attribute
Single-valued attribute
Identifier
Candidate key
Multi-valued attribute
A(n) ________ is an attribute that must have a value for every entity instance.
Derived attribute
Composite attribute
Required attribute
Optional attribute
Required attribute
In logical database modeling and design, we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.
Summation
Integration
Addition
Combination
Integration
A well-structured relation is a relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies and is also known as a ________.
Column
Row
Table
Key
Table
During logical database design, you must account for every data element on a system input or output form or report and on the ________.
E-R diagram
Conceptual design
Physical design
Logical design
E-R Diagram
Logical and ________ database design is typically performed in parallel with other systems design steps.
Normal
Physical
Conceptual
Normalized
Physical
One purpose of database design is to structure the data in stable structures, called normalized tables, that are not likely to change over time and that have minimal ________.
Data
Space
Redundancy
Columns
Redundancy
Which relation is created by placing the primary key of either entity in the relation for the other entity or by doing this for both entities?
Binary 1:N relationship
Unary 1:1 relationship
Weak entity
Associative entity with additional key
Unary 1:1 relationship
Each entity type in the E-R diagram becomes a relation. The identifier of the entity type becomes the ________ of the relation, and other attributes of the entity type become non-primary key attributes of the relation.
Foreign key
Index
Unique key
Primary
Primary key
A binary one-to-many (1:N) relationship in an E-R diagram is represented by adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a(n) ________ in the relation that is on the many side of the relationship.
P
Foreign key
________ is a process for converting complex data structures into simple, stable data structures.
De-normalization
Normalization
Database modeling
Relation
Normalization
The result of normalization is that every ________ key attribute depends upon the whole primary key.
Candidate
Unique
Primary
Non-primary
No-primary
A(n) ________ is a specification that indicates how many objects participate in a given relationship.
Association role
Multiplicity
Association
Object class
Multiplicity
A(n) ________ is an operation that does not have any side effects; it accesses the state of an object but does not alter the state.
Encapsulation
Constructor operation
Update operation
Query operation
Query operation
A relation is a named, ________-dimensional table of data. Each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows.
Two
One
Three
Four
Two
In logical database modeling and design, we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.
Summation
Integration
Addition
Combination
Integration
A recursive relationship is also known as a ________ relationship.
Binary
Ternary
Secondary
Unary
Unary