Information Systems and SDLC Quiz

<p>Assessing the need and extent of the information system (C)</p> Signup and view all the answers

<p>Web server (A)</p> Signup and view all the answers

<p>Data and Code (B)</p> Signup and view all the answers

<p>Iterative processes allow for adjustments and improvements throughout the process. (C)</p> Signup and view all the answers

<p>All of the above (D)</p> Signup and view all the answers

<p>Select the central entity in the model (B)</p> Signup and view all the answers

<p>All of the above (D)</p> Signup and view all the answers

<p>All of the above (D)</p> Signup and view all the answers

<p>Gather and document user requirements. (A)</p> Signup and view all the answers

<p>Conducting user acceptance testing. (D)</p> Signup and view all the answers

<p>To translate the conceptual design into a software-specific model (C)</p> Signup and view all the answers

<p>Installing hardware and software, and creating the database. (C)</p> Signup and view all the answers

<p>Physical storage allocation (B)</p> Signup and view all the answers

<p>Corrective maintenance. (B)</p> Signup and view all the answers

<p>Creating a more efficient and standardized development process. (C)</p> Signup and view all the answers

<p>System analysis. (C)</p> Signup and view all the answers

<p>Understanding the company's mission, structure, and operations. (B)</p> Signup and view all the answers

<p>The expectations of end users. (A)</p> Signup and view all the answers

<p>Finding precise answers to complex questions. (C)</p> Signup and view all the answers

<p>The number of users accessing the database (A)</p> Signup and view all the answers

<p>Lack of standardized performance metrics (D)</p> Signup and view all the answers

<p>Incremental backup (B)</p> Signup and view all the answers

<p>Enforcing referential integrity between tables (D)</p> Signup and view all the answers

<p>Re-training users on database usage procedures (D)</p> Signup and view all the answers

<p>Declarative maintenance (B)</p> Signup and view all the answers

<p>Top-down focuses on data sets while bottom-up focuses on data elements (D)</p> Signup and view all the answers

<p>To distribute transaction processing across multiple servers (D)</p> Signup and view all the answers

<p>To identify a specific record within a table (D)</p> Signup and view all the answers

<p>To ensure data consistency and maintainability (B)</p> Signup and view all the answers

<p>To create an abstract structure that represents real-world objects and data. (B)</p> Signup and view all the answers

<p>To ensure that the system can accurately represent and process all relevant information. (C)</p> Signup and view all the answers

<p>The business view focuses on data as information source, while the designer's view focuses on data structure, access, and activities to transform data into information. (A)</p> Signup and view all the answers

<p>Data analysis and requirements, entity relationship modeling, normalization, and data model verification. (A)</p> Signup and view all the answers

<p>To create a graphical representation of entities and their relationships within the database. (C)</p> Signup and view all the answers

<p>To ensure that the database model accurately reflects the proposed system processes and business requirements. (A)</p> Signup and view all the answers

<p>A component of the database that handles a specific function or task. (D)</p> Signup and view all the answers

<p>Defining the physical storage layout and access methods. (B)</p> Signup and view all the answers

<p>It is commonly used in large, complex systems with a high volume of data. (D)</p> Signup and view all the answers

<p>Managing the complexity of data relationships and operations across various locations. (C)</p> Signup and view all the answers

<p>Top-down focuses on the overall data model first, whereas bottom-up starts with individual data elements. (A)</p> Signup and view all the answers

<p>Identifying and reconciling conflicting definitions for the same entity in different subsystems. (A)</p> Signup and view all the answers

How a system interacts with other systems in a company.

Extent of design based on operational requirements.

Limits that are external to the system.

An abstract database structure representing real-world objects.

A technique to visualize and design data structures.

The process of confirming the design meets system processes.

Data utilized as a source of information for business decisions.

An information system component that performs a specific function.

A system for data collection, storage, and retrieval, composed of people, hardware, software, databases, applications, and procedures.

The process that establishes the need for and extent of an information system.

The process of creating an information system from analysis to implementation.

Transform data into information for decision making, resulting in reports, tabulations, and displays.

The process of designing and implementing a database, including its storage structures and data management.

A cycle tracing the history of a system through planning, analysis, design, implementation, and maintenance.

Overview of company objectives and assessment of system requirements.

A method in SDLC where phases repeat based on evaluation, not strictly sequential.

The primary entity in a data model based on its relationships.

Methods for managing how data is stored across locations in a distributed database.

Critical elements to consider when choosing a Database Management System.

The process of translating conceptual design into a specified internal model.

Definitions that specify the permissible values for attributes in a database.

A data component with many entities and complex operations across sites.

A data structure composed of a small number of objects and procedures.

Challenges in integrating modules such as synonyms and conflicting definitions.

System Development Life Cycle; traces the history of an application in the information system.

Database Life Cycle; describes the history of a database within the information system.

The structured phases of database development including initial study, design, implementation, testing, operation, and maintenance.

The phase focused on analyzing the company's situation, defining problems, constraints, objectives, and scope.

Assessing technical requirements, system cost, and operational costs for proposed database solutions.

The phase where hardware, software, and application programs are installed and the database design is executed.

Three activities in maintenance: corrective, adaptive, and perfective maintenance to ensure system longevity.

The phase where the designer completes the design for system processes including technical specifications.

Thorough examination of user needs and existing systems to identify functional areas and problems.

The phase where the implemented database undergoes rigorous testing to ensure functionality and satisfaction.

The process of detailing how data will be stored, organized, and accessed within the database.

Methodologies planned during the design phase to ensure users are equipped to operate the new system effectively.

The process of selecting data storage and access characteristics of a database.

Methods of database backup: full, differential, and transaction log backups.

Rules ensuring data accuracy using primary and foreign keys.

Assessing a DBMS’s efficiency, though tools may not be standard.

Ensuring database protection through physical security, access rights, and data encryption.

Simultaneous evaluation and prototyping during application programming.

Design strategy that starts by identifying data sets and defining their elements.

Design strategy that identifies data elements first and groups them into sets.

Stage where the database is active and operational after passing evaluations.