Database Design and Management Question Bank
Course Introduction
This course provides a comprehensive introduction to the fundamental principles and practices of database design and management. Students will explore data modeling, relational database theory, and normalization techniques, while gaining hands-on experience with SQL and database management systems (DBMS). The course covers the entire database development lifecycle, including requirements analysis, conceptual and logical design, implementation, security, and performance optimization. By emphasizing both theoretical concepts and practical skills, the course prepares students to design, implement, and maintain efficient, reliable, and secure databases to support diverse organizational needs.
Recommended Textbook Systems Analysis and Design 6th Edition by
Alan Dennis
Available Study Resources on Quizplus
14 Chapters
992 Verified Questions
992 Flashcards
Source URL: https://quizplus.com/study-set/646
Page 2
Chapter 1: The Systems Analyst and Information Systems Development
Available Study Resources on Quizplus for this Chatper
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/12234
Sample Questions
Q1) Interviewing is generally done in the analysis phase of the SDLC.
A)True
B)False Answer: True
Q2) Which was NOT given as a method for determining business requirements?
A)Benchmarking
B)Interviewing
C)Observation
D)Document analysis
E)Questionnaires and surveys
Answer: A
Q3) Systems Analysis and Design projects are highly effective,with less than 3% of all projects cancelled or abandoned.
A)True
B)False Answer: False
Q4) What calculations are used in economic feasibility?
Answer: Return on investment;NPV - net present value of money;break-even analysis;cost/benefit analysis
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Project Selection and Management
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/12235
Sample Questions
Q1) What are the main differences between the Waterfall Development and the Rapid Application Development methodologies?
Answer: Waterfall methodologies stress thorough use of the SDLC and can lead to longer project completion times while RAD methods generally result in shorter time to develop and implement.
Q2) RAD is an acronym for:
A)Real Application Development
B)Rapid Application Design
C)Rapid Authentic Development
D)Real Autonomous Development
E)Rapid Application Development
Answer: E
Q3) Throwaway Prototyping balances the benefits of well-thought-out analysis and design phases with the advantages of using prototypes to refine key issues before a system is built.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Requirements Determination
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/12236
Sample Questions
Q1) When an analyst is seeking more information from a response to questions they would probably use:
A)Open Ended questions
B)Close ended questions
C)Probing questions
D)All of these
Answer: C
Q2) An example of a nonfunctional requirement is ____________
A)Supplier table is available
B)The system must contain customer order history for three years
C)System can be used in any of 100 offices worldwide
D)SQL queries from customer table and order table are available
E)Customer zipcode is formatted as character data
Answer: C
Q3) The most commonly used requirements gathering technique is the interview..
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Use Case Analysis
Available Study Resources on Quizplus for this Chatper
69 Verified Questions
69 Flashcards
Source URL: https://quizplus.com/quiz/12237
Sample Questions
Q1) Use cases are used to more fully delineate _____.
A)Resources used in the system
B)System boundaries
C)System proposals
D)System requirements
E)Data flows
Q2) External triggers might be something like a customer calling a doctor for an appointment or a student registering for a class.
A)True
B)False
Q3) What are the steps for writing a use case?
Q4) Dr.O'Brien's dental office calls a patient three days before an appointment.This could be an example of a temporal trigger.
A)True
B)False
Q5) Shaunti has trouble identifying (a)the primary actor and (b)the trigger for a use case.What directions would you suggest to her?
Q6) What are the most common ways to gather information for use cases?
Q7) Matt has identified 15 major steps in a use case.What should he do now?
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Process Modeling
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/12247
Sample Questions
Q1) What is the relationship between context diagrams and level 0 diagrams.
Q2) Which of the following would be a 'black hole' error on a DFD?
A)A process has no input
B)A process has no output
C)A process has four inputs and only three outputs
D)Data moves directly from a data store from an external entity
E)Two processes send data flows to the same data store
Q3) Data flow diagrams are:
A)Usually created by users and reviewed by analysts
B)Usually jointly created by analysts and users
C)Usually created by the project team and reviewed by users for correctness
D)Usually created by the project champion and reviewed by the project team
E)Usually created by business analyst and reviewed by the infrastructure analyst
Q4) A process is:
A)An activity of a function that is performed for some specific business reason
B)A single piece of data within a system
C)A collection of data within a system
D)A person,organization or system that is external to the system
E)A combination of function and the data it acts upon
Q5) What is the relationship between level 0 and level 1 DFD diagrams?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Data Modeling
Available Study Resources on Quizplus for this Chatper
78 Verified Questions
78 Flashcards
Source URL: https://quizplus.com/quiz/12238
Sample Questions
Q1) A(n)_____ entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity.
A)dependent
B)incomplete
C)independent
D)intersection
E)non-identifying
Q2) In the sample data for the STUDENT entity,there are repeating values for class and semester attributes.For example Adam Murphy took CIS 370 section 2 in fall 2008;Brenda Olson took CIS 370 section 2 in fall 2008;Jing Zhang took CIS 370 section 2 in fall 2008;etc.What is the process to modify this entity so that there are no attributes with multiple values?
Q3) In adding attributes to an ERD,which of the following might NOT be a good resource for attributes?
A)From the CASE tool
B)Data flows from DFD's
C)Requirements documents
D)The system proposal document
E)Through interviews (what users need for reports and processing)
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 7: Moving Into Design
Available Study Resources on Quizplus for this Chatper
66 Verified Questions
66 Flashcards
Source URL: https://quizplus.com/quiz/12239
Sample Questions
Q1) 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
Q2) A department head is apprehensive as to what implementation system he should employ.The best method of ensuring a successful and efficient installation of the new systems would be to utilize an alternative matrix.
A)True
B)False
Q3) 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
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Rchitecture Design
Available Study Resources on Quizplus for this Chatper
64 Verified Questions
64 Flashcards
Source URL: https://quizplus.com/quiz/12240
Sample Questions
Q1) An ATM dialing a network provides the IT department with a quick cash withdrawal for emergency purposes.
A)True
B)False
Q2) Mobile application interface capabilities are greater than client-server architectures.
A)True
B)False
Q3) Client-based architecture is complex and there is minimal chance of network circuits being overloaded due to growing network applications.
A)True
B)False
Q4) Software systems can be divided into how many basic functions?
Q5) Describe the difference between a thick and a thin client.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: User Interface Design
Available Study Resources on Quizplus for this Chatper
69 Verified Questions
69 Flashcards
Source URL: https://quizplus.com/quiz/12241
Sample Questions
Q1) Which of the following is not a common Interface Evaluation technique?
A)Interactive evaluation
B)Walk-through evaluation
C)Heuristic evaluation
D)Use scenario normalization
E)Formal usability testing
Q2) Space is generally at a premium on forms and reports ,thus squeezing information onto forms is considered a wise business decision.
A)True
B)False
Q3) Interface Structure Design defines the application coding structure used (such as developing prototypes in Visual Basic).
A)True
B)False
Q4) Jamal is creating a user interface.He wants what he calls an 'oops' button on every screen and form (or an 'undo' button).This is a good design consideration.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Program Design
Available Study Resources on Quizplus for this Chatper
68 Verified Questions
68 Flashcards
Source URL: https://quizplus.com/quiz/12242
Sample Questions
Q1) There are some 'system-related' data stores,data flows and processes that must be added when creating the physical DFD
A)True
B)False
Q2) In determining if a process is to be automated,the project team will do all of the following EXCEPT:
A)Weigh the costs
B)Redraw the logical DFD as a combined logical/physical DFD
C)Determine benefits
D)Evaluate the efficiency
E)Consider the integrity of the process to the system
Q3) What is Fan-in and Fan-out?
Q4) Summarize the quality checks that should be performed when reviewing structure charts.
Q5) Every part of a system that is not automated will:
A)Be ignored in the implementation of the system
B)Be drawn as only logical DFDs not physical DFDs
C)Be outside the human-machine boundary
D)Go back through the analysis phase to become automated
E)Will be drawn as diamond shapes on the structure charts
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Data Storage Design
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/12243
Sample Questions
Q1) When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.
A)True
B)False
Q2) When changing logical data models to physical data models,you will want to change entities to tables or files.
A)True
B)False
Q3) One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.
A)True
B)False
Q4) Systems to support decision making generally need to update data frequently with a large volume of data.
A)True
B)False
Q5) Microsoft Access is an end-user DBMS. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Moving Into Implementation
Available Study Resources on Quizplus for this Chatper
67 Verified Questions
67 Flashcards
Source URL: https://quizplus.com/quiz/12244
Sample Questions
Q1) User documentation must be developed at the end of the project,after all programming,testing and approvals have occurred.To do it any earlier may risk not including changes in the system.
A)True
B)False
Q2) The term 'bug' in software came from:
A)An English translation of the word for defect in German
B)The story of a moth getting caught inside an early computer
C)The acronym BUG - for binary unknown glitch
D)No one knows the reason
E)None of these
Q3) As compared to integration testing,system testing:
A)Is much broader in scope
B)Uses production data (rather than test data)
C)Is done by hand-picked end-users (rather than systems analysts)
D)Involves both black-box and red-box testing
E)Makes more extensive use of stubs
Q4) Bruce is a senior project manager.What activities should he be doing in the programming / development phase?
Q5) What is the difference between usability testing and performance testing?
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Transition to the New System
Available Study Resources on Quizplus for this Chatper
67 Verified Questions
67 Flashcards
Source URL: https://quizplus.com/quiz/12245
Sample Questions
Q1) One challenge of being a change agent is to make the benefits of adopting the system more attractive to reluctant users.
A)True
B)False
Q2) When considering costs of a new system conversion,which is NOT a common cost to consider?
A)the cost of running two systems with a parallel conversion
B)the costs of more staff at more locations for support in a simultaneous conversion
C)the salary costs of users,trainers,administrators,consultants
D)the hardware costs for a pilot system
E)the extra programming costs for a modular conversion
Q3) In terms of risk in conversion,a direct conversion of the entire system at all locations at one time would be the highest risk.
A)True
B)False
Q4) In motivating users to adopt a new system,it is suggested that change agents develop two clear and concise lists of costs and benefits provided by the new system as compared to the as-is system.Why is this important?
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 14: The Movement to Objects
Available Study Resources on Quizplus for this Chatper
67 Verified Questions
67 Flashcards
Source URL: https://quizplus.com/quiz/12246
Sample Questions
Q1) Generally speaking,which of the four fundamental UML diagrams is created last?
A)Use case diagrams
B)Class diagrams
C)Sequence diagrams
D)Behavioral state diagrams
E)Encapsulation diagram
Q2) What is the relationship between classes,objects,and attributes?
Q3) UML is a truly new methodology and will replace the traditional SDLC.
A)True
B)False
Q4) An object's behavior is implemented by:
A)Actor
B)Class
C)Method
D)Attribute
E)Process
Q5) A behavioral state machine UML diagram is a static model of a single state with one and only one method.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16