Systems Analysis and Design 2
Terms in this set (100)
A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings
Benefits of database patterns and packaged data models
purchased models anticipate future needs
systems analysis is facilitated
purchased models are proven from extensive experience
specifies that an entity instance can simultaneously be a member of two (or more) subtypes
An association between the instances of one or more entity types that is of interest to the organization
False Re: Packaged Conceptual Data Models
Universal data models and industry-specific data models are two types of packaged conceptual data models.
An attribute that may take on more than one value for each entity instance
A set of two or more multivalued attributes that are logically related
A collection of entities that share common properties or characteristics
False Re: Entity Types
Book, supplier, and state are entity types
attributes, relationships, data entities
The three main constructs of the entity-relationship modeling notation include each of the following
True Re: Entity
An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
True Re: Repeating Data
One way to handle repeating data within an entity is to separate the repeating data into another entity, called a weak entity.
False Re: Triggers
Triggers are constraints on valid values for attributes
True Re; Data Names
The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship diagrams
True Re: Information System
An information system design based on a data orientation, rather than a process or logic orientation, should have a longer useful life.
False Re: Business Rules
Business rules are specifications that preserve the integrity of the physical data model
All of the following are benefits of database patterns and packaged data models
purchased models anticipate future needs
systems analysis is facilitated
purchased models are proven from extensive experience
referential integrity constraints
addresses the rules concerning the relationships between entity types
False Re: Processes
Processes, rather than data, are the most complex aspects of many modern information systems
True Re: Candidate Key
An order number is a good example of a candidate key
False Re: Entity Naming
Use a verb or verb phrase to name an entity
True Re: Data Limitation
In order to determine the integrity rules, minimum and maximum cardinality, and time dimensions of data, an analyst might ask, "Are values for data characteristics limited in any way?"
total specialization rule
specifies that each entity instance of the supertype must be a member of some subtype in the relationship
Why Process, logic, and data model descriptions of a system must be consistent and complete
they each describe different but complementary views of the same information system
If each employee can have more than one skill, then SKILL is referred to as a:
When selecting an identifier
choose a candidate key that will not change its value over the life of each instance of the entity type
refers to an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete
refers to grouping attributes from the logical database model into physical records.
a named set of table rows stored in a contiguous section of secondary memory.
True Re: Relation Properties
One property of a relation is that entries in a given column are from the same set of values.
False Re: Network Model
The network model is the most common style for a logical database model.
can be built into a file through encryption, passwords, or prohibiting users from directly manipulating a file
False Re: Relation Structuring
A well-structured relation contains data about two or more entities.
False Re: Object Oriented Database Models
Object-oriented database models are the most frequently used database technologies for new information systems development.
B is said to be functionally dependent on A
For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:
False Re: Transitive Attributes
Transitive attributes are attributes that determine other attributes
Each regular entity type in an E-R diagram is transformed into a
two goals of physical table design
Efficient use of secondary storage and data processing speed
False Statement Re: Logic Modelling
During logic modeling, the normalized data requirements from all user interfaces are combined into one consolidated logical database model.
adding the primary key of B as a foreign key of A or combining the two entities into one relation
For a binary one-to-one relationship between two entities A and B, the relationship is represented by
should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.
False Re: Sequential Files
Sequential files are practical for random row retrievals.
the project dictionary
During logical database design, the work of all systems development team members is coordinated and shared through
During physical design, you consider:
the definitions of each attribute
the expectations for response time and data integrity
the descriptions of where and when data are entered, retrieved, deleted, and updated
A relation is said to be in second normal form if
the primary key consists of only one attribute.
False Re: 2nd Normal Form
A relation is said to be in second normal form when there are no transitive dependencies.
False Re: Relation Correspondance
A relation corresponds to a computer file
an arrangement of related records in secondary memory so that individual and groups of records can be stored, retrieved, and updated rapidly
A single name that is used for two or more different attributes best defines:
a field that can be derived from other database fields
False Re: Database Design
Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications
False Re: Hashed File Organization
Sequential retrieval on the primary key is very fast with the hashed file organization
A binary one-to-many relationship in an E-R diagram is best represented by
adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship
logical and physical database design
performed in parallel with other systems design steps.
False Re: Data Marker
A data marker is a field of data that can be used to locate a related field or row of data.
False Re: Testing and Usability Assessment
The purpose of the testing and usability assessment section of a form design specification is to explain to those who will actually develop the final form why this form exists and how it will be used.
False Re: Highlighting Methods
Generally speaking, highlighting methods appear the same on all output devices.
general guidelines for displaying tables and lists
single type face should be used, except for emphasis.
The usability of information displayed in tables and alphanumeric lists is likely to be much more influenced by effective layout than most other types of information.
The context and meaning of tables and lists are significantly derived from the format of the information.
data on all forms and reports
must consist of data elements in data stores and on the E-R data model for the application or must be computed from these data elements
examples of highlighting methods
using all capital letters
using different fonts
type of document that is used to convey information on a collection of items
False Re: Reliability
Reliability is an overall evaluation of how a system performs in supporting a particular user for a particular task.
False Re: Highlighting
Form designers should use highlighting as often as possible to distinguish the different categories of data.
the task characteristic addresses
activities that differ in the amount of information that must be obtained from or provided to the user
should be consistently selected and used based upon the level of importance of the emphasized information.
A passive document that contains only predefined data
False Re: Ease Usability Factor
Referencing the general design guidelines for form and report usability, the ease usability factor means that information should be viewed and retrieved in a manner most convenient to the user.
To assess usability, information can be collected by:
selecting between tables and graphs
you should use graphs to forecast activities.
False Re: Textual Output
In business-related systems, textual output is becoming less important as the text-based applications that use these systems are slowly disappearing.
should appear in roughly the same format and placement each time.
When designing interfaces for Internet-based electronic commerce applications
the lack of maturity of Web scripting and programming languages and the limitations in commonly used Web GUI component libraries create problems for interface designers
The First Step to Becoming and Effective GUI Designer
becoming an expert user of the GUI environment
understanding the available resources and how they can be used
The technique where users must confirm their intention twice before being allowed to proceed is called
False Re: Linear Menu
A linear menu is a menu positioning method that places the access point of the menu near the top line of the display.
command language interaction
A human-computer interaction method where explicit statements are entered into a system to invoke operations refers to:
False Re: Web tabbing
Web tabbing is a technique for showing users where they are in a Website by placing a series of "tabs" on a Web page that shows the users where they are and where they have been.
The most fundamental and widely used hardware device used to support system interaction is the:
The input device that is most accurate for text selection is the:
False Re: Conversation
A conversation is a method by which users interact with information systems
Placing a menu in the same location on every Web page
helps customers to more quickly become familiar with a Website and more rapidly navigate through the site.
The most commonly used method for data entry and retrieval in business-based systems
Functional capabilities for providing smooth and easy navigation within a form
cursor-control, editing, exit, and help capabilities.
False Re: Data Entry Structure
When structuring data entry, users should be required to enter the current date and time.
The variation of menu design is most often related to
the size and complexity of the system
the skills of the developer
the capabilities of the development environment
The ability to provide field-level help is often referred to as
One guideline for menu design
making sure that command verbs clearly and specifically describe operations
natural language interaction
is the least viable interaction style
sequence of interaction between a user and a system
The three major steps for designing dialogues include
designing the dialogue sequence
building a prototype
interface layout guidelines state that
data fields should be grouped into logical categories with labels describing the contents of the category
Please wait while I open the file" is an example of this
An effectively designed form
provides default values when practical
displays data in appropriate field lengths
minimizes the need to scroll windows
does all of the above
How can you avoid a hidden links error?
Make sure you leave a border around images that are links, do not change link colors from normal defaults, and avoid embedding links within long blocks of text.
False Re: Expected Values Validation Test
An expected values validation test checks to see if there is a quantity field on each line item of a customer order.
A pop-up menu
a menu positioning method that places a menu near the current cursor position
When structuring data entry fields
the system should automatically justify data entries
menu positioning method places the access point of the menu near the top line of the display; when accessed, menus open by dropping down onto the display
A method by which users interact with information systems
an assertion or rule that
governs the validity of data manipulation
operations such as insert, update and
YOU MIGHT ALSO LIKE...
Academic Word Lists - AWL Sublists
MIS 4340 MidTerm
OTHER SETS BY THIS CREATOR
FA Emergency equipment
FA Exam 2 review
THIS SET IS OFTEN IN FOLDERS WITH...
Systems Analysis and Design Exam 1
Systems Analysis Final