Q&A Hero

Q: Generally speaking, a physical table always corresponds to a relation.

Q: Efficient use of secondary storage and data processing speed are the two goals of physical table design.

Q: A null value is used to represent the zero digit in a relation.

Q: A default value is a value a field will assume unless an explicit value is entered for that field.

Q: Two different names used for the same attribute is called a synonym.

Q: Two different names used for the same attribute is called a homonym.

Q: View integration is the last step of logical database design.

Q: When modeling a many-to-many unary relationship, the primary key of the relation representing the relationship is always singular.

Q: A recursive foreign key is a foreign key in a relation that references the primary key value of the same relation.

Q: A corporal key is one assigned by the system.

Q: When two relations, A and B, have a many-to-many relationship, we create a separate relation, C, to represent this.

Q: For a binary one-to-one relationship between two entities, A and B, the primary key of A becomes a foreign key in B and the primary key in B becomes a foreign key in A.

Q: A binary 1 to many relationship in an ER Diagram is represented by adding the primary key of the entity on the one side of the relationship as a foreign key to the entity on the many side.

Q: A key can be redundant.

Q: The value of a key attribute in a relation must uniquely identify every row in the relation.

Q: Each entity type in an ER Diagram becomes an attribute.

Q: Referential integrity specifies that the value of an attribute of one relation depends on the existence of the same attribute in another relation.

Q: The creation of a separate relation is sometimes required to represent a relationship.

Q: A business rule is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Q: A relation is said to be in second normal form when there are no transitive dependencies.

Q: Transitive attributes are attributes that determine other attributes.

Q: A relation is said to be in second normal form if the primary key consists of only one attribute.

Q: A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key.

Q: A relation is said to be in second normal form if the primary key consists of a combination key, and the nonkey attributes are partially dependent on the primary key.

Q: An attribute can be functionally dependent on more than one attribute.

Q: 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.

Q: Normalization is based on an analysis of weak entities.

Q: The result of normalization is that every nonprimary key attribute depends upon the whole primary key and nothing but the primary key.

Q: A well-structured relation contains data about two or more entities.

Q: Referencing a relation, the sequence of columns cannot be interchanged without changing the meaning or use of the relation.

Q: One property of a relation is that entries in columns are from the same set of values.

Q: Each row of a relation corresponds to a record that contains data values for an entity.

Q: Each column in a relation corresponds to an entity type.

Q: Object-oriented database models are the most frequently used database technologies for new information systems development.

Q: The network database model is a popular database technology for new information systems.

Q: During physical database design, relations from logical database design are translated into computer file specifications.

Q: A relation corresponds to a computer file.

Q: When using the normalized relation notation, the primary key attribute is indicated by a dashed underline.

Q: The primary deliverable from logical database design is a conceptual model.

Q: A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored, retrieved, and updated rapidly.

Q: In general, data structure refers to grouping attributes from the logical database model into physical records.

Q: The selection of the appropriate data types of attributes from the logical database model is made during physical database design.

Q: Conceptual modeling is performed during systems design.

Q: During logic modeling, the normalized data requirements from all user interfaces are combined into one consolidated logical database model.

Q: Normalization helps build a data model that is simple, not redundant, and requires minimum maintenance.

Q: Generally speaking, logical and physical database design is performed in parallel with other systems design steps.

Q: The network model is the most common style for a logical database model.

Q: The selection of data-storage technologies is made during the systems implementation and operation phase.

Q: 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.

Q: The major deliverables associated with the human interface design stage are: A) process models. B) the Baseline Project Plan and structure charts. C) logic models. D) design specifications. E) program specifications.

Q: When designing a form or report, which of the following is a fundamental question? A) Who will pay for the form or report? B) What reports will be removed? C) When is the form or report needed and used? D) Where will the report be housed? E) How will the report be marketed?

Q: Form and report design: A) generally follows a prototyping approach. B) generally follows a structured methodology. C) generally follows a structured design approach. D) generally follows a structured analysis approach. E) uses Structured English to prepare the design specifications.

Q: Each of the following are true statements EXCEPT: A) every output form or report is a data flow produced by a process on a data-flow diagram. B) forms have a stylized format and are usually not in simple rows and columns. C) a report is only for reading and often contains data about multiple unrelated records in a computer file. D) a form typically contains data from only one record. E) systems inputs and outputs are produced during the systems implementation and operation phase of the systems development life cycle.

Q: Which of the following is an example of a report? A) Mailing labels B) Computer sign-on screen C) Electronic spreadsheet D) Automated teller machine transaction layout E) Class registration sheet

Q: Which of the following best describes a business document that contains only predefined data? A) Electronic spreadsheet B) Turn-around document C) Form D) Report E) Coupon

Q: Which of the following is an example of a form? A) Invoice B) Pie chart C) Mailing labels D) An electronic spreadsheet E) Weekly sales summaries by region and salesperson

Q: Which of the following is an example of a form? A) Invoice B) Pie chart C) Mailing labels D) Weekly sales summaries by region and salesperson E) Automated teller machine transaction layout

Q: A business document that contains some predefined data and may include some areas where additional data are to be filled in best describes a: A) written procedure. B) turn-around document. C) form. D) report. E) coupon.

Q: Which of the following is the standard method of gathering and displaying information on the Internet? A) Dialogue interaction B) Form interaction C) Report interaction D) Menu selection E) VRML interaction

Q: System inputs and outputs are produced at the end of the: A) systems analysis phase of the SDLC. B) systems design phase of the SDLC. C) systems planning and selection phase of the SDLC. D) systems implementation and operation phase of the SDLC. E) logic modeling stage.

Q: Which of the following is a method for representing human-computer dialogues? A) Logic modeling B) Sequence modeling C) Process modeling D) Dialogue diagramming E) Transition diagramming

Q: Human interface design is performed during: A) systems planning and selection. B) systems analysis. C) systems design. D) systems implementation and operation. E) requirements structuring.

Q: Building dialogue prototypes and assessing usability are often optional activities.

Q: An audit trail is a record of the sequence of data entries and the date of those entries.

Q: When data are processed online, it is less likely that data-validity errors will be caught.

Q: The size validation test tests for too few or too many characters.

Q: The values validation test makes sure that values come from a standard set of values.

Q: When a transcripting data error occurs, additional characters have been added to a field.

Q: When an appending data error has occurred, characters have been lost from the field.

Q: When structuring data entry fields, the system should automatically justify data entries.

Q: When structuring data entry fields, always have the user enter the current date.

Q: Functional capabilities for providing smooth and easy navigation within a form include cursor-control, editing, exit, and help capabilities.

Q: Good interface design provides a consistent way for moving the cursor to different places on the form, editing characters and fields, moving among form displays, and obtaining help.

Q: Referencing interface layout guidelines, data should not be permanently saved by the system until the user makes an explicit request to do so.

Q: When designing the navigation procedures within a system, the primary concerns are dialogue flow and the instructional features.

Q: Referencing interface layout guidelines, users should not be able to access areas of the screen not used for data entry or commands.

Q: Referencing interface layout guidelines, data fields should be grouped into logical categories with labels describing the contents of the category.

Q: Referencing interface layout guidelines, the standard screen navigation that users use to move between fields should be from left-to-right and top-to-bottom.

Q: Display sequence refers to the way a user can move from one display to another.

Q: The JAD approach is used for designing interfaces and dialogues.