Business Final

· Which of the following best describes a unique sequential number or random number assigned by the database management system (DBMS) whenever a new record is added to a table?

o Auto number

· Which of the following is a type of system documentation?

o Data-flow diagrams

· The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

o Denormalization

· The purpose of acceptance testing is to:

o Determine if the system meets user requirements

· For a unary one-to-one relationship between two entities A and B, the relationship is represented by:

o Either adding the primary key of A as a foreign key of B or adding the primary key of B as a foreign key of A

· A corporal key is one assigned by the system.

o False

· A key can be redundant.

o False

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

o False

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

o False

· Baseline routines are guidelines that list the instructions to construct an executable system from the baseline source code.

o 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.

o False

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

o False

· Each column in a relation corresponds to an entity type.

o False

· Each entity type in an ER Diagram becomes an attribute.

o False

· Internal documentation is system documentation that includes the outcome of structured diagramming techniques such as data flow and entity-relationship diagrams.

o False

· Multiple key retrieval is possible with the hashed file organization.

o False

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

o False

· Sequential files are practical for random row retrievals.

o False

· Sequential retrieval on the primary key is very fast with the hashed file organization.

o False

· Transitive attributes are attributes that determine other attributes.

o False

· An attribute that appears as a nonkey attribute in one relation and as a primary key attribute (or part of a primary key) in another relation is a:

o Foreign key

· If order number serves as the primary key in the order relation and also appears as a nonkey attribute in the invoice relation, then order number is said to be a:

o Foreign key

· A particular relationship between two attributes best defines:

o Functional Dependency

· A testing technique in which participants examine program code for predictable language-specific errors defines:

o Inspections

· The process of bringing together all of the modules that comprise a program for testing purposes is referred to as:

o Integration testing

· All of the following are types of file organizations EXCEPT:

o Logical

· The process of converting complex data structures into simple, stable data structures is referred to as:

o Normalization

· Common methods for automating support include:

o Online support forums o Voice-response systems o On-demand fax o Bulletin board systems

· A foreign key in a relation that references the primary key values of that same relation is referred to as a:

o Recursive foreign key

· Relationships between instances of a single entity type are referred to as:

o Recursive relationships

· The integrity constraint that specifies that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation is called:

o Referential integrity

· "Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?

o Regular entity

· A named two-dimensional table of data is a(n):

o Relation

· The most common style for a logical database model is the:

o Relational database model

· This type of user documentation contains information about a new system release, including a list of complete documentation for the new release, features and enhancements, known problems and how they have been dealt with in the new release, and information about installation.

o Release description

o The preparation of a final conceptual model and the implementation of the database

o Second normal form

· When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:

o Second normal form

· Two different names that are used to refer to the same data item best defines:

o Synonym

· This type of user documentation is intended primarily for those who will install and administer a new system and contains information about the network on which the system will run, software interfaces for peripherals such as printers, troubleshooting, and setting up user accounts.

o System Administrator's guide

· During physical design, you consider:

o The definitions of each attribute o The descriptions of where an when data are entered, retrieved, deleted, and updated o The expectations for response time and data integrity o The descriptions of the file and database technologies to be used

· Which of the following is NOT associated with logical and physical database design?

o The preparation of a final conceptual model and the implementation of the database

· During logical database design, the work of all systems development team members is coordinated and shared through:

o The project dictionary

· For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:

o Then B is said to be functionally dependent on A

· The dependence of nonprimary key attributes on other nonprimary key attributes best describes a:

o Transitive dependency

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

o True

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

o True

· A test case is a specific scenario of transactions, queries, or navigation paths that represent a typical, critical, or abnormal use of the system.

o True

· Denormalization is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

o True

· Desk checking is a testing technique in which the program code is sequentially executed manually by the reviewer.

o True

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

o True

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

o True

· File restoration can be achieved through backup copies of a file, audit trails, and row image files.

o True

· 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.

o True

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

o True

· Indexes should be used generously for databases intended primarily to support data retrievals.

o True

· Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

o True

· Information systems personnel and end users are the two audiences for the final systems documentation.

o True

· Installation is the organizational process of changing over from the current information system to a new one.

o True

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

o True

· The systems design phase of the SDLC is analogous to the maintenance process of designing changes.

o True

· The systems implementation and operation phase of the SDLC is analogous to the maintenance process of implementing changes.

o True

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

o True

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

o True

· User documentation is now most often delivered in hypertext format.

o True

· View integration is the last step of logical database design.

o True

· Walkthroughs are a very effective method for identifying errors in code.

o True

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

o True

· When using the sequential file organization, the addition of rows requires rewriting the file.

o True

· Merging relations is also referred to as:

o View integration

· If an associative entity exists, then:

o a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship.

· For a unary M:N relationship:

o the entity type is modeled as one relation; a separate relation is created to represent the M:N relationship; the new relation has a composite key that consists of two attributes that both take their values from the same primary key.

· Using the term "account" to refer to a checking account and also to a savings account is an example of a(n):

Homonym

· The hashed file organization determines the address for each row by using an algorithm.

True

· Using the normalized relation notation, an attribute of a relation which is the primary key of another relation is indicated by:

o A dashed underline

· If a relationship exists among three or more entities, then:

o A separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created

· The most complete acceptance testing will include:

o Alpha testing, beta testing, and a system audit

· A many-to-many relationship that associates certain items with their component items is called a:

o Bill-of-materials structure

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

o False

· 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.

o False

· Unit testing is a technique used in testing modules, especially where modules are written and tested in a top-down fashion, where a few lines of code are used to substitute for subordinate modules.

o False

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

o False

Most user documentation is now delivered

o Online, in hypertext format

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

o True