Q&A Hero

Humanities

Q: The hierarchical model is software-independent.
Q: The entity relationship model is limited to conceptual modeling, with no implementation component.
Q: The network model has structural level dependence.
Q: Today, most relational database products can be classified as object/relational.
Q: M:N relationships are not appropriate in a relational model.
Q: In Chen notation, entities and relationships must be oriented horizontally.
Q: Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
Q: End-user interfaces require the end user to manually generate SQL code.
Q: In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
Q: In an SQL-based relational database, each table is dependent on another.
Q: Business rules must be rendered in writing.
Q: Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.
Q: Database designers determine the data and information that yield the required understanding of the entire business.
Q: A manager and a programmer usually have the same view of the same data.
Q: Data modeling starts with a very complex representation, and as knowledge of the problem is gained, the model is simplified.
Q: Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.
Q: An implementation-ready data model should contain a description of the data structure that will store the end-user data.
Q: The terms data model and database model are often used interchangeably.
Q: A data model is usually graphical.
Q: Explain the differences between a centralized and decentralized approach to database design.
Q: What are the classical approaches to database design?
Q: What are the factors affecting the purchasing decision for DBMS software?
Q: Database backups can be performed at different levels. List and describe these.
Q: List and briefly describe the three types of system maintenance activities.
Q: ____________________ design could become a very technical job that affects not only the accessibility of the data in the storage device(s) but also the performance of the system.
Q: The ____________________ design goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.
Q: When selecting DBMS ____________________, consider processor(s), RAM, disk space, and so on.
Q: The term "module ____________________" describes the extent to which modules are independent of one another.
Q: A(n) ____________________ is an information system component that handles a specific business function, such as inventory, orders, payroll, and so on.
Q: Because real-world database design is generally done by teams, you should strive to organize the design's major components into ____________________.
Q: A(n) ____________________ rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.
Q: From a database point of view, the collection of data becomes meaningful only when the business ____________________ are defined.
Q: In order to develop an accurate data ____________________, the designer must have a thorough understanding of the company's data types, extent, and uses.
Q: The first step in ____________________ design is to discover the data element characteristics.
Q: The ____________________design stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.
Q: A(n) ____________________ log backup backs up only the transaction log operations that are not reflected in a previous backup copy of the database.
Q: ____________________ security allows the assignment of access rights to specific authorized users.
Q: The implementation of the logical design in IBM's DB2 would require that you assign the rights to use the database to a(n) _________________________.
Q: Making sure that the final product meets user and system requirements is the most critical ______________________________ phase.
Q: The proposed system is subject to limits known as ____________________, which are external to the system.
Q: The system's ____________________ defines the extent of the design according to operational requirements.
Q: The company ____________________ describes the general conditions in which a company operates, its organizational structure, and its mission.
Q: The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.
Q: After testing is concluded, the final ____________________ is reviewed and printed and end users are trained.
Q: The database contents may be loaded interactively or in ____________________ mode.
Q: An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.
Q: The traditional SDLC phases are ____________________, analysis, detailed systems design, implementation, and maintenance.
Q: ____________________ is the process that establishes the need for, and the extent of, an information system.
Q: A(n) ____________________ is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.
Q: During decentralized design, after the ____ process has been completed, all modules are integrated into one conceptual model.a. initial b. verification c. conceptuald. logical
Q: There are ____ classical approaches to database design.a. two b. three c. fourd. five
Q: The ____ design is the process of selecting the data storage and data access characteristics of the database.a. time b. network c. logicald. physical
Q: ____ coupling describes the extent to which modules are independent of one another.a. Verification b. Process c. Moduled. Cohesive
Q: The first step in the ER model verification process is to ____. a. identify each module and its components b. identify the ER model's central entity c. verify all processes against the ER model d. identify each module's internal transaction requirements
Q: The first step in developing the conceptual model using ER diagrams is to ____. a. normalize the entities b. complete the initial ER diagram c. identify, analyze, and refine the business rules d. define the attributes, primary keys, and foreign keys for each of the entities
Q: The maintenance and evolution phase of the DBLC involves ____.a. defining objectives b. introducing changes c. testing the databased. installing the DBMS
Q: Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.a. programmer b. manager c. database administratord. systems administrator
Q: ____ allow(s) physical access to areas by authorized personnel only.a. Physical security b. Password security c. Access rights d. Data encryption
Q: The conceptual design step that defines the DBMS and data model to use is ____. a. database analysis and requirements b. ER modeling and normalization c. data-model verification d. distributed database design
Q: The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____. a. database analysis and requirements b. ER modeling and normalization c. data-model verification d. distributed database design
Q: The conceptual design step that defines entities, attributes, and relationships is ____. a. database analysis and requirements b. entity relationship modeling and normalization c. data model verification d. distributed database design
Q: The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____. a. data analysis and requirements b. entity relationship modeling and normalization c. data model verification d. distributed database design
Q: The implementation and loading phase of the DBLC involves ____.a. defining objectivesb. introducing changes c. testing the databased. installing the DBMS
Q: The database initial study phase of the DBLC involves ____.a. defining objectives b. introducing changes c. testing the databased. installing the DBMS
Q: The first step in the DBLC is ____.a. operation b. database initial study c. database designd. implementation and loading
Q: The last step in the DBLC is ____.a. maintenance and evolutionb. operation c. testing and evaluationd. implementation and loading
Q: Producing the required information flow is part of the ____ phase of the DBLC.a. database initial study b. database design c. operationd. testing and evaluation
Q: Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.a. database initial study b. database design c. implementation and loadingd. testing and evaluation
Q: Installing the DBMS, creating the database, and loading or converting the data are part of the ____ phase of the DBLC.a. database initial study b. database design c. implementation and loadingd. testing and evaluation
Q: Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC.a. database initial study b. database design c. implementation and loadingd. testing and evaluation
Q: Analyzing the company situation is part of the ____ phase of the DBLC. a. database initial study b. database design c. implementation and loading, testing, and evaluation d. operation
Q: The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.a. database b. network c. CASEd. design
Q: There are ____ stages in the DBLC.a. four b. five c. sixd. seven
Q: The database is loaded during the ____ phase of the SDLC.a. analysis b. detailed systems design c. implementationd. maintenance
Q: The design of the system's processes is completed during the ____ phase of the SDLC.a. planning b. analysis c. detailed systems designd. implementation
Q: The logical systems design is created during the ____ phase of the SDLC.a. planning b. analysis c. implementationd. maintenance
Q: "What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.a. planning b. analysis c. implementationd. maintenance
Q: "Should the existing system be replaced?" is a question that is asked during the ____ stage of the SDLC.a. planning b. analysis c. implementationd. maintenance
Q: The SDLC is most important to the ____.a. programmer b. manager c. system designerd. database administrator
Q: Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.a. planning b. maintenance c. detailed systems designd. implementation
1 2 3 … 391

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts