WorksheetsSAD Design Unit-4
Total questions: 25
Worksheet time: 13mins
The primary tool used in structured design is a:
structure chart
data-flow diagram
program flowchart
module
A Relation is a.............
A subset of a cartesian product of a list of attributes
A subset of a cartesian product of a list of domains
A subset of a Cartesian product of a list of tuple
A subset of a Cartesian product of a list of relations
In Prototyping
BASIC is used
COBOL is used
4GLs are used
system is documented
An example of a hierarchical data structure is
Array
Link list
Tree
Ring
A system contains a ___ which is planned to reach a specific goal.
Communication
Structure and behavior
Interdependence
None of the above mentioned
What is the major goal of a System Analysis and Design?
Instructions
Improve organizational systems
Communication
None of the above mentioned
............... are the Process of Logical Database Design
Develop logical data Models for each known user interface
Combine normalized data requirements
Translate the conceptual E-R data model for the application or enterprise
Compare the logical design with the translated E-R model
All of the mentioned above
An important database objective is changing hardware and storage procedures or adding new data without having to rewrite application programs.
True
False
.............. data model defines what the system contains.
Logical data model
Physical data model
Conceptual data model
None
The data model is a conceptual representation of:
Data objects
The Rules
The associations between different data objects
All of the mentioned
Normalization avoids:
Insert anomaly
Update anomaly
Both terms
None of them
In a DFD external entities arerepresented by a
Rectangle
Ellipse
Diamond-shaped box
Circle
DDS stands fort
Data Data Systems
Data Dictionary Systems
Data Digital System
Digital Data Service
Which of the following is used to show the rules that apply to a decision when one or more conditions apply?
system flowchart
Decision table
grid chart
checklist
A context diagram..D. is not used in drawing a detailed DFD
Describes the context of a system.
Is a DFD which gives an overview of the system
Is a detailed description of a system
The first step in the preliminary analysis is toB.
purchase supplies
Hire consultants. .
propose changes
Define the problem
State whether the following statements are True or False.
-Information problems or needs are discussed during the systems design phase of the SDLC.
-The first step of the systems design phase of the SDLC is to select the best alternative.
i-True, ii-False
i-False, ii-True
i-True, ii-True
i-False, ii-False
Defining the interfaces between various programs and designing tests for checking their interfaces is the basic activity involved in …..
systems implementation
preliminary investigation
systems development
systems maintenance
………. approach is generally favored because systems projects are considered as business investments.
Steering committee
User Group Committee
Information Systems Committee
Developer Group Committee
SAD is a systematic procedure to develop or redesign a system.
True
False
The Primary tool used in structure design is a:
Structure chart
Data Flow diagram
Program Flowchart
Module
Which of the following symbols is (are) not the Data Flow Diagram (DFD):
A Square
An open rectangle
A Circle
A triangle
A data element in a record, that uniquely distinguishes the record, from all other records, is called
Response time
Key
System review
Test data
System design aid should primarily
Help in documentation
Help analyze both data and activities
Help in programming
Generate code
Which of the following statements is not true
Entity Relationship Diagrams are used to design files
Systems Overview can be prescribed by Data Flow Diagrams
Phases, in a Systems life cycle, are fixed and invariant.
Indexed files are faster than sequential files in all situations
