KU BSAN 325 Exam 2

7. A ________ can be best understood as data in motion, moving from one place in a system to another. A. Process B. Data flow C. Data store D. Data source

B

A ________ is a picture of the movement of data between external entities and the processes and data stores within a system. A. Process flow diagram B. Data flow diagram C. Data diagram D. Procedure flow diagram

B

A(n) ________ is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation. A. Derived attribute B. Primary key C. Multi-valued attribute D. Index

B

________ - A simple design to show the placement of information elements on a screen and the space needed for each element. A. Mainframe B. Wire frame C. Main Design D. Adobe In design E. Simplex

B

A ________ is the work or actions performed on data so that they are transformed, stored, or distributed. A. Process B. Data store C. Flowchart D. Data flow

A

A unary relationship is a relationship between the instances of ________ entity class(es). A. One B. Two C. Three D. Five

A

An entity ________ is a single occurrence of an entity class. A. Instance B. Object C. Attribute D. Class

A

In terms of depth of information, the requirement elicitation methods can be expressed as: A. Interview > Surveys > Observation B. Observation > Interview > Surveys C. JAD > Observation > Surveys D. Surveys > JAD > Interviews E. Surveys > Observation > JAD

A

Most relational database systems support: A. Referential integrity B. Pop-up menus C. Customization user-interface colors and graphics D. The 'three-clicks' rule E. Broadband connectivity

A

Which of the following is a primary way to gather information? A. Interviewing B. Gather documentation C. Review procedures D. Direct observation

A

Which of the following is an example of an open-ended question? A. What is the main issue with the current computer system? B. What unit are sales currently shown in? C. Do you participate in flextime? D. When was the last time the system malfunctioned?

A

6. ________ are NOT a component of data flow diagram symbols. A. Processes B. Data stores C. Data flows D. Data programs

D

A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. A. Dimension B. Attribute C. Object D. Entity

D

Brianna has a process that has two inputs but only one output. A. This is an error as there needs to be the same amount of inputs as outputs B. This is an error as process do not have inputs or outputs C. This is normal as all processes have two inputs and one output D. This is normal as all processes need at least one input and at least one output E. This is an error as processes only produce output

D

Functional requirements can be either ___________, or __________. A. Process-oriented, system-oriented B. Process-oriented, data store-oriented C. Process-oriented, data-oriented D. Process-oriented, information-oriented E. Process-oriented, knowledge-oriented

D

Once an information system is installed, the system is essentially in which phase of the systems development life cycle (SDLC)? A. Design B. Planning C. Analysis D. Maintenance

D

The context diagram shows: A. Detailed processing logic B. All major processes C. All the data stores in the system D. The "big picture" of the system with external entities and only one process E. The system in context with all other systems in that department (for example, accounts payable, accounts receivable, etc.)

D

_________ are unknown errors after installation. A. Unknown Trojans B. Recurring viruses C. Program restarts D. Latent defects E. System uncertainties

D

Data cannot move directly from one data store to another data store. Data must be moved by a ________. A. Flow chart B. Procedure C. Process D. Data source

C

Each ________ in a relation corresponds to an attribute of that relation. A. Entity B. Data C. Column D. Row

C

In terms of user involvement, the requirement elicitation methods can be expressed as: A. Interview > Surveys > JAD B. Observation > JAD > Surveys C. JAD > Surveys > Observation D. Surveys > JAD > Interviews E. Surveys > Observation > Interviews

C

One or more attributes whose values uniquely identifies each entity instance/row/record is called a: A. Multi valued attribute B. Derived attribute C. Candidate identifier D. Composite attribute E. Weak identifier

C

One purpose of database design is to structure the data in stable structures, called normalized tables, that are not likely to change over time and that have minimal ________. A. Data B. Space C. Redundancy D. Columns

C

Operational, __________, Security, Cultural/Political are the four dimensions of nonfunctional requirements. A. Technical B. Economic C. Performance D. Flexibility E. Design

C

What diagram will have processes with one decimal place (like 3.1, 3.2, and 3.3) and might have flows coming in (or going out) that are not illustrated? A. Context diagram B. Level 0 diagram C. Level 1 diagram D. UML state diagram E. Level 0 diagram

C

Which installation runs the old information system and the new one at the same time until management decides the old system can be turned off? A. Direct installation B. Phased installation C. Parallel installation D. Single-location installation

C

___________: Verifies that protection mechanisms built into the system will protect it from improper penetration. A. Performance testing B. Recovery testing C. Security testing D. Stress testing E. Break-open testing

C

True or false: All entity classes inherit identifying attributes from other entity classes to uniquely identify their own entities.

FALSE

True or false: A database can be modeled as a collection of entities and relationship between entities

TRUE

What is SQL? And what is its usage in relational databases?

SQL is the acronym for Structured Query Language. SQL is the standard language for accessing the data in the tables and it operates on complete tables (as compared to individual records in the tables). SQL is the standard for retrieving information from a relational database.

In logical database modeling and design, we translate the ________ E-R data model for the application or enterprise, developed without explicit consideration of specific user interfaces, into normalized data requirements. A. Normal B. Physical C. Logical D. Conceptual

D

The most common format used for data modeling is ________ diagramming. A. Entity-class B. Entity-object C. Entity-subject D. Entity-relationship

D

The most popular type of database today is the: A. Hierarchical database B. Tree database C. Green database D. Relational database E. Piecemeal database

D

___________ is used when validity of data collected using other methods is in question. A. Interview B. Job application document C. Survey D. Observation E. Interrogation

D

In general, all process models will have as many level 1 diagrams as there are processes on the level 0 diagram.

TRUE

True or false: A fork in a data flow means that the same data goes to two different processes or data stores

TRUE

True or false: A good conceptual design and proper ER to relational table conversion will automatically result in highest normalization of resultant relational database.

TRUE

Activities in the implementation and maintenance phase include (mark all that apply): A. Coding B. Testing C. Analysis D. Documentation E. Training

A B D E

___________ is the most used fact-finding technique. A. Interview B. Job application document C. Survey D. Observation E. User involvement

A

In logical database design, we use a process called ________, which is a way to build a data model that has the properties of simplicity, non redundancy, and minimal maintenance. A. Data modeling B. Database designing C. De-normalization D. Normalization

D

List and explain any three out of the four ACID properties.

Atomicity - 'All or none' of an update occurs on a database Consistency - Any data written to the database must be valid according to all defined rules of the database Isolation (data concurrency) - When multiple users access the same element of a database at the same time, each of them feels that he/she alone is using it. Durability - No update made by user should be lost even in case of a power outage

Designing user interfaces is a ________. A. Business focused activity B. Functional requirement C. Nonfunctional requirement D. User focused activity E. System focused activity

B

The cardinality for the following relationship can be explained as follows: A. A teacher can teach one to many courses while a course can be taught by one to many teachers. B. A teacher can teach zero to many courses while a course can be taught by only one teacher. C. A teacher can teach only one course while a course can be taught by zero to many teachers. D. A teacher can teach one to many courses while a course can be taught by only one teacher. E. A teacher can teach zero to many courses while a course can be taught by zero to many teachers.

B

What is the primary purpose of JAD? A. To diagram forms and report generation B. To gather systems requirements simultaneously C. To create a prototype D. To assist with business process re engineering

B

Which installation changes from the old information system to the new one incrementally, starting with one or a few functional components and then gradually extends the installation to cover the whole new system? A. Direct installation B. Phased installation C. Parallel installation D. Single-location installation

B

___________: A specific scenario of transactions, queries, or navigation paths that represent a typical, critical, or abnormal use of the system. A. Make and break B. Test case C. A/B test D. Test scenario E. Extreme program

B

A process model is: A. The output of the interviewing process B. The work plan C. The model that is produced by extreme prototyping D. The expanded and thoroughly balanced use case for a system E. A graphical way of representing how a business system operates

E

What diagram will have sub-processes with numbers like 3.3.1, 3.3.2, 3.3.3 (etc.) and also have flows coming in (or going out) that are not illustrated? A. Context diagram B. Level 0 diagram C. Gantt diagram D. Level 1 diagram E. Level 2 diagram

E

___________ requirements are finalized in the design phase. A. Functional requirements B. Nonfunctional requirements C. User requirements D. Business requirements E. System requirements

E

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

FALSE

True or false: Functional decomposition is a (single step) non repetitive procedure.

FALSE

True or False: JAD stands for joint application design and is an intense, highly structured process.

True