click below
click below
Normal Size Small Size show me how
bus 173
CH3 4 5
| Question | Answer |
|---|---|
| During the implementation phase of developing a database system, the data model is transformed into a database design. | FALSE |
| ) When developing a database system, the database is constructed during the implementation phase. | TRUE |
| During the design phase of developing a database system, the users are asked about the need for changes to existing forms and reports. | FALSE |
| A use case is a description of the way a user will employ the features and functions of the new system. | TRUE |
| Use cases can be used to validate the data model, design, and implementation. | TRUE |
| System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model. | FALSE |
| The PRODUCT entity instance is the collection of all PRODUCT entity classes. | FALSE |
| An entity class is described by the structure of the entities in that class. | True |
| 10) There is usually only one instance of an entity in an entity class. | FALSE |
| 11) The E-R Model assumes that all instances of a given entity class have the same attributes. | TRUE |
| 12) An entity identifier can be either unique or nonunique. | TRUE |
| 13) The number of entity classes involved in a relationship is the cardinality of the relationship. | FALSE |
| 14) It is possible for an entity to have a relationship to itself. | TRUE |
| 15) Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class. | FALSE |
| 16) One type of strong entity is the ID-dependent entity. | FALSE |
| 17) In crow's foot E-R notation, the crow's foot indicates a maximum cardinality of one. | FALSE |
| 18) In crow's foot E-R notation, a circle indicates a minimum cardinality of zero. | TRUE |
| 19) In crow's foot E-R notation, the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one. | TRUE |
| 20) Subtype entities may be either exclusive or inclusive. | TRUE |
| 21) Microsoft Access can be used to build a prototype database, which allows users to validate the data model by demonstrating the consequences of data modeling decisions. | Answer: TRUE |
| 22) Microsoft Access wizards allow easy mock-ups of forms and reports for prototyping. | Answer: TRUE |
| 23) Microsoft Access is only used to prototype databases where Access itself will be the final DBMS. | FALSE |
| 24) Microsoft Access database files can be easily copied to create multiple copies of a database. | TRUE |
| 25) Microsoft Access uses banded form and report editors. | TRUE |
| 26) Which of the following is not a stage in the development of a database system? A) Requirements B) Validation C) Design D) Implementation E) All of the above are stages in the development of a database system. | Answer: B |
| 27) The representation of the content, relationships, and constraints of the data needed to support the system requirements is the: A) relation design. B) implementation. C) data model. D) data view. E) application program. | Answer: C |
| 28) Which of the following activities is not performed during the implementation phase of developing a database system? A) Filling the database with data B) Transforming the data model into a database design C) Writing application programs D) Creating | Answer: B |
| 29) Which of the following is not a source for user requirements during the requirements stage of developing a database system? A) Business rules B) User interviews C) Forms D) Use cases E) All of the above are sources for user requirements | Answer: E |
| 30) Which of the following would not be contained in a use case? A) Inputs provided to the system to perform a task B) A description of a task the user wants to perform C) A prototype of the system performing a given task D) Outputs generated by the s | Answer: C |