DCIT 24 (2nd Quiz) Flashcards
1
Q
it is a set of related components that work together to accomplish defined objectives
A
system
2
Q
it interacts with its environment and performs functions to accomplish objectives
A
system
3
Q
it is like a physical system
A
information system
4
Q
it manipulates data rather than a physical object
A
information system
5
Q
it accepts data from its environment, process data and produces information for decision making
A
information system
6
Q
it provides long-term memory for information systems
A
database
7
Q
it also contains people, procedures, input data, output data, software, and hardware
A
information system
8
Q
it is the traditional life cycle
A
the waterfall model
9
Q
it contains sequential flow in which the result of each phase flows to the next phase
A
waterfall model
10
Q
they produce a problem statement and feasibility study
A
preliminary investigation phase
11
Q
they produce requirements describing processes, data, and environment interactions.
A
systems analysis phase
12
Q
they use diagramming techniques to document processes, data, and environment interactions
A
systems analysis phase
13
Q
they produce a plan to implement the requirements efficiently
A
systems design phase
14
Q
they produce design specifications for processes, data, and environment interaction
A
analysts
15
Q
they produce executable code, databases, and user documentation
A
systems implementation phase
16
Q
they produce corrections, changes, and enhancements to an operating information system
A
maintenance phase
17
Q
it commences when an information system becomes operational
A
maintenance phase
18
Q
it is fundamentally different from other phases because it comprises activities from all the other phases
A
maintenance phase
19
Q
it ends after deploying a replacement system and retiring the current system
A
maintenance phase
20
Q
they perform life cycle phases for subsets of a system
A
spiral development methodologies
21
Q
they progressively produce a larger system until the complete system emerges
A
spiral development methodologies
22
Q
they delay producing design documents until requirements are clear
A
rapid application development methodologies
23
Q
it is the scaled-down versions of a system
A
prototypes
24
Q
it can be implemented rapidly using graphical development tools for generating menus, forms, reports, and other code
A
prototypes
25
it can reduce the risk of developing an information system because it allows earlier and more direct feedback about the system
prototyping
26
they are another variation to traditional information systems development
agile development methodologies
27
they promote active user involvement and team empowerment, viewing software development as an empirical process
agile development methodologies
28
it involves iteration through small incremental releases with testing integrated throughout the project lifecycle
agile development
29
it is a prominent agile development approach
extreme programming
30
it is a subset of agile
scrum
31
it provides a set of concepts and practices for reducing software development overhead and maximizing productive work
scrum
32
it describes the entity types and relationships
data model
33
it describes relationships among processes
process model
34
it can provide input data used by other processes and use the output data of other processes
process
35
it describes relationships between events and processes
environment interaction model
36
it produces an initial version of these models
systems analysis phase
37
it adds more details for the efficient implementation of the models
systems design phase
38
it usually produces the process and environment interaction models after the data model
development processes
39
it produces an operational database for an information system
database development process
40
what are the three schemas?
external, conceptual, and internal
41
these two phases are concerned with the information content of the database
conceptual data modeling and logical database design
42
these two phases are concerned with efficient implementation
distributed database design and physical database design
43
it uses data requirements and produces entity relationship diagrams (ERDs) for the conceptual schema and each external schema
conceptual data modeling
44
it should represent all the requirements and formats
conceptual schema
45
it represents the requirements of a particular usage of the database such as a form or report, rather than all requirements
external schema
46
they are generally much smaller than the conceptual schema
external schema
47
it is a graphical representation that depicts things of interest (entities) and relationships among entities
entity relationship model
48
it provides a unique identification for the entity type
primary key
49
it transforms the conceptual data model into a format understandable by a commercial DBMS
logical database design
50
it is concerned with refining the conceptual data model
logical design phase
51
the logical database design phase consists of two refinement activities, what are they?
conversion and normalization
52
it transforms ERDs into table designs using conversion rules
conversion activity
53
it removes redundancies in a table design using constraints or dependencies among columns
normalization activity
54
it marks a departure from the first two phases
distributed database design
55
it improves the availability of the database but makes updating more difficult because multiple copies must be kept consistent
replication
56
it is concerned with an efficient implementation
physical database design
57
it involves performance at one computer location only
physical database design
58
it is an auxiliary file that can improve performance
index
59
it can improve performance on retrievals but reduce performance on updates
index
60
a designer makes decisions about clustering to locate data close together on a disk
data placement
61
it is a time consuming and labor-intensive process often involving a team of designers
designing large databases
62
it merges the views into a complete and consistent conceptual schema
view integration process
63
it involves recognizing and resolving conflicts
integration
64
it is an important part of conflict resolution in the view integration process
compromise
65
it is performed to produce data, process, and interaction models that are consistent and complete
cross-checking
66
it produces ERDs, table designs, and so on as described in this section
database development process
67
it produces process models, interaction models, and prototypes
applications development process
68
it is a project management model used to outline, design, develop, test, and deploy an information system or software product
system development life cycle or SDLC
69
it defines the necessary steps needed to take a project from the idea or concept stage to the actual deployment and further maintenance
system development life cycle or SDLC
70
it represents a multitude of complex models used in software development
SDLC
71
it is a general methodology that covers different step-by-step processes needed to create a high-quality software product
SDLC
72
how many stages do systems development life cycle has?
seven
73
it is one of the core phases of SDLC
planning
74
it acts as the foundation of the whole SDLC scheme and paves the way for the successful execution of upcoming steps and, ultimately, a successful project launch
planning stage
75
the problem or pain the software targets is clearly defined
planning stage
76
it involves analysis of the resources and costs needed to complete the project, as well as estimating the overall price of the software developed
planning stage
77
it clearly defines the outline of system development
planning stage
78
in this step, you incorporate more specific data for your new system
analysis stage
79
it includes the first system prototype drafts, market research, and an evaluation of competitors
analysis stage
80
it is an essential precursor to development
design stage
81
it is often incorrectly equated with the actual development process but is rather an extensive prototyping stage
design stage
82
they are used for the fast creation of multiple early- stage working prototypes
prototyping tools
83
they ensure that best practices are rigorously adhered to
AI monitoring tools
84
in this stage, the system creation process produces a working solution
development stage
85
this stage includes both front and back-end development
development stage
86
it is often split into different sub- stages
development stage
87
it ensures the application’s features work correctly and coherently and fulfill user objectives and expectations
testing stage
88
it involves detecting the possible bugs, defects, and errors, searching for vulnerabilities, etc., and can sometimes take up even more time compared to the app-building stage
testing stage
89
it uses testing outcomes based on plain language to include non-developers in the process
behavior-driven development
90
a browser testing tool
selenium
91
at this stage, the software undergoes final testing through the training or pre-production environment
integration and implementation stage
92
the software is already being used by end-users
maintenance stage
93
it continuously evaluates performance and uptime and detect errors
automated monitoring tools
94
it can assist developers with ongoing quality assurance
automated monitoring tools
95
automated monitoring tools is also known as?
instrumentation
96
what are the 6 SDLC Methodologies?
waterfall model
iterative model
spiral model
v-model
the big bang model
agile model
97
it implies a linear type of project phase completion
waterfall model
98
each stage has its separate project plan and is strictly related to the previous and next steps of system development
waterfall model
99
it allows for a high degree of structure and clarity
waterfall model
100
it incorporates a series of smaller “waterfalls,” where manageable portions of code are carefully analyzed, tested, and delivered through repeating development cycles
iterative model
101
it is often favored because it is adaptable, and changes are comparatively easier to accommodate
iterative model
102
it best fits large projects where the risk of issues arising is high
spiral model
103
it enables regular incorporation of feedback, which significantly reduces the time and costs required to implement changes
spiral model
104
it requires a rigorous timeline and large amounts of resources
verification and validation methodology
105
it tends to be resource-intensive and inflexible
verification and validation model
106
it is mostly used for creating and delivering a wide range of ideas
the big bang model
107
it perfectly fits the clients who don’t have a clear idea or vision of what their final product should look like
the big bang model
108
it prioritizes collaboration and the implementation of small changes based on regular feedback
agile model
109
it accounts for shifting project requirements, which may become apparent over the course of SDLC
agile model
110
it is a type of time-constrained Agile model
scrum model
111
it is a hybrid of the Agile and Waterfall model
agile-waterfall hybrid
112
they are responsible for authorizing access to the database, coordinating and monitoring its use, and acquiring software and hardware resources as needed
database administrators
113
administrating the primary (database) and secondary (DBMS and related software) is their responsibility
database administrators
114
they are responsible for identifying the data to be stored in the database and for choosing appropriate structures to represent and store this data
database designers
115
they typically interact with each potential group and user and develop a view of the database that meets the data and processing requirements of these groups
database designers
116
they are the people whose jobs require access to the database for querying, updating, and generating reports
end users
117
they occasionally access the database, but they may need different information each time
casual end user
118
they are typically middle-or high-level managers or other occasional browsers
casual end user
119
their main job function revolves around constantly querying and updating the database, using standard types of queries and updates that have been carefully programmed and tested
naive or parametric end user
120
they include engineers, scientists, business analysts, and others who thoroughly familiarize themselves with the facilities of the DBMS so as to implement their applications to meet their complex requirements
sophisticated end user
121
they maintain the personal databases by using ready- made program packages that provide an easy-to-use menu or graphics- based interfaces
stand-alone user
122
they determine the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements
system analysts
123
they describe how a database management system (DBMS) will be integrated with your application
database architecture
124
the database and any application interfacing with the database are kept on a single server or device
1-tier architecture
125
this is generally a fast way to access data
1-tier architecture
126
it consists of multiple clients connecting directly to the database
2-tier architecture
127
it is also known as client-server architecture
2-tier architecture
128
2-tier architecture is also known as?
client-server architecture
129
this architecture used to be more common when a desktop application would connect to a single database hosted on an on-premise database server
2-tier architecture
130
most modern web applications use this architecture
3-tier architecture
131
in this architecture, the clients connect to a back end, which in turn connects to the database
3-tier architecture
