IST 3343 Ch 9 - Test Bank VERIFIED ANSWERS

IST 3343 Ch 9 - Test Bank One of the purposes of logical and physical database design is to choose data-storage technologies that will efficiently, accurately, and securely process database activities. - correct answers True The selection of data-storage technologies is made during the systems implementation and operation phase. - correct answers False The network model is the most common style for a logical database model. - correct answers False Normalization helps build a data model that is simple, not redundant, and requires minimum maintenance. - correct answers True Conceptual modeling is performed during systems design. - correct answers False The selection of the appropriate storage format for each attribute from the logical database model is made during physical database design. - correct answers True A relation corresponds to a computer file. - correct answers False Each column in a relation corresponds to an entity type - correct answers False Each row of a relation corresponds to a record that contains data values for an entity. - correct answers True Referencing a relation, the sequence of columns cannot be interchanged without changing the meaning or use of the relation. - correct answers False If for every valid value of A the value of B is determined by the value of A, then B is functionally dependent on A. - correct answers True A default value is a value a field will assume unless an explicit value is entered for that field. - correct answers True A null value is used to represent the zero digit in a relation. - correct answers False Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications. - correct answers False The most common style for a logical database model is the: a. relational database model. b. hierarchical database model. c. network database model. d. object-oriented database model. e. hybrid database model. - correct answers a. relational database model. A data model that represents data in the form of tables or relations is called a(n):