Untitled Deck

Question 1

What are the main themes covered in Chapter 5: Data and Process Modeling?

Answer 1

• Logical vs. Physical Models
• DFDs
• Balancing
• Decomposition
• Data Dictionary
• Structured English

These themes focus on the modeling of data and processes in systems analysis.

Question 2

Define Data Flow Diagram (DFD).

Answer 2

A visual representation of the flow of data within a system. A DFD shows how data moves through an information system but does not show program logic or processing steps. A set of DFDs provides a logical model that shows what the system does, not how it does it.

DFDs help in understanding how data moves through processes.

Question 3

What is the difference between a black box and a black hole in system modeling?

Answer 3

• Black Box: Process with unknown internal workings
• Black Hole: Process that receives input but produces no output

Understanding these concepts is crucial for integration in systems.

Question 4

What is the role of a Terminator in a DFD?

Answer 4

A data flow diagram symbol indicating a data origin or final destination. Also called an external entity.

Terminators are essential for defining system boundaries.

Question 5

What is a Context Diagram?

Answer 5

A top-level view of an information system that shows its boundaries and scope.

It provides a simplified view of the system’s environment.

Question 6

Explain the concept of **Balancing

Answer 6

Balancing: A process used to maintain consistency among an entire series of diagrams, including input and output data flows, data definition, and process descriptions.

These techniques ensure that data flow is consistent across different levels of diagrams.

Question 7

Explain the concept of **Leveling

Answer 7

The process of drawing a series of increasingly detailed diagrams to reach the desired level of detail. Leveling also is called exploding, partitioning, or decomposing.

Question 8

What is included in a Data Dictionary?

Answer 8

A central storehouse of information about a system’s data.

A data dictionary provides a comprehensive description of data elements used in the system.

Question 9

What is Field

Answer 9

Data element descriptions. Also called a data item or field, a data element is the smallest piece of data that has meaning within an information system. For example, a Social Security number or company name could be examples of a data element.

Question 10

What is record?

Answer 10

A record is a meaningful combination of related data elements included in a data flow or retained in a data store.

Question 11

What are Data Elements?

Answer 11

A single characteristic or fact about an entity. A data element, field, or attribute is the smallest piece of data that has meaning within an information system. For example, a Social Security number or company name could be examples of a data element. Also called data item.

Data elements are the basic units of data that are processed in a system.

Question 12

Validity rule

Answer 12

Checks that are applied to data elements when data is entered to ensure that the value entered is valid. For example, a validity rule might require an employee’s salary number to be within the employer’s predefined range for that position.

Question 13

Acceptable values

Answer 13

Checks that are applied to data elements when data is entered to ensure that the value entered is valid. For example, a validity rule might require an employee’s salary number to be within the employer’s predefined range for that position.

Question 14

What is a Process Diagram?

Answer 14

A visual representation of the modular design and results of processes

It helps in understanding how processes interact and produce outcomes.

Question 15

What is modular design?

Answer 15

A design that can be broken down into logical blocks. Also known as partitioning or top-down design.

Question 16

Each logical structure must have a single entry and exit point….

Answer 16

sequence, selection, and iteration.

Question 17

Define Structured English.

Answer 17

Structured English is a subset of standard English that describes logical processes clearly and accurately.

It simplifies the representation of logic in processes.

Question 18

What is the purpose of a Decision Tree?

Answer 18

Decision tables are often the best way to describe complex conditions. Many analysts use decision tables because they are easy to construct and understand, and programmers find it easy to work from a decision table when developing code.

Decision trees help in visualizing decision-making processes.

Question 19

What are the main themes covered in Chapter 6: Object Modeling?

Answer 19

• Object-Oriented Analysis
• Attributes
• Methods
• Encapsulation
• Relationships
• UML Diagrams

These themes focus on the principles of object-oriented design.

Question 20

Define an Object in object-oriented analysis.

Answer 20

A description of an information system by identifying objects. An object represents a real person, place, event, or transaction. O-O analysis is a popular approach that sees a system from the viewpoint of the objects as they function and interact with the system.

Objects are the fundamental building blocks in object-oriented programming.

Question 21

What are Attributes in object modeling?

Answer 21

A single characteristic or fact about an entity. An attribute, or field, is the smallest piece of data that has meaning within an information system. For example, a Social Security number or company name could be examples of an attribute. In object-oriented analysis, an attribute is part of a class diagram that describes the objects’ characteristics. Also known as a data element.

Attributes define the state of an object.

Question 22

What is Encapsulation?

Answer 22

The idea that all data and methods are self-contained, as in a black box.

Encapsulation helps in protecting the integrity of the object’s data.

Question 23

What does Inheritance refer to in object modeling?

Answer 23

A type of object relationship. Inheritance enables an object to derive one or more of its attributes from another object (e.g., an INSTRUCTOR object may inherit many traits from the EMPLOYEE object, such as hire date).

Inheritance promotes code reuse and establishes a relationship between classes.

Question 24

What are relationships?

Answer 24

Ways that objects communicate and interact as they perform the business functions and transactions a system requires. Relationships describe what objects need to know about each other, how objects respond to changes in other objects, and the effects of membership in classes, superclasses, and subclasses.

Question 25

What is a **Use Case**?

Answer 25

A representation of the steps in a specific business function or process in UML. ## Footnote Use cases help in identifying system requirements.

Question 26

Define **Cardinality** in the context of relationships.

Answer 26

A concept that describes how instances of one entity relate to instances of another entity. Cardinality is described in class diagrams by a notation of zero or many, zero or one, one and only one, and one or many. ## Footnote Cardinality defines how many instances of one entity relate to instances of another.

Question 27

What are the **main themes** covered in Chapter 7: User Interface Design?

Answer 27

* Usability * GUI * Input Design * Validation * Output Reports ## Footnote These themes focus on creating effective user interfaces.

Question 28

What is an activity diagram

Answer 28

A diagram that resembles a horizontal flowchart that shows actions and events as they occur. Activity diagrams show the order in which actions occur and identify the outcome.

Question 29

What is **Usability** in user interface design?

Answer 29

In UI design, a concept that includes user satisfaction, support for business functions, and system effectiveness. ## Footnote Usability is critical for user satisfaction and efficiency.

Question 30

Graphical user interface (GUI)

Answer 30

The use of graphical objects and techniques that allow users to communicate with a system. A well-designed GUI can help users learn a new system rapidly and work with the system effectively.

Question 31

What is a **Transparent Interface**?

Answer 31

A UI that users overlook; a user-friendly interface that does not distract the user and calls no attention to itself. ## Footnote Transparent interfaces enhance user experience by minimizing confusion.

Question 32

What does the **Usability Metrics** evaluate?

Answer 32

Data that interface designers can obtain by using software that can record and measure user interactions with the system. ## Footnote It helps in comparing usability across various designs.

Question 33

What is the role of **Natural Language** in user interfaces?

Answer 33

A software feature that allows users to type commands or requests in ordinary English (or other languages). ## Footnote Natural language interfaces can improve accessibility for users.

Question 34

What is a **Dialogue Box**?

Answer 34

A window that allows a user to enter information about a task a system will perform. ## Footnote Dialogue boxes are commonly used for user interactions.

Question 35

Define **Input Mask**.

Answer 35

A template or pattern that makes it easier for users to enter data. It is often used in automated forms to guide an unfamiliar user. ## Footnote Input masks help ensure data is entered correctly.

Question 36

What is a **Data Validation Rule**?

Answer 36

A mechanism to improve input quality by testing the data and rejecting any entry that fails to meet specified conditions. ## Footnote Validation rules help maintain data integrity.

Question 37

Range Check

Answer 37

can be used to verify that data items fall between a specified minimum and maximum value. ## Footnote These types of validation help ensure the accuracy and reliability of user inputs.

Question 38

Combination check

Answer 38

is performed on two or more fields to ensure they are consistent or reasonable. ## Footnote These types of validation help ensure the accuracy and reliability of user inputs.

Question 39

Audit trails

Answer 39

Can log every instance of data entry and changes. For example, the system should record when a customer’s credit limit was set, by whom, and any other information necessary to construct the history of a transaction. ## Footnote These types of validation help ensure the accuracy and reliability of user inputs.

Question 40

What is a **Source Copy**?

Answer 40

The original document or data from which information is derived ## Footnote Source copies are important for maintaining data integrity.

Question 41

What is an **Exception Report**?

Answer 41

A document displaying only those records that meet a specific condition or conditions. Exception reports are helpful when the user wants information only on records that might require action but does not need to know the details. ## Footnote Exception reports are crucial for identifying problems in systems.

Question 42

What is a **Summary Report**?

Answer 42

A report used by individuals at higher levels in an organization that includes less detail than reports used by lower-level employees. ## Footnote Summary reports provide a concise view of data.

Question 43

What is Output security?

Answer 43

A practice that protects privacy rights and shields an organization’s proprietary data from theft or unauthorized access.

Question 44

What is system prototyping?

Answer 44

Producing a full-featured, working model of the information system being developed.

Question 45

What are the **main themes** covered in Chapter 8: Data Design?

Answer 45

* Databases * Keys * Relationships * Normalization * Data Storage ## Footnote These themes focus on the organization and management of data.

Question 46

What is a **DBMS**?

Answer 46

A collection of tools, features, and interfaces that enable users to add, update, manage, access, and analyze data in a database. ## Footnote A DBMS is software that interacts with end users and databases.

Question 47

Economy of scale

Answer 47

The inherent efficiency of high-volume processing on larger computers is called ## Footnote In data management, it refers to efficiencies achieved through larger operations.

Question 48

Data integrity

Answer 48

A DBMS ensures data integrity (the accuracy and consistency of data over its life cycle) by enforcing data validation rules and integrity constraints.

Question 49

What is **Query Language**?

Answer 49

A language that enables the user to specify a task without specifying how the task will be accomplished. Some query languages use natural language commands that resemble ordinary English sentences. ## Footnote Query languages are essential for data retrieval and manipulation.

Question 50

What is a **Schema** in database design?

Answer 50

The structure that defines The complete definition of a database, including descriptions of all fields, records, and relationships. ## Footnote Schemas are crucial for understanding how data is stored and accessed.

Question 51

open database connectivity (ODBC)

Answer 51

is an industry-standard protocol that allows software from different vendors to interact and exchange data. ODBC uses SQL statements that the DBMS understands and can execute

Question 52

What is a **Primary Key**?

Answer 52

is a field (or combination of fields) that uniquely identifies each record in a table. Each table can have only one primary key and cannot contain null values. Primary keys ensure that each record is unique and easily identifiable. ## Footnote Primary keys ensure that each record can be uniquely identified.

Question 53

What is a **Foreign Key**?

Answer 53

A field in one table that is a field (or collection of fields) in one table that uniquely identifies a row of another table. It establishes and enforces a link between the data in two tables. The foreign key in the referencing table points to a primary key in the referenced table. ## Footnote Foreign keys establish relationships between tables.

Question 54

Define **Referential Integrity**.

Answer 54

A type of validity check. Referential integrity is a set of rules that avoid data inconsistency and quality problems. ## Footnote Referential integrity prevents orphaned records in databases.

Question 55

What is an **Entity Relationship Diagram (ERD)**?

Answer 55

is a visual tool used in database design to represent the relationships between different data entities in a system. An ERD illustrates how data is structured and interrelated. An ERD consists of entities, attributes, and relationships: ## Footnote ERDs are used to design and document database structures.

Question 56

What is cardinality

Answer 56

describes the numeric relationship between two entities and shows how instances of one entity relate to another. For example, consider the relationship between two entities: CUSTOMER and ORDER. One customer can have one order, many orders, or none, but each order must have one and only one customer.

Question 57

What does **Normalization** refer to in database design?

Answer 57

A process by which analysts identify and correct inherent problems and complexities in their record designs. ## Footnote Normalization improves data integrity and efficiency.

Question 58

What is the **Second Normal Form**?

Answer 58

A record design in 1NF and all fields not part of the primary key depend on the entire primary key. If any field in a 1NF record depends on only one of the fields in a combination primary key, then the record is not in 2NF. A 1NF record with a primary key that is a single field is automatically in 2NF. ## Footnote Achieving second normal form is crucial for database design.

Question 59

What is an **Abbreviation Code**?

Answer 59

An alphabetic abbreviation. For example, standard state postal codes include NY for New York, ME for Maine, and MN for Minnesota. ## Footnote Abbreviation codes are often used for data entry efficiency.

Question 60

What is a **Data Warehouse**?

Answer 60

An integrated collection of data that can support management analysis and decision making. ## Footnote Data warehouses support business intelligence and analytics.

Question 61

What is the difference between a **Data Warehouse** and a **Data Mart**?

Answer 61

While a data warehouse typically spans the entire enterprise, many firms prefer a data mart designed to serve a specific department’s needs, such as sales, marketing, or finance. Each data mart includes only the data that users in that department require to perform their jobs. Both approaches have pros and cons; the best solution usually depends on the situation. ## Footnote Data Marts are designed for specific business needs.

Question 62

Logical Storage

Answer 62

refers to data a user can view, understand, and access, regardless of how or where the information is organized or stored. ## Footnote This distinction is important for effective database management.

Question 63

Physical Storage

Answer 63

is strictly hardware-related because it involves the process of reading and writing binary data to physical media such as a hard drive, a USB thumb drive, or a network-based storage device.