Systems Analysis and Design Ch9
12) 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. A) Two B) One C) Three D) Four
A Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
42) A(n) ________ must satisfy referential integrity, which specifies that the value of an attribute in one relation depends on the value of the same attribute in another relation. A) Foreign key B) Primary key C) Unique key D) Index
A Difficulty: Easy AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
48) A unary relationship is a relationship between the instances of a ________ entity type, which are also called recursive relationships. A) Single B) Double C) Triple D) Many
A Difficulty: Easy AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
55) Which relation is created with a composite primary key using the primary keys of the related entities, plus any non-key attributes associative entity of the relationship or associative entity? A) Associative entity B) Associative entity with its own key C) Associative entity with additional key D) Weak entity
A Difficulty: Easy AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
61) In some situations, a single attribute name, called a(n) ________, may have more than one meaning or describe more than one characteristic. A) Homonym B) Antonym C) Synonym D) Duplicate
A Difficulty: Easy AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
45) The key should be ________; that is, no attribute in the key can be deleted without destroying its unique identification. A) De-normalized B) Normalized C) Redundant D) Non-redundant
D Difficulty: Easy AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
83) In a hashed file organization, the address of each ________ is determined using an algorithm. A) Constraint B) Key C) Column D) Row
D Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
1) 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 ________. A) Data B) Space C) Redundancy D) Columns
C Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
6) There are ________ key steps in logical database modeling and design. A) Two B) Three C) Four D) Five
C Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
21) A foreign key is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
37) A relation is in first normal form if every non-primary key attribute is functionally dependent on the whole primary key.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
63) When two 3NF relations are merged to form a single relation, dependencies between non-keys may result.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
53) Which relation is created with the primary key associated with the relationship or associative entity, plus any non-key attributes of the relationship or associative entity and the primary keys of the related entities (as foreign key attributes)? A) Associative entity B) Associative entity with its own key C) Associative entity with additional key D) Binary 1:N relationship
B Difficulty: Easy AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
2) Logical and ________ database design is typically performed in parallel with other systems design steps. A) Normal B) Physical C) Conceptual D) Normalized
B Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
49) A recursive foreign key is a foreign key in a relation that references the ________ values of that same relation. A) Non-primary key B) Unique key C) Primary key D) Foreign key
C Difficulty: Easy AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
56) Which relation is created by placing the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side? A) Associative entity B) Weak entity C) Binary 1:N relationship D) Associative entity with additional key
C Difficulty: Easy AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
20) During logical database design, you must account for every data element on a system input or output—form or report—and on the flow chart.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
23) In an object oriented database model, data is represented as a set of related tables or relations.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
25) An unstructured 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.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
36) De-normalization is a process for converting complex data structures into simple, stable data structures.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
50) While representing an entity, each non-key attribute of the entity type becomes a key attribute of the relation.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
51) The procedure for representing relationships depends on both the degree of the relationship and not on the cardinalities of the relationship.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
52) A recursive foreign key is a foreign key in a relation that references the foreign key values of that same relation.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
86) In a range control, only alphabetic data may have a limited set of permissible values.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
19) Logical database design is driven not only from the previously developed E-R data model for the application or enterprise but also from form and report layouts.
TRUE Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
22) A relation is a named, two-dimensional table of data and each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
24) In a relational table, each row is unique and uniqueness is guaranteed because the relation has a non-empty primary key value.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
38) A relation is in third normal form if it is in second normal form and there are no functional dependencies between two (or more) non-primary key attributes.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
39) Each relationship in an E-R diagram must be represented in the relational database design and how we represent a relationship depends on its nature.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
62) When merging relations that contain synonyms, we should obtain, if possible, agreement from users on a single standardized name for the attribute and eliminate the other synonym.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
69) Normalized relations are, of course, the result of ________ database design. A) Physical B) Logical C) Conceptual D) Conventional
B Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
74) A ________ table is a named set of rows and columns that specifies the fields in each row of the table. A) Conceptual B) Physical C) Relational D) Logical
B Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
71) A(n) ________ is a coding scheme recognized by system software for representing organizational data. A) Data model B) Attribute C) Data type D) Field
C Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
77) ________ is NOT a valid type of partitioning method in relational database products. A) Range B) Hash C) Boundary D) Composite
C Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
87) A null value is a special field value, similar to a zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
85) A calculated field is a field that can be derived from other database fields and is also known as a computed field or a derived field.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
10) During logical database design, you must account for every data element on a system input or output form or report and on the ________. A) E-R diagram B) Conceptual design C) Physical design D) Logical design
A Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
3) ________ database design is driven not only from the previously developed E-R data model for the application or enterprise but also from form and report layouts. A) Logical B) Physical C) Normalized D) De-normalized
A Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
32) A functional dependency is a particular relationship between two ________. A) Attributes B) Rows C) Databases D) Tables
A Difficulty: Easy AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
93) De-normalization can increase the chance of errors and inconsistencies that normalization avoided.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed Classification: Synthesis
72) A default value is the value that a ________ will assume unless an explicit value is entered for it. A) Field B) Row C) Table D) Data type
A Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
17) In a relation, the sequence of columns can be interchanged without changing the meaning or use of the ________. A) Relation B) Attribute C) Row D) Primary key
A Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
5) In most situations, many physical database design decisions are implicit or eliminated when we choose the ________ technologies to use with the application. A) Data management B) System management C) Software management D) SDLC
A Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
35) A functional dependency between ________ key attributes is also called a transitive dependency. A) Non-primary B) Primary C) Composite D) Unique
A Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
59) Which relation is created with primary key and non-key attributes only? A) Regular entity B) Weak entity C) Sub-type D) Associative entity
A Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
76) The capability to split a table into separate sections, often called ________, is possible with most relational database products. A) Partitioning B) Splitting C) Combining D) Normalizing
A Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
81) A(n) ________ is a file organization in which rows are stored either sequentially or non-sequentially, and an index is created that allows software to locate individual rows. A) Indexed file organization B) Sequential file organization C) Hashed file organization D) Physical file
A Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
68) A(n) ________ is the smallest unit of application data recognized by system software, such as a programming language or database management system. A) Table B) Field C) Row D) Index
B Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
78) Each partition is stored in a separate contiguous section of disk space, which Oracle calls a(n) ________. A) Database B) Tablespace C) Table D) Index
B Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
80) A(n) ________ is a field of data that can be used to locate a related field or row of data. A) Index B) Pointer C) Secondary key D) Attribute
B Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
15) Entries in cells are simple and an entry at the intersection of each row and column has a ________ value. A) Duplicate B) Single C) Multi D) Repeating
B Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
7) 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 ________. A) Summation B) Integration C) Addition D) Combination
B Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
9) A(n) ________ is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation. A) Composite key B) Primary key C) Identifier D) Index
B Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
29) ________ is a process for converting complex data structures into simple, stable data structures. A) De-normalization B) Normalization C) Database modeling D) Relation
B Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
34) A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key. A) 1NF B) 2NF C) 3NF D) 4NF
B Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
44) Each regular entity type in an E-R diagram is transformed into a(n) ________. A) Identifier B) Relation C) Attribute D) Row
B Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
47) 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. A) Primary key B) Foreign key C) Unique key D) Index
B Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
57) 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? A) Binary 1:N relationship B) Unary 1:1 relationship C) Weak entity D) Associative entity with additional key
B Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
84) The ________ families of file organizations cover most of the file organizations we will have at our disposal as we design physical files and databases. A) Two B) Three C) Four D) Five
B Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
73) A ________ value is a special field value, distinct from a zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown. A) Key B) True C) Null D) Default
C Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
82) A(n) ________ is one field or a combination of fields for which more than one row may have the same combination of values. A) Index B) Primary key C) Secondary key D) Pointer
C Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
11) In a ________ database model, data is represented as a set of related tables or relations. A) Logical B) Conventional C) Relational D) Physical
C Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
13) Each ________ in a relation corresponds to an attribute of that relation. A) Entity B) Data C) Column D) Row
C Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
18) 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 ________. A) Column B) Row C) Table D) Key
C Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
31) In ________ normal form, non-primary key attributes do not depend on each other (what we call no transitive dependencies). A) First B) Fourth C) Third D) Second
C Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
41) A ________ is an attribute that appears as a non-primary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation. A) Referential integrity B) Primary key C) Foreign key D) Unique key
C Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
46) ________ is NOT a valid degree of the relationship. A) Binary B) Unary C) N-ary D) Ternary
C Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
60) In some situations, two or more attributes may have different names but the same meaning, as when they describe the same characteristic of an entity. Such attributes are called ________. A) Homonyms B) Antonyms C) Synonyms D) Duplicates
C Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
58) Which relation is created with a composite primary key (which includes the primary key of the entity on which this weak entity depends) and non-key attributes? A) Associative entity with additional key B) Super-type C) Regular entity D) Weak entity
D Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
14) Each ________ of a relation corresponds to a record that contains data values for an entity. A) Column B) Entity C) Attribute D) Row
D Difficulty: Easy AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
33) The result of normalization is that every ________ key attribute depends upon the whole primary key. A) Candidate B) Unique C) Primary D) Non-primary
D Difficulty: Easy AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
75) ________ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields. A) Partitioning B) Modeling C) Normalization D) De-normalization
D Difficulty: Easy AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
16) In a relation, each row is unique and uniqueness is guaranteed because the relation has a non-empty ________ key value. A) Unique B) Composite C) Candidate D) Primary
D Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
4) In logical database design, we use a process called ________, which is a way to build a data model that has the properties of simplicity, non-redundancy, and minimal maintenance. A) Data modeling B) Database designing C) De-normalization D) Normalization
D Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
8) In logical database modeling and design, we translate the ________ E-R data model for the application or enterprise, developed without explicit consideration of specific user interfaces, into normalized data requirements. A) Normal B) Physical C) Logical D) Conceptual
D Difficulty: Moderate AACSB: Information Technology LO: 9.1 Describe the database design process, its outcomes, and the relational database model
30) In ________ normal form, each non-primary key attribute is identified by the whole key (what we call full functional dependency). A) First B) Fourth C) Third D) Second
D Difficulty: Moderate AACSB: Information Technology LO: 9.2 Describe normalization and the rules for second and third normal form
43) 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. A) Foreign key B) Index C) Unique key D) Primary key
D Difficulty: Moderate AACSB: Information Technology LO: 9.3 Transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations
54) Which relation is created with a composite primary key using the primary keys of the related entities and additional primary key attributes associated with the relationship or associative entity, plus any non-key attributes of the relationship or associative entity? A) Binary 1:N relationship B) Associative entity C) Associative entity with its own key D) Associative entity with additional key
D Difficulty: Moderate AACSB: Information Technology LO: 9.4 Merge normalized relations from separate user views into a consolidated set of well-structured relations
70) We begin the physical design phase by addressing the design of physical fields for each attribute in a ________ data model. A) Conventional B) Conceptual C) Physical D) Logical
D Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
79) A computer operating system stores data in a ________, which is a named set of table rows stored in a contiguous section of secondary memory. A) Disk B) Tablespace C) Table D) Physical file
D Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
88) A null value is the value a field will assume unless an explicit value is entered for the field.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
89) A physical table is a named set of rows and columns that specifies the fields in each column of the table.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
91) In range partitioning, a table row is assigned to a partition by an algorithm and then maps the specified attribute value to a partition.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
92) Range partitioning combines range and hash partitioning by first segregating data by ranges on the designated attribute, and then within each of these partitions, it further partitions by hashing on the designated attribute.
FALSE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
90) The capability to split a table into separate sections is possible with most relational database products.
TRUE Difficulty: Moderate AACSB: Information Technology LO: 9.5 Describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed
