MIS 307 CHAPTER 8 and 9 EXAM 3 | Mississippi State University

Document Content and Description Below

Mississippi State University MIS 307 FALL 2022 CHAPTER 8 and 9 EXAM 3 MULTIPLE CHOICE (Answer on green scantron with no. 2 pencil) 1) The most common format used for data modeling is ________ dia... gramming. A) Entity-class B) Entity-object C) Entity-subject D) Entity-relationship 2) During requirements structuring, a ________ model represents conceptual data requirements for a particular system. A) Business B) Project C) Data D) Relationship 3) A(n) ________ data model is a detailed model that captures the overall structure of organizational data that is dependent on the database management system or other implementation considerations. A) Conceptual B) Physical C) Logical D) Entity 4) What field serves as the unique identifier to records for a table? A) Secondary key B) Primary key C) Composite key D) Index 5) _________ eventually become the fields in a table when modelling a database. A) Attributes B) Entities C) Records D) Index 6) An ________ model is a detailed, logical representation of the entities, associations, and data elements for an organization or business area. A) E-D B) E-O C) E-R D) E-A 7) A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. A) Dimension B) Attribute C) Object D) Entity     8) An entity ________ is a collection of entities that share common properties or characteristics. A) Object B) Type C) Subject D) Relationship 9) An entity ________ is a single occurrence of an entity type. A) Instance B) Object C) Attribute D) Class 10) A(n) ________ is a named property or characteristic of an entity that is of interest to the organization. A) Event B) Instance C) Relationship D) Attribute 11) A(n) ________ is an association between the instances of one or more entity types that is of interest to the organization. A) Attribute B) Repeating group C) Relationship D) Identifier 12) The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A. A) Cardinality B) Relationship C) Identifier D) Association 13) __________ cardinality is represented by a vertical line and means that one instance of a relationship between tables is required. A) Minimum B) Absolute C) Maximum D) Aggregate 14) __________ cardinality is represented by an oval and means that an instance of a relationship between tables is not required. A) Minimum B) Absolute C) Maximum D) Aggregate     15) Another name for a table is a ____________. A) set B) relation C) bracket D) field 16) 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 17) ________ 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 18) In database design, we use a process called ________, which is a way to build a data model that represents one and only one entity. A) Data modeling B) Database designing C) De-normalization D) Normalization 19) A(n) ________ is an attribute whose value is unique across all occurrences of a relation. A) Composite key B) Primary key C) Identifier D) Index 20) During logical database design, you must account for every data _________ on a system input or output form or report. A) element B) key C) object D) logic 21) In a ________ database model, data is represented as a set of related tables or relations. A) Logical B) Conventional C) Relational D) Physical     22) A relation is a ________-dimensional representation of an entity. A) Two B) One C) Three D) Four 23) Each ________ in a relation corresponds to an attribute of that relation. A) Entity B) Data C) Column D) Row 24) Each ________ of a relation corresponds to a record that contains data values for an entity. A) Column B) Entity C) Attribute D) Row 25) 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 26) A ________ is an attribute that appears as a non-primary key attribute in one relation and as a primary key attribute in another relation. A) Referential integrity B) Primary key C) Foreign key D) Unique key 27) Each regular entity type in an E-R diagram is transformed into a(n) ________. A) Identifier B) Relation C) Attribute D) Row 28) Data models that are not complete are said to have __________. A) Conditions B) Action questions C) Rules violations D) Requirement gaps 29) ______ can be reorganized within a table without it changing the meaning of the overall entity. A) Fields B) Relationships C) Data values D) Metadata     30) It is always a good idea to have ________ validate a data model. A) users B) competitors C) third party vendors D) counselors [Show More]

Last updated: 3 months ago

Preview 1 out of 5 pages