Data Modeling and Database Design
Exam Answer Key
Course Introduction
This course provides an in-depth introduction to the principles and practices of data modeling and database design. Students will learn how to analyze information requirements, construct conceptual, logical, and physical data models, and implement relational databases using industry-standard methodologies. Topics include entity-relationship modeling, normalization, integrity constraints, and structured query language (SQL). The course also covers issues related to database management, such as data security and consistency. Through hands-on exercises and projects, students gain practical experience in designing efficient, scalable, and reliable database systems suitable for real-world applications.
Recommended Textbook
Essentials of Systems Analysis and Design 6th Edition by Joseph Valacich
Available Study Resources on Quizplus
10 Chapters
1225 Verified Questions
1225 Flashcards
Source URL: https://quizplus.com/study-set/1472 Page 2
Chapter 1: The Systems Development Environment
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/29303
Sample Questions
Q1) An aggregation of parts is also called a(n):
A) interface.
B) subsystem.
C) collection.
D) accumulation.
Answer: B
Q2) The environment of a state university would NOT include:
A) prospective students.
B) the legislature.
C) the president's office.
D) the news media.
E) a foundation.
Answer: C
Q3) Identify six general types of CASE tools.
Answer: Diagramming tools, computer display and report generators, analysis tools, central repository, documentation generators, and code generators are the six general types of CASE tools mentioned in the textbook.
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: The Sources of Software
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/29305
Sample Questions
Q1) Which of the following is not a way of validating purchased software information?
A) Reviewing software documentation and technical marketing literature
B) Sending prospective vendors a questionnaire asking specific questions about their packages
C) Using the software yourself and running it through a series of tests based on the criteria for selecting software
D) Obtaining feedback from other users of the software
E) Purchasing the software first and then testing
Answer: E
Q2) When developing information systems, an organization could use all of the following EXCEPT:
A) an information technology services firm.
B) open-source software.
C) cloud computing.
D) in-house development.
E) hardware maintenance firms.
Answer: E
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Managing the Information Systems Project
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/29306
Sample Questions
Q1) Skills that include interpreting system requests and specifications, site preparation and user training, and contact point for customers best represent:
A) leadership.
B) management.
C) customer relations.
D) conflict management.
E) team management.
Answer: C
Q2) Which of the following is NOT a task characteristic?
A) A task should have well-accepted predecessor and successor steps.
B) A task should have a single and identifiable deliverable.
C) A task should have a known method or technique.
D) A task should be completed by only one person.
E) A task is measurable so that percent completed can be determined.
Answer: D
Q3) Establishing a relationship with a customer is a project initiation activity.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Systems Planning and Selection
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/29307
Sample Questions
Q1) The extent to which the project is viewed as improving profits, customer service, etc., and the duration of these benefits best defines which of the following evaluation criteria?
A) Potential benefits
B) Resource availability
C) Technical difficulty or risks
D) Strategic alignment
E) Value chain analysis
Q2) Which of the following is a project initiation activity?
A) Developing a preliminary schedule
B) Setting a baseline project plan
C) Determining project standards and procedures
D) Establishing a relationship with the customer
E) Developing a communication plan
Q3) Most techniques for analyzing economic feasibility employ the time value of money concept.
A)True
B)False
Q4) Briefly identify three commonly used economic cost-benefit analysis techniques.
Q5) Briefly identify and define the six major categories of feasibility.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Determining System Requirements
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/29308
Sample Questions
Q1) The most useful forms do not contain data.
A)True
B)False
Q2) In order to promote more truthful responses, the general nature of the interview should not be explained to the interviewee in advance.
A)True
B)False
Q3) Briefly identify and describe the modern methods for determining requirements.
Q4) Referencing a JAD session, the sponsor is the individual responsible for organizing and running a JAD session.
A)True
B)False
Q5) A major disadvantage of closed-ended questions is that useful information that does not quite fit the defined answers may be overlooked as the respondent tries to make a choice instead of providing his or her best answer.
A)True
B)False
Q6) Briefly identify the traditional methods for determining requirements.
Q7) Briefly identify and describe the participants of a JAD session.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Structuring System Requirements: Process
Modeling
Available Study Resources on Quizplus for this Chatper
104 Verified Questions
104 Flashcards
Source URL: https://quizplus.com/quiz/29309
Sample Questions
Q1) A primitive level data-flow diagram is the first deliverable produced during requirements structuring.
A)True
B)False
Q2) Completeness, consistency, timing, iterative development, and primitive DFDs are guidelines for drawing DFDs.
A)True
B)False
Q3) Assume Process 7.4 produces a data flow and that Process 7.2 must be ready to accept it; we would say that these processes are physically linked to each other.
A)True
B)False
Q4) The lowest level of decomposition for a data-flow diagram is called the:
A) context diagram.
B) level-0 diagram.
C) level-1 diagram.
D) primitive diagram.
E) cohesive diagram.
Q5) What is meant by DFD completeness? What is meant by DFD consistency?
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Structuring System Requirements: Conceptual
Data Modeling
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/29310
Sample Questions
Q1) The alternative that goes beyond simply solving the problem in question and focuses instead on systems that contain many extra features users may desire is referred to as a:
A) low-end alternative.
B) high-end alternative.
C) quality-focused alternative.
D) requirements-dependent alternative.
E) constraints-dependent alternative.
Q2) An attribute (or combination of attributes) that uniquely identifies each instance of an entity type defines:
A) data element occurrence.
B) trigger.
C) candidate key.
D) associative entity.
E) data marker.
Q3) A join is an association between the instances of one or more entity types that is of interest to the organization.
A)True
B)False
Q4) Briefly discuss generating alternative design strategies.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Designing the Human Interface
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/29311
Sample Questions
Q1) A business document that contains some predefined data and may include some areas where additional data are to be filled in best describes a:
A) written procedure.
B) turn-around document.
C) form.
D) report.
E) coupon.
Q2) Which of the following is an example of a form?
A) Invoice
B) Pie chart
C) Mailing labels
D) An electronic spreadsheet
E) Weekly sales summaries by region and salesperson
Q3) When designing textual output, you should use single spacing wherever possible.
A)True
B)False
Q4) Designing usable forms and reports requires your active interaction with users.
A)True
B)False
Q5) Briefly discuss the SOS guidelines.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Designing Databases
Available Study Resources on Quizplus for this Chatper
311 Verified Questions
311 Flashcards
Source URL: https://quizplus.com/quiz/29312
Sample Questions
Q1) Hiding the internal implementation details of an object from its external view is called incorporation.
A)True
B)False
Q2) During eXtreme Programming:
A) system requirements are produced during the systems analysis phase.
B) system specifications are created during the design phase.
C) coding and testing are done at the beginning of the implementation phase.
D) system requirements, system specifications, and coding and testing activities are combined into a single analysis-design-code-test process.
E) none of the above are correct.
Q3) An actor always initiates a use case.
A)True
B)False
Q4) A business rule is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Systems Implementation and Operation
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/29304
Sample Questions
Q1) During systems design, an overall test plan is developed.
A)True
B)False
Q2) Identify several types of user documentation.
Q3) The systems implementation and operation phase of the SDLC is analogous to the maintenance process of implementing changes.
A)True
B)False
Q4) Unit testing is a technique used in examining individual lines of code, where a few lines of code are used to substitute for subordinate modules.
A)True
B)False
Q5) The systems analysis phase of the SDLC is analogous to the maintenance process of obtaining maintenance requests.
A)True
B)False
Q6) Training and support are not critical for the success of an information system. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12