Information Systems Analysis and Design
Exam Materials
Course Introduction
Information Systems Analysis and Design is a comprehensive course that introduces students to the methodologies, techniques, and tools used in analyzing business requirements and designing effective information systems solutions. The course covers the entire systems development life cycle, including requirements gathering, process modeling, data modeling, system architecture, and interface design. Students learn how to apply structured and object-oriented approaches for system analysis, and develop practical skills in eliciting user needs, documenting system specifications, and designing logical and physical system components. The course emphasizes teamwork, problem-solving, and the use of modern CASE tools, preparing students to contribute effectively to information systems projects in real-world organizational settings.
Recommended Textbook
Modern Database Management 12th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1469 Verified Questions
1469 Flashcards
Source URL: https://quizplus.com/study-set/1058
Page 2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/20934
Sample Questions
Q1) A user view is:
A) what a user sees when he or she looks out the window.
B) a table or set of tables.
C) a logical description of some portion of the database.
D) a procedure stored on the server.
Answer: C
Q2) All of the following are primary purposes of a database management system (DBMS) EXCEPT:
A) creating data.
B) updating data.
C) storing data.
D) providing an integrated development environment.
Answer: D
Q3) With the database approach, data descriptions are stored in a central location known as a:
A) server.
B) mainframe.
C) PC.
D) repository.
Answer: D
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20935
Sample Questions
Q1) While business rules are not redundant, a business rule can refer to another business rule.
A)True
B)False
Answer: True
Q2) Data modeling may be the most important part of the systems development process because:
A) data characteristics are important in the design of programs and other systems components.
B) the data in a system are generally less complex than processes and play a central role in development.
C) data are less stable than processes.
D) it is the easiest.
Answer: A
Q3) A fact is an association between two or more:
A) words.
B) terms.
C) facts.
D) nuggets.
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Enhanced E-R Model
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20936
Sample Questions
Q1) An entity cluster should focus on some area of interest to some community of users, developers or managers.
A)True
B)False
Answer: True
Q2) The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.
A)True
B)False
Answer: True
Q3) The third step in the data modeling process with a packaged data model is:
A) rename identified data elements.
B) rename relationships.
C) map data to be used from package to data in current databases.
D) interview users.
Answer: C
Q4) Describe how subtype discriminators are used when we have overlapping subtypes.
Answer: When we have overlapping subtypes, we need to create a composite subtype discriminator with Boolean values.
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20937
Sample Questions
Q1) A referential integrity constraint is a rule that maintains consistency among the rows of two relations.
A)True
B)False
Q2) When two or more attributes describe the same characteristic of an entity, they are synonyms.
A)True
B)False
Q3) Data integrity consists of powerful operations to manipulate data stored in relations.
A)True
B)False
Q4) Understanding the steps involved in transforming EER diagrams into relations is important because:
A) one must be able to check the output of a CASE tool.
B) there are rarely legitimate alternatives from which to choose.
C) CASE tools can model any situation.
D) CASE tools model hypothetical business problems.
Q5) Discuss why it is a good idea to create an instance of your relational schema with sample data.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20938
Sample Questions
Q1) A form of denormalization where the same data are purposely stored in multiple places in the database is called:
A) data duplication.
B) data replication.
C) advanced placement.
D) horizontal partitioning.
Q2) One field or combination of fields for which more than one record may have the same combination of values is called a(n):
A) secondary key.
B) index.
C) composite key.
D) linked key.
Q3) A(n) ________ is a routine that converts a primary key value into a relative record number.
A) record index calculator
B) index pointer program
C) hashing algorithm
D) pointing algorithm
Q4) What is a hashing algorithm and how is it used in hashed file organizations?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20939
Sample Questions
Q1) What is a materialized view, and when would it be used?
Q2) What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
B) Selects the "*" field from the Customer table for each row with a customer labeled "Best"
C) Selects fields with a "*" in them from the Customer table
D) Selects all the fields from the Customer table for each row with a customer labeled "*"
Q3) A view may not be updated directly if it contains:
A) the SELECT clause.
B) the HAVING clause.
C) the FROM clause.
D) the WHERE clause.
Q4) The comparison operators = and != are used to establish a range of values.
A)True
B)False
Q5) Discuss the pros and cons of using dynamic views.
Q6) Explain the three classes of SQL commands and when they would be used.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/20940
Sample Questions
Q1) A procedure is:
A) stored outside the database.
B) given a reserved SQL name.
C) called by name.
D) unable to be modified.
Q2) What is a self-join and how is it used?
Q3) SQL:2008 allows one to calculate linear regressions, moving averages and correlations without moving the data outside of the database.
A)True
B)False
Q4) In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.
A) correlated
B) paired
C) natural
D) inner
Q5) Combining a table with itself results in a faster query.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20941
Sample Questions
Q1) Discuss the distribution of application logic components across clients and servers in the client/server environment.
Q2) The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access.
A) software services
B) grid computing
C) network computing
D) cloud computing
Q3) Extensible Markup Language (XML) is a scripting language based upon SGML that allows the creation of customized tags.
A)True
B)False
Q4) Which of the following is a component of processing logic?
A) Input
B) Output
C) Retrieval
D) Business rules
Q5) Discuss the differences between two-tier and three-tier architectures.
Q6) Explain how middleware is used in a two-tier application.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/20942
Sample Questions
Q1) An operational data store (ODS) is a(n):
A) place to store all unreconciled data.
B) representation of the operational data.
C) integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.
D) small-scale data mart.
Q2) A separate data warehouse causes more contention for resources in an organization.
A)True
B)False
Q3) Independent data marts do not generally lead to redundant data and efforts.
A)True
B)False
Q4) ________ is/are a new technology which trade(s) off storage space savings for computing time.
A) Dimensional modeling
B) Column databases
C) Fact tables
D) Snowflake schemas
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20943
Sample Questions
Q1) A technique using artificial intelligence to upgrade the quality of raw data is called:
A) dumping.
B) data reconciliation.
C) completion backwards updates.
D) data scrubbing.
Q2) Bit-mapped indexing is often used in a data warehouse environment.
A)True
B)False
Q3) What is a field-level transformation, and what different types exist?
Q4) All of the following are ways to consolidate data EXCEPT:
A) application integration.
B) data rollup and integration.
C) business process integration.
D) user interaction integration.
Q5) One of the biggest challenges of the extraction process is managing changes in the source system.
A)True B)False
Q6) What are some of the reasons for deteriorated data quality?
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Big Data and Analytics
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/20944
Sample Questions
Q1) Word processing documents are commonly stored in a 'document store' NoSQL database model.
A)True
B)False
Q2) Descriptive, predictive, and ________ are the three main types of analytics.
A) adaptive
B) comparative
C) prescriptive
D) decisive
Q3) A researcher trying to explain why sales of garden supplies in Hawaii have decreased would be an example of ________ data mining.
A) explanatory
B) confirmatory
C) exploratory
D) laboratory
Q4) Many developing countries are using advanced applications of analytics to utilize data collected from mobile devices.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/20945
Sample Questions
Q1) The ________ occurs when one user reads data that have been partially updated by another user.
A) inconsistent read problem
B) distant read problem
C) honest dirty data
D) data quality problem
Q2) Specifications for transactions do not need to be reviewed quickly.
A)True
B)False
Q3) A business transaction is a sequence of steps that constitute some well-defined business activity.
A)True
B)False
Q4) Controls designed to restrict access and activities are called:
A) schemas.
B) business rules.
C) encryption controls.
D) authorization rules.
Q5) What are some of the core roles of a database administrator?
Q6) What are integrity controls? Describe the different types.
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Distributed Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/20946
Sample Questions
Q1) An optimization strategy that allows sites that can update to proceed and other sites to catch up is called:
A) read-only commit.
B) lazy commit.
C) sequenced commit.
D) linear set up.
Q2) With a two-phase commit strategy for synchronizing distributed data, committing a transaction is faster than if the originating location were able to work alone.
A)True
B)False
Q3) All of the following are advantages of vertical partitioning EXCEPT: A) efficiency.
B) security.
C) ease of querying.
D) easier to set up than horizontal partitioning.
Q4) Horizontal partitioning offers increased efficiency because data are close to use areas.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/20947
Sample Questions
Q1) An object encapsulates both data and behavior.
A)True
B)False
Q2) A ________ is the implementation of an operation.
A) meta-operation
B) method
C) query
D) constructor
Q3) Both Object-oriented and E-R objects exhibit behaviors.
A)True
B)False
Q4) It is only through an operation that other objects can access or manipulate information stored in an object.
A)True
B)False
Q5) According to the UML Notation Guide, overlapping means:
A) a descendant may be descended from more than one of the subclasses.
B) a descendant may not be descended from more than one of the subclasses.
C) all subclasses have been specified, and no others are expected.
D) the list of objects is stable, but relationships will change.
To view all questions and flashcards with answers, click on the resource link above. Page 16