INFO 361 Quiz 2

Outsourcing firms called [ ] supply software applications and/or software related services through the Internet a. Application Service Providers (ASPs) b. Enterprise Resource Providers (ERPs) c. System Development Life Cycle Companies (SDLCs) d. Information Technology Developers (ITDs) e. None of these

Application Service Providers (ASPs)

[ ] repository entries are updated to reflect specific technology decisions as they are made a. DFD b. Sequential c. CASE d. Hardware e. None of these

CASE

Which would likely be an entity on a car insurance a) date b) Gender c) company d) fire district e) Car

Car

In creating ERD's, which would most likely NOT be a source for entities? a) Use cases b) Level 0 DFD diagrams c) External entities d) Data flows e) Cost / benefit reports

Cost / benefit reports

The two methods to validate that an ERD is well formed are a) Balancing with process models and following design guidelines created by Chen b) Normalization and balancing with process models c) Renaming theory d) Balancing with process models and renaming theory e) Normalization and following design guidelines created by Chen

Normalization and balancing with process models

Andrew, an analyst for PaxMedia Inc., has just learned that the business rules for a system he has been working on have changed. This means that a) Nothing - once the ERD data models have been drawn, they are 'frozen' for the system b) Andrew will be reassigned to a different project that is in its beginning stages c) The ERD components will have to be changed d) The ERD data model will have to be put on hold while new DFD diagrams are created e) The project will have to be scrapped and restarted

The ERD components will have to be changed

Which is probably true about packaged software a. In most cases, the software is a perfect fit for the companies need b. Packaged software works best where the company has a unique need c. The time frame is flexible to long d. The business need is common e. The project has a highly skills project manager who has been with the company for many years and has an excellent relationship with both business users and the IT development staff

The business need is common

Outsourcing is used when a. The project has a project manager who can coordinate vendor efforts b. There is a desire to build in-house skills c. In-house functional and technical skills exist d. The business need is not core to the business e. None of these

The business need is not core to the business

Custom development is used when a. The business need is unique b. The business need is not core to the business c. The project has a project manager who can coordinate vendor efforts d. The time frame is short e. The skills are not strategic

The business need is unique

One problem with using packages software systems is a. It takes a very long time to get the system and get it installed b. The company has to accept the functionality that is provided with the system c. Many common software packages have been written and tested and are readily available d. There are many good software packages that are reasonable in price e. Most software packages allow for some customization

The company has to accept the functionality that is provided with the system

Which would NOT likely be an entity on a car insurance ERD a) Customer b) Policy c) Agent d) Zip code e) Car

Zip code

Jack is developing an ERD for a small dental practice office patient record system. The dental practice has three dentists, six hygienists, and many patients. A patient is always assigned to the same dentist for all appointments. In particular, he is working on the relationship between dentists and patients. Should it be: a) 1 to 1, with a modality of null b) 1 to many with a modality of not null c) Many to many with a modality of null d) Many to many with a modality of not null e) 1 to many with a modality of null

1 to many with a modality of not null

A data model can: a) Illustrate return-on-investment, break-even point, and economic feasibility b) Represent actions or processes that occur in the to-be system c) Be used as a logical data model in analysis and as a physical data model in design d) Only be used in BPR situations e) Only be used with JAD sessions

Be used as a logical data model in analysis and as a physical data model in design

What makes systems integration so difficult a. Finding the original data to install on the new server b. Creating a ghost drive to house the old information c. Installing new software packages on older machines d. Bringing legacy system data and new data together e. None of these

Bringing legacy system data and new data together

Balance occurs between DFDs and ERDs when the data stores a) Are uniquely named b) Have only one input and one output flow c) Are named the same as the relationships on the ERD d) Can be compared to ERD data flows and attributes on the ERD are included in data stores on the DFD e) Can be equated to entities on the ERD and when entities are referred to by data stores on the DFD

Can be equated to entities on the ERD and when entities are referred to by data stores on the DFD

Which would NOT likely be an attribute of an entity called "Student" a) Age b) Student identification number c) Class room number d) Home phone e) Gender

Classroom number

Systems Integration refers to a. The process of synching all computers to the mainframe b. The delivery of systems to the final destination office c. Combining packaged software, the existing legacy system, and new software d. Adding the original hard drives to a newer system e. Creating a new software to monitor power consumption

Combining packaged software, the existing legacy system, and new software

Which of the following is normally NOT done in the design phase of the SDLC a. Decisions for hardware and software purchases are made b. User interactions are planned out (inputs, outputs, user interfaces) c. Cost / Benefits of the new system are carefully calculated d. Logical DFDs and ERDs are converted into physical DFDs and ERDs e. The physical data model is created

Cost / benefits of the new system are carefully calculated

An ERD is a picture which shows the information that is by a business system a) created b) stored c) used d) all of these

Created Stored Used

The last step in creating basic ERD's is to: a) Identify relationships b) Define attributes and assign identifiers c) Recognize entities d) Test them with users e) Compile them with Java

Identify relationships

The first step to building an Entity Relationship Diagram is to a) Identify data flows from the level 0 DFD diagram b) draw the relationships between the entities c) identify the attributes for each entity d) identify the entities e) identify the processes, data flows and data stores

Identify the entities

Entity Relationship Diagrams show relationships between entities that are a) Outputs from JAD sessions b) Consistent with the ACM guidelines c) In line with the business rules and processing d) Defined by the project sponsor e) Extensions of the process models

In line with the business rules and processing

Another name for custom development might be a. Offshore outsourcing b. In-house development c. Vendor supplied in-house consulting d. CASE tools e. Package software

In-house development

A(n) entity is an entity with an identifier that describes only the entity a) dependent b) incomplete c) independent d) intersection e) non-identifying

Independent

An entity: a) Is the association between two related processes b) Has cardinality (1:1, 1:N, or M:N) c) Shows if it can be null or no null d) Is a person, place or thing e) Is described with a verb phrase

Is a person, place, or thing

An entity relationship diagram (ERD) a) Is a use-case diagram enhanced graphically to show data and process modeling b) Is a high-level CASE diagram of data modeling used in business systems c) Is an illustration of external data flows to and from a business systems d) Is a picture that shows the information that is created, stored, and used by a business system e) Is a graphical display of the processes in a business system

Is a picture that shows the information that is created, stored, and used by a business system

Which is NOT true about using Visible Analyst Workbench? a) It can be used with many different databases b) It integrates the data model with other parts of the project c) It is a full-service CASE tool d) Data modeling is one of many capabilities e) It can generate Java code when the data modeling is done

It can generate Java code when the data modeling is done

What is true about creating an entity relationship diagram? a) There will be at most seven entities b) There will be at most seven relationships c) If you identify more than seven entities, analyze and combine until you have seven or less d) It is an iterative process e) Entities will have at most seven attributes

It is an iterative process

What type of process is creating an ERD a) Well defined process b) Sequential process c) Process defined by five steps d) Iterative process e) User defined process

Iterative process

Information in the data dictionary is called: a) Metadata b) Cached information c) Compiled data d) Data repository e) File silo

Metadata

Workarounds are a. Not supported by a vendor who supplied the packaged software b. Designed by the vendor c. Created to interface two software packages that are compatible with each other d. Enterprise Wide Software Packages that are designed for satellite use e. None of these

Not supported by a vendor who supplied the packaged software

When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from: a) O normal form to 1st normal form (1NF) b) 1st normal form (1NF) to 2nd normal form (2NF) c) 2nd normal form (2NF) to 3rd normal form (3NF) d) Generalized normal form (GNF) to fully normalized form (FNF) e) Dependent normal form (DNF) to Independent normal form (INF)

O normal form to 1st normal form (INF)

Application service providers might be best associated with a. In-house development b. Packaged software c. Unique and strategic systems d. Outsourcing e. Internet Service Providers

Outsourcing

You have entities of ITEM, SOLD-ITEM, SALE and PAYMENT. Which most likely is NOT a relationship? a) SALE is paid by PAYMENT b) PAYMENT pays for ITEM c) ITEM is included in SOLD-ITEM d) SALE involves SOLD-ITEM e) PAYMENT pays for SALE

PAYMENT pays for ITEM

For efficiency purposes, it is wise to [ ] when there is a basic software need to be satisfied a. Implement a company-wide project team to handle a custom software scripting b. Purchase a packaged system c. Design a blueprint and contract an outside vendor to develop a program d. Make do with the current software package e. Utilize a professional consultant to develop a system of servers7

Purchase a packaged system

If (a) the business need is common; (b) the skills needed are not strategic; (c) the time frame is short; it might be best to a. Use in-house / custom development b. Hire a vendor to write the code for you c. Outsource to India d. Purchase a software package e. Hire a consultant

Purchase a software package

If on a limited time budget, the best way to be sure you remain efficient and effective in designing a system is to utilize the a. Porters 5 Forces Model b. Outsourcing Model c. RAD and Timeboxing Techniques d. Hire/Fire Motivational Theory e. Not Attempt the Project

RAD and Timeboxing Techniques

The three major parts of an ERD diagram are a) Process, data flow, data store b) Attribute, modularity, cardinality c) Relationship, data flow, entity d) Relationship, attribute, entity e) Process, entity and relationship

Relationship, attribute, and entity

The lines that connect the entities are referred to as a) Data flows b) connectors c) relationships d) crow's feet e) foreign key

Relationships

Lines on an ERD diagram indicate a) Hierarchies between processes b) Relationships among the data c) Plurality of data items d) Uniqueness of data items e) Primary keys

Relationships among the data

The following document is utilized with possible vendors on projects with smaller budgets, instead of sending a lengthy document to all possible vendors a. Request for Proposal (RFP) b. Request for Information (RFI) c. Request for Quote (RFQ) d. Request for Efficient Information Distribution (REID) e. More Optimal Desires (MOD)

Request for Information (RFI)

The system inputs and outputs will be designed along with a plan or [ ] of the way the system's features will be navigated a. Blueprint b. Compass c. Instructional Guide d. Roadmap e. FAQ

Roadmap

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key, which step of normalization is being performed? a) base normal form b) first normal form c) second normal form d) third normal form e) cannot tell from this information

Second normal form

Request for Proposals (RFPs) serve what purpose a. Integrate systems with one another b. Create synergy amongst staff members c. Solicit information from providers d. Engage mobile computers with mainframe technology e. Develop morale amongst managers

Solicit information from providers

Which of the following lists indicates the correct ordering of deliverables in a system specification document a. System Acquisition Weighted Alternative Matrix, Interface Design, Physical Data Model Data Storage Design b. Data Storage Design, Interface Design, Architecture Design, Updated Crud Matrix c. Hardware and Software Specifications, Interface Design, Data Storage Design, Architecture Design d. Program Design Specifications, Physical Data Model, Data Storage Design, Architecture Design e. Update CASE Repository Entries, Update CRUD Matrix, Interface Design, Architecture Design

System Acquisition Weighted Alternative Matrix, Interface Design, Physical Data Model, Data Storage Design

In the initial stage of design, what are business requirements converted into a. System Requirements b. Work Order Summary c. Computer Qualifications Checklist d. Vanilla System e. Hardware Blueprint

System Requirements

In what SDLC stage do we determine the business needs for an information systems project a. The design phase b. The analysis phase c. The dissection stage d. The installation stage e. The big bang stage

The analysis phase

Which of the following is NOT true about ERDs a) Special symbols are added to show high-level business rules b) The diagrams are drawn in a sequential order - from top to bottom c) Similar kinds of information are listed together in entities d) ERD's are data modeling techniques e) Lines are drawn to show relationships among the data

The diagrams are drawn in a sequential order - from top to bottom

Packaged systems are used when a. The business need is not core to the business b. There is a desire to build in-house skills c. The time frame is flexible d. The project has a project manager who can coordinate vendor efforts e. The decision to outsource is strategic

The project has a project manager who can coordinate vendor efforts

In adding attributes to an ERD, which of the following might NOT be a good resource for attribute? a) From the CASE tool b) Data flows from DFDs c) Requirements documents d) The system proposal document e) Through interviews (what users need for reports and processing)

The system proposal document

A time and arrangements deal is considered a. Very flexible b. Very rigid c. Cheaper than any other option d. Useless when considering a systems design e. Always the best option for any project

Very flexible

Fixed-price contracts are considered a. Very flexible b. Very rigid c. Always cheaper than any other option d. Useless when considering a systems design e. Always the best option for any project

Very rigid

Independent entities are: a) When a child requires attributes from the parent b) When there is only one entity for a data process model c) When an entity can exist without the help of another entity d) Where the entity identifier is also the primary key e) When an entity comes from an external source (aka 'external entity')

When an entity can exist without the help of another entity

Modality refers to: a) Relationships of one-to-one; one-to-many; or many-to-many b) Whether and entity can exist with or without a related instance in the related entity c) The hierarchical structure that was developed in process models applied to data models d) The number of attributes generated by an entity e) Whether the entity has a unique identifier (aka 'primary key') or a concatenated identifier (aka 'composite key')

Whether an entity can exist with or without a related instance in the related entity

An advantage of custom development might be a. You get a system that is tailored to the current business and meets specific needs b. The rapid development of custom systems c. The low cost (as compared to buying a package) d. The low risk factor e. The ability for in-house developers to work on systems that are in new programming languages and in technologies that are unknown to them prior to the development

You get a system that is tailored to the current business and meets specific needs

Anthony is working on the cardinality of doctors and patients in a large urban hospital. With the large number of doctors with varying specialties and patients that may have more than one ailment, he thinks the relationship might be notes as: a) 1 to 1 b) 1 to 2 c) 1 to many d) Many to many e) Many to 1

many to many

If the logical data model contains attribute values that depend on an attribute that is not the identifier, then it is in a) base normal form b) first normal form c) non-normal form d) second normal form e) third normal form

non-normal form

A logical data model that does not lead to repeating fields and that the data models leads to tables containing fields that are dependent on the whole identifier is in normal form a) balanced b) first c) primary d) second e) third

second

An ERD is a picture that shows how data and information is processed and transformed by a business system

False

An entity is described by an action verb

False

An illustration of the transformation of data into business value is an ERD

False

CASE tools have 'data repositories'

False

During the analysis phase, analysts create programming models to represent how the business system will operate

False

ERDs and DFDs are two techniques for data modeling

False

ERDs and DFDs are two techniques for process modeling

False

ERDs are drawn in several levels: Context ERD diagrams; Level 0 ERD diagrams, Level 1 ERD diagrams

False

In an entity called STUDENT, you might find attributes of PROFESSOR-ID, Last-Name, First-Name, and CLASSROOM

False

In defining LAST-NAME in the data dictionary, we might describe it as a character field having from 1 to 15 alphabetic characters

False

On an ERD, similar kinds of information are listed together and placed inside boxes called data containers

False

Relationships are drawn with lines showing cardinality and plurality

False

Relationships are some type of information that is captured about entities

False

The three steps in creating an ERD are: (1) identify the entities; (2) identify the processes; (3) identify the relationships

False

If the logical data model does not contain attributes that have repeating values it is in a) base normal form b) first normal form c) non-normal form d) second normal form e) third normal form

First normal form

A data model is a a) The mathematical model of formulas and logic used in a system b) The abstract creating of an ideal system transformation c) The model that is produced by extreme programming d) The expanded, thoroughly balanced and normalized use case for a system e) A formal way of representing the data that are used and created by a business system

Formal way of representing the data that are used and created by a business system

Omar has a model with 85 entities. He can a) Compress these into at most seven entity grouping units b) Group these into related subject areas c) Stop - he has all entities defined d) Sort the entities alphabetically e) Co-validate the entities with the level 2 DFD diagrams

Group these into related subject areas

Where are the decisions stored that are made regarding the hardware and software that will be purchased to support the new system? a. Order Manifest b. Hardware Sales Receipt c. Suppliers' Computer System d. President's Office e. Hardware and Software Specification

Hardware and Software Specification

System design is the determination of the overall system architecture-consisting of a set of physical processing components, [ ] and the communication among them-that will satisfy the system's essential requirements a. Workmanship b. Order entry methods, HR feedback c. Hardware, Software, People d. Engineering data plans, fiber optic specifications e. None of these

Hardware, Software, People

If (a) the business is unique, (b) there is a desire to build in-house skills; (c) the time frame is flexible, it might be best to: a. Do in-house / custom development b. Buy an ERP system c. Outsource to India d. Purchase a software package e. Hire a consultant

Do in-house / custom development

Data modeling is an iterative process

True

On an ERD a) Processes are listed alphabetically with relationship connections drawn between processes b) Data elements are listed alphabetically with a cross listing to the processes that manipulate them c) Data elements are described as singular (1:1); plurals (1:N); or didactic (M:N) d) Data elements are grouped in a hierarchical structure that is uniquely identified by number e) Data elements are listed together and place inside boxes called entities.

Data elements are listed together and placed inside boxes called entities

A(n) entity cannot exist without the presence of another entity or has an identifier that is based on another entity's attribute a. independent b. incomplete c. dependent d. variable e. non-complying

Dependent

A data model is a formal way of representing the data that are used and created by a business system

True

A graphical illustration that shows the information that is created, stored, and used by a business system would be an ERD

True

A textbook-provided example of a 'full-service CASE' tool is Visible Analyst

True

An analyst can read an ERD to discover the individual pieces of information in a system and how they are organized and related to each other

True

An entity is the basic building block for a data model

True

CRUD stands for create, read, update, and delete and can be used to verify DFDs and ERDs

True

Data models can be either logical or physical

True

During the analysis phase logical data models are created

True

ERDs can be quite complex and might have hundred or thousands of entities

True

Entities are a person, place, or thing

True

Entities are further designed with attributes

True

In an entity called STUDENT, you might find attributes of Student-ID, Last-Name, First-Name, and cell-phone

True

In defining the data characteristics of Universal Product Codes, we might describe them as twelve characters made up of digits - numeric only

True

Metadata is data about data

True

One of the first places to start developing Entity Relationship Diagrams is by looking at the Level 0 process models (DFDs) and the use cases for data flows and data stores

True

One of the most commonly used techniques for data modeling is ERDs

True

Relationships are associations between entities

True

The three steps in creating an ERD are: (1) identify the entities; (2) identify the attributes; (3) identify the relationships

True

When validating ERDs you should balance ERD entities with the data flows and data stores from the DFD process diagrams

True