System Analysis
1 .
Answer any five of the questions below.
What do your understand by normalization. And also explain advantages and
disadvantages of normalizations.
2 . What is meant by "Feasibility Study”? Discuss its importance in system development
3 . Define the term "Data Dictionary". What is the need for a Data Dictionary?
4 . What are various types of maintenance?
5 . Write a short note on any three of the following.
a) Data Flow Diagram
b) Transaction Processing System
c) Role of a system analyst
d) WaterFall Model
e) E.R.Diagram
6 .
List principles of system design. Also, differentiate between Top-down and Bottom-
up design with the help of a suitable example.
7 .
Differentiate between Decision Support System (DSS) and Expert System. Also,
write the main characteristics of both.
8 .
Suppose you are given a relation R= (A, B, C, D, E) with the following functional
Dependencies: {BC! ADE, D! B}.
a. Find all candidate keys.
b. Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF).
c. If the relation is not in BCNF, decompose it until it becomes BCNF. At each
step, identify a new relation, decompose and re-compute the keys and the
normal forms they satisfy.
1 .
Answer any five of the questions below.
What do your understand by normalization. And also explain advantages and
disadvantages of normalizations.
2 . What is meant by "Feasibility Study”? Discuss its importance in system development
3 . Define the term "Data Dictionary". What is the need for a Data Dictionary?
4 . What are various types of maintenance?
5 . Write a short note on any three of the following.
a) Data Flow Diagram
b) Transaction Processing System
c) Role of a system analyst
d) WaterFall Model
e) E.R.Diagram
6 .
List principles of system design. Also, differentiate between Top-down and
Answer any five of the questions below.
What do your understand by normalization. And also explain advantages and
disadvantages of normalizations.
2 . What is meant by "Feasibility Study”? Discuss its importance in system development
3 . Define the term "Data Dictionary". What is the need for a Data Dictionary?
4 . What are various types of maintenance?
5 . Write a short note on any three of the following.
a) Data Flow Diagram
b) Transaction Processing System
c) Role of a system analyst
d) WaterFall Model
e) E.R.Diagram
6 .
List principles of system design. Also, differentiate between Top-down and Bottom-
up design with the help of a suitable example.
7 .
Differentiate between Decision Support System (DSS) and Expert System. Also,
write the main characteristics of both.
8 .
Suppose you are given a relation R= (A, B, C, D, E) with the following functional
Dependencies: {BC! ADE, D! B}.
a. Find all candidate keys.
b. Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF).
c. If the relation is not in BCNF, decompose it until it becomes BCNF. At each
step, identify a new relation, decompose and re-compute the keys and the
normal forms they satisfy.
1 .
Answer any five of the questions below.
What do your understand by normalization. And also explain advantages and
disadvantages of normalizations.
2 . What is meant by "Feasibility Study”? Discuss its importance in system development
3 . Define the term "Data Dictionary". What is the need for a Data Dictionary?
4 . What are various types of maintenance?
5 . Write a short note on any three of the following.
a) Data Flow Diagram
b) Transaction Processing System
c) Role of a system analyst
d) WaterFall Model
e) E.R.Diagram
6 .
List principles of system design. Also, differentiate between Top-down and