Systems Analysis and Design chapter 4

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

Questions and Answers

What is a key field that identifies a unique record in a database?

  • Candidate key
  • Primary key (correct)
  • Foreign key
  • Secondary key

What does normalization aim to achieve in data design?

  • Avoid problems in data design (correct)
  • Simplify database access
  • Increase data redundancy
  • Facilitate unstructured data

In an entity-relationship diagram (ERD), what term describes the relationship between two entities?

  • Cardinality (correct)
  • Entity type
  • Relationship type
  • Key field

What does the process of logical storage refer to?

<p>Information as perceived by the user (D)</p> Signup and view all the answers

Which of the following is NOT a component of file and database control measures?

<p>User interface design (B)</p> Signup and view all the answers

What is a recommended feature for data entry screens that enhances user experience?

<p>Providing users an opportunity to confirm the accuracy of input data before final submission (A)</p> Signup and view all the answers

Which of the following is NOT a recommended practice for data entry screen design?

<p>Using a random layout that varies from the source document (A)</p> Signup and view all the answers

How should numeric fields be designed in a data entry screen?

<p>They should allow users to skip inputting both leading and trailing zeros (A)</p> Signup and view all the answers

Which feature is crucial for facilitating navigation between fields on a data entry form?

<p>Providing a standard order for field navigation (B)</p> Signup and view all the answers

What is an effective method for ensuring date fields are entered correctly?

<p>Using an input mask and displaying a sample format like MMDDYY (D)</p> Signup and view all the answers

What type of code combines different item attributes or characteristics?

<p>Derivation codes (D)</p> Signup and view all the answers

Which of the following types of codes is primarily used to represent specific actions associated with an item?

<p>Action codes (D)</p> Signup and view all the answers

Which guideline should be followed to avoid confusion in coding?

<p>Keep codes concise (B)</p> Signup and view all the answers

What characteristic is important for a code meant to be expanded in the future?

<p>Make codes stable (B)</p> Signup and view all the answers

Which of these types of codes uses letters to easily remember combinations?

<p>Mnemonic codes (B)</p> Signup and view all the answers

Which coding strategy emphasizes minimizing length without sacrificing meaning?

<p>Keep codes concise (A)</p> Signup and view all the answers

What is the primary purpose of abbreviation codes?

<p>To distinguish one item from another using letters (D)</p> Signup and view all the answers

Which guideline should be considered to ensure effective coding for single-use purposes?

<p>Use a single purpose for a code (D)</p> Signup and view all the answers

What is the purpose of normalization in database design?

<p>To organize fields or attributes into specific tables (D)</p> Signup and view all the answers

Which statement accurately describes the cardinality between CUSTOMER and ORDER entities?

<p>One CUSTOMER can place zero to many ORDERS (C)</p> Signup and view all the answers

What is the first stage in the normalization process?

<p>Unnormalized design (C)</p> Signup and view all the answers

In the relationship between EMPLOYEE and PROJECT, how many projects can an EMPLOYEE be assigned to?

<p>One or many projects, or none (C)</p> Signup and view all the answers

Which of these is NOT a stage in the normalization process?

<p>Design conceptualization (C)</p> Signup and view all the answers

What does crow's foot notation primarily represent in an ERD?

<p>The cardinality and relationships between entities (A)</p> Signup and view all the answers

When an ORDER is considered to include multiple ITEM ORDERED entities, which statement best reflects the relationship?

<p>An ORDER can comprise one ITEM ORDERED or many (C)</p> Signup and view all the answers

Which of the following best defines a primary key in a database table?

<p>A unique identifier for each record in the table (D)</p> Signup and view all the answers

What characteristic indicates that the STUDENT table is unnormalized?

<p>It contains a repeating group. (B)</p> Signup and view all the answers

Which normalization form is achieved when the STUDENT table includes STUDENT NUMBER and COURSE NUMBER as primary keys?

<p>1NF (C)</p> Signup and view all the answers

In which normalization form are all fields functionally dependent on the entire primary key?

<p>2NF (A)</p> Signup and view all the answers

What is the primary outcome of normalizing the STUDENT table from 2NF to 3NF?

<p>The creation of the ADVISOR table. (C)</p> Signup and view all the answers

What role does the GRADE entity play in relation to the STUDENT and COURSE tables?

<p>It links the STUDENT and COURSE tables. (A)</p> Signup and view all the answers

Which table structure is evident in 3NF when the STUDENT table is normalized?

<p>STUDENT and ADVISOR tables. (B)</p> Signup and view all the answers

Which of the following is NOT a characteristic of a relational database design as described?

<p>Presence of redundant data. (C)</p> Signup and view all the answers

What is a key identifying feature of the entity-relationship diagram created after normalization?

<p>All entities have unique names. (C)</p> Signup and view all the answers

What is a benefit of displaying titles, messages, and instructions consistently?

<p>It helps users locate information faster. (C)</p> Signup and view all the answers

Why should keystroke alternatives be provided for each menu command?

<p>To assist users who prefer using the keyboard over a mouse. (C)</p> Signup and view all the answers

What color convention should users be familiar with when designing an interface?

<p>Red = stop, Yellow = caution, Green = go. (C)</p> Signup and view all the answers

What is the purpose of using a toggle button?

<p>To show on or off status of an option. (C)</p> Signup and view all the answers

Which feature is most appropriate for selecting one or more choices from a group?

<p>Check boxes for multiple selections. (C)</p> Signup and view all the answers

What is the role of a dialog box when variable input data is required?

<p>To provide a clear explanation of the required input. (B)</p> Signup and view all the answers

How does an opening screen contribute to user interaction?

<p>It introduces the application and provides navigation. (D)</p> Signup and view all the answers

What is one of the advantages of using a calendar control for date entries?

<p>It reduces the risk of incorrect date entry. (C)</p> Signup and view all the answers

Flashcards

Form Filling Data Entry

A method of data entry where users fill out fields on a screen, similar to a paper form.

Restricting User Access to Data Entry Locations

A feature that helps prevent data entry errors by restricting users from entering data in unexpected locations on a screen.

Allowing Exit without Saving

Ensures the user can exit the data entry screen at any time without saving the current record, preventing accidental data loss.

Descriptive Field Captions

Clearly labeling fields on the form, providing context for user input.

Signup and view all the flashcards

Flexible Field Navigation

Allowing users to navigate between fields efficiently, using either a predefined order or their own preference.

Signup and view all the flashcards

Database

A collection of linked tables that organize and store data.

Signup and view all the flashcards

DBMS (Database Management System)

A software that enables users to manage and interact with databases. It provides tools to add, modify, access, and analyze data.

Signup and view all the flashcards

Entity

A person, place, thing, or event about which data is collected and maintained in an information system.

Signup and view all the flashcards

ERD (Entity-Relationship Diagram)

A graphical representation that shows all the entities in a system and their relationships to each other.

Signup and view all the flashcards

Normalization

The process of avoiding problems in data design by organizing data into tables and relationships to ensure data integrity and efficiency.

Signup and view all the flashcards

Consistent Layout

Displaying titles, messages, and instructions in a consistent way throughout the application.

Signup and view all the flashcards

Consistent Actions

Ensuring commands and mouse interactions produce the same effect every time.

Signup and view all the flashcards

Input Confirmation

Asking the user to confirm their input by pressing Enter or Tab.

Signup and view all the flashcards

Color Conventions

Using color conventions like red for stop, yellow for caution, and green for go.

Signup and view all the flashcards

Menu Command Shortcuts

Providing a keyboard shortcut for each menu command for quicker access.

Signup and view all the flashcards

Avoiding Jargon

Using clear and simple language, avoiding technical terms.

Signup and view all the flashcards

Opening Screen

A screen that welcomes the user and introduces the application, often with command buttons for navigation.

Signup and view all the flashcards

Command Button

A button that triggers a specific action when clicked.

Signup and view all the flashcards

Unnormalized Table

A table is considered unnormalized if it contains repeating groups of data, meaning the same data is repeated for different records. This violates the first normal form (1NF) rule.

Signup and view all the flashcards

First Normal Form (1NF)

The first normal form (1NF) eliminates repeating groups by creating a primary key that uniquely identifies each row.

Signup and view all the flashcards

Second Normal Form (2NF)

Second normal form (2NF) builds on 1NF by requiring all non-key attributes to be fully dependent on the entire primary key. This eliminates redundancy.

Signup and view all the flashcards

Third Normal Form (3NF)

Third normal form (3NF) further reduces redundancy by ensuring all non-key attributes are directly dependent on the primary key and not on other non-key attributes.

Signup and view all the flashcards

Entity-Relationship Diagram (ERD)

An entity-relationship diagram (ERD) visually represents the relationships between entities, such as tables in a database. It helps visualize the data structure and relationships.

Signup and view all the flashcards

Associative Entity

An associative entity in an ERD links two other entities, forming a many-to-many relationship between them. It serves as a bridge table.

Signup and view all the flashcards

Relational Database Design

A relational database design involves creating a set of tables linked by common fields, forming an overall data structure. This structure facilitates data management and retrieval.

Signup and view all the flashcards

Table design

A specific structure for a table in a database that specifies the fields (columns) and their data types.

Signup and view all the flashcards

Unnormalized design

The initial stage of database design where data is organized but may have redundancies and data integrity issues.

Signup and view all the flashcards

Normalized design

A database design that adheres to the rules of a specific normal form, such as 1NF, 2NF, or 3NF, improving data integrity and reducing redundancy.

Signup and view all the flashcards

Primary key

A specific field (column) in a table that uniquely identifies each record. Often used as a key to link tables together.

Signup and view all the flashcards

Alphabetic Codes

Using letters to differentiate items. Examples include category codes to identify groups, abbreviation codes using short forms, and mnemonic codes using memorable letter combinations.

Signup and view all the flashcards

Category Codes

Codes that categorize related items, helping to organize and group data.

Signup and view all the flashcards

Abbreviation Codes

Shortened versions of words or phrases used as codes. Example: using 'USA' for 'United States of America'.

Signup and view all the flashcards

Mnemonic Codes

Codes that use specific letter combinations for easy remembering. Example: ROYGBIV for the colors of the rainbow.

Signup and view all the flashcards

Derivation Codes

Codes created by combining data from multiple characteristics of an item. This combines information to create a unique code.

Signup and view all the flashcards

Cipher Codes

Using a secret keyword to encode a number. This adds another layer of security to the code.

Signup and view all the flashcards

Action Codes

Codes showing what action should be taken with an item. This helps in guiding the process or operation.

Signup and view all the flashcards

Designing Codes

A set of guidelines for effective code design. These principles ensure codes are clear, efficient, and easy to manage.

Signup and view all the flashcards

Study Notes

Systems Analysis and Design 11th Edition

  • User Interface Design chapter objectives include explaining user interface design and human-computer interaction, as well as user-centered design principles.
  • Interface designers perform tasks to describe rules for successful interface design and discuss input and output technology issues.
  • Design effective source documents and forms, explain printed output guidelines, describe output and input controls and security, and explain modular design and prototyping techniques.
  • Systems design aims to create effective, reliable, and maintainable systems.
  • Effective systems support business needs and user needs.
  • Reliable systems handle different types of errors, including input errors, processing errors, hardware failures, and human mistakes.
  • Maintainable systems are flexible, scalable, and easy to modify.
  • To design a successful system, think like a user, anticipate future needs and provide flexibility, offer several alternatives, manage data effectively, have input data close to the source, and include audit trails.
  • Users have more control over their output, centralized IT departments don't produce large amounts of printed reports, and the user interface continues to evolve to meet the needs of mobile and wearable devices.
  • A user interface describes how users interact with a computer system.

What Is a User Interface?

  • Describes how users interact with a computer system.
  • Comprises features affecting two-way communications between the user and the computer.
  • Central to usability, distinguishing between input, output, and the interface.

Human-Computer Interaction (HCI)

  • Describes the relationship between computers and people who use them.
  • Early interfaces included complex commands and graphical user interfaces (GUIs).
  • Transparent user interfaces do not distract the user.
  • The objective is a user-friendly design that's easy to learn.

Seven Habits of Successful Interface Designers

  • Understand the Business: Includes the underlying business functions, how the system supports individual, departmental and enterprise goals.
  • Maximize Graphical Effectiveness: A well-designed interface allows for rapid learning.
  • Think Like a User: The designer should see the system from the user's perspective.

Use Models and Prototypes

  • Designers can present initial screen designs to users via storyboards.
  • Users can test the design and provide feedback.
  • Focus on usability by including main options on the opening screen and offering a reasonable number of choices that users easily understand.

Invite Feedback

  • Monitor system usage and solicit user suggestions.
  • Determine if system features meet intended use by observing and surveying users.
  • Document all screen designs for programmers to refer to in the future.
  • User-approved sketches and storyboards can be used to document the user interface.

Guidelines for User Interface Design

  • Focus on system design objectives to create a design that's easy to understand and remember.
  • Design consistent commands, actions, and system responses.
  • Allow users to correct mistakes easily.
  • Label controls, buttons, and icons clearly.
  • Select images, on-screen instructions, and menu item listings that users can understand and are logical.
  • Make it easy to navigate or return to different levels in the menu structure.

Enhance User Productivity

  • Organize tasks, commands, and functions to mirror actual business operations.
  • Create alphabetical menu lists and place frequently used selections at the top.
  • Provide shortcuts for experienced users.
  • Use default values if the majority of values in a field are the same; provide a duplicate value function, but allow users to disable it if needed.
  • Provide a fast-find feature and consider using natural language processing for commands or requests.
  • Include appropriate help and feedback.

Guidelines for User Interface Design

  • Ensure that help is always available on demand.
  • Provide user-selected help and context-sensitive help.
  • Create a direct route for users to return to where they were previously in the application.
  • Provide contact information.
  • Require user confirmation before data deletion, and provide an Undo key when errors are made.
  • Highlight erroneous parts of commands.
  • Use hypertext links to assist users.
  • Display messages logically on the screen.
  • Alert users to lengthy processing times or delays.
  • Allow messages to stay on the screen long enough for users to read them.
  • Let the user know whether the task or operation was completed successfully.

Guidelines for User Interface Design

  • Customer order tracking systems, including tasks, commands, and functions, should be organized into logical groups and sequences, similar to a functional decomposition diagram (FDD).
  • Provide a clear flow, with information logically arranged from left to right and top to bottom. Ensure the order of printed fields is logical and that totals are clearly identified.

Printed Output

  • In designing printed output, consider who needs the information and why, the specific information needed, whether the output is for a specific device and whether security and confidentiality issues exist.
  • The overview of report design involves reducing printed reports and using screen output, emphasizing easy-to-read, well-organized reports, and using database programs with report design tools.
  • Types of reports include detail reports (for each record), exception reports (only records meeting conditions), and summary reports (providing comprehensive data).
  • All report designs should be approved by users; creating mock-ups or prototypes can ensure the appropriate user input.

Report Design Principles

  • Reports should have header and footer elements containing title, date, and other relevant information.
  • Page headers and footers should identify the data.
  • Page footers should display the report title, page number, and data elements.
  • Repeating fields help provide clarity.
  • A report's consistent design and layout enhance the user experience.

Output Technology

  • Output can be delivered via screens, printed matter, actual forms, or digitally on devices.
  • Options for delivery include internet-based information, documents downloadable from websites, or live or prerecorded webcasts.
  • Technologies, including email, web-based logs (blogs), instant messaging, wireless devices and digital audio/images/video can improve the user experience.

Output Technology

  • Digital audio, video, and image formats can be stored in digital format, and can be incorporated as clips or attachments in documents.
  • Podcasts can serve as a form of communication.
  • Automated fax and faxback systems allow customers to send and receive faxes by various methods.
  • Computer output to microfilm (COM) allows for archiving of documents, and computer output to digital media is helpful for users needing quick retrieval and scanning of paper documents.
  • Specialized formats such as portable, internet-connected devices run multiple applications, retail point-of-sale terminals, and automatic teller machines can handle bank transactions.

Input Technology

  • Input technology includes traditional methods (keyboard, mouse, pointing devices, microphones, OCR, and MICR).
  • Evolving methods include body motion detection, advanced voice recognition, biological feedback, and RFID.
  • Emerging methods include brain-computer interfaces (BCIs), neural networks, advanced motion sensors, two-way satellite interfaces, virtual environments, and 3-D technology.

Input Technology

  • Batch input occurs on a schedule, and online data entry is done immediately, enabling verification and device-assisted automated input. Technologies like RFID tags, magnetic data strips, and smartphones facilitate fast and accurate data input.
  • Source data automation examples include point-of-sale (POS) terminals with scanners, ATMs that read bank cards, factory employee ID cards, hospitals' barcodes on patient bracelets, and portable scanners and handheld scanners for retail and libraries.
  • Manual data entry is slower and more expensive but occurs in real-time, often during high-demand periods, thus the choice depends on the business requirements.

Security and Control Issues

  • Output control measures maintain output security and integrity.
  • Security measures protect proprietary data from unauthorized access.
  • Diskless workstations support a user interface but limit printing or copying, while port protectors control access.
  • Input control measures ensure data correctness, completeness, and security, with source documents traced to input data.
  • Procedures handle data integrity, ensuring data is not lost before entering the system.
  • Data security policies and procedures protect against data loss or damage.

Modular Design

  • Individual components, called modules, connect to a higher-level program or process.
  • Modules perform specific functions and are used to build structured designs.
  • These modules are reflected in data flow diagrams (DFDs) and are described in process descriptions.

Prototyping and Its Benefits

  • Prototyping involves a repetitive sequence of analysis, design, modeling, and testing.
  • System prototyping produces functional models for users to review and provide feedback.
  • Design or throwaway prototyping is used to verify requirements and is discarded after the user feedback process.
  • Prototyping avoids misunderstandings between users and systems developers.
  • System developers can create accurate specifications using the prototype.
  • Managers can better assess models compared to document-only methods.
  • Prototyping supports user testing, training, and reduces financial risks associated with completed system failures.

Prototyping - Potential Problems

  • Rapid pace of development can create problems not discovered until the operational phase.
  • System requirements regarding reliability and maintainability cannot be adequately tested in prototypes.
  • Complex systems can pose challenges regarding prototype management and handling.
  • Client adoption of prototypes could potentially lead to increased future maintenance costs due to limited or no changes made.

Chapter Summary

  • Database design aims to create a physical model that meets analysis phase specifications.
  • User interfaces should reflect user perspectives.
  • Reports should be detail, exception, or summary reports with logical zones, data capture and entry methods, and crucial security measures.

Data Design Concepts

  • Data structures provide frameworks for organizing, storing, and managing data using files or tables.
  • Each data file focuses on people, places, things, or events.
  • File-oriented systems, like Mario's auto shop system, store data in separate files.
  • Relational models, like Danica's, connect data through common fields within tables.
  • File processing remains relevant in handling large volumes of structured data and remains cost-effective in specific situations.
  • Database management systems (DBMS) are efficient, adaptable, and robust systems for data management, enabling flexible expansion and modification as needed.
  • Database administrators (DBAs) are responsible for maintaining and securing databases given access levels appropriate for different users.
  • Web-based data designs are global, and highly adaptable to different platforms, but require a different approach to security compared to traditional models.

Data Design Terms

  • Entity: Refers to a person, place, thing, or event, for which data is stored and maintained.
  • Table/file: Collection of related records for a specific entity.
  • Field (attribute): Single data characteristic of an entity.
  • Common field: Appears in multiple entities.
  • Tuple /record: Describes an instance of an entity.
  • Primary key: Uniquely identifies each entity.
  • Candidate key: A field that can serve as the primary key if needed.
  • Foreign key: Connects related records in different tables.
  • Secondary key: Used to narrow down records for specific searches.
  • Referential integrity: Ensures the consistency and quality of data relationships.
  • Entity-relationship diagrams (ERDs): Graphic representations of database structure and relationships.
  • Cardinality: Numeric relationship between entities.

Data Normalization

  • Normalization is a data design process that improves data structure by assigning specific fields to tables.
  • Normalization progresses through stages: unnormalized, first normal form (1NF), second normal form (2NF), and third normal form (3NF).
  • In 1NF, tables eliminate repeating groups.
  • Standard notation shows table structure, including underlined primary keys; repeating group recognition is important.
  • 2NF means that all non-key fields depend on the entire primary key, and 3NF adds a condition stating that non-key fields must not depend on other non-key fields.

Using Codes

  • Codes are short representations of data, reducing storage space and costs.
  • Codes reduce data entry and transmission time, potentially reducing data input errors and enhancing memorability.
  • Categories of codes include sequence, block sequence, significant digit and mnemonic codes, as well as derivation, cipher, and action codes.
  • Various codes are useful to identify different elements depending on specific needs.

Data Storage and Access

  • Data warehousing involves a centralized storage of data from various sources allowing users to view, understand, and access data that may not always be organized or stored in a manner that is visible or understood.
  • Data warehousing is designed to meet specific departmental needs.
  • Data mining analyzes data to discover meaningful patterns and relationships between data elements that include increasing page views, referrals, reduced customer checkouts per visit and an increase in overall profit per checkout.
  • Logical data storage is how users perceive and interact with data irrespective of where it is physically stored.
  • Physical data storage refers to how data is stored on physical media.
  • Data coding formats, such as EBCDIC and ASCII and Unicode, are standardized ways to represent data in computer storage.
  • Dates can be stored using an International Organization for Standardization (ISO) format, with year, month, and day represented by numerical values.
  • Data control ensures data security and integrity using backup copies, recovery procedures, and audit trails.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

More Like This

Database Table Normalization by Dr. Hosam Selim
15 questions
Database Design and Normalization
18 questions
Database Design Concepts Quiz
10 questions
Use Quizgecko on...
Browser
Browser