System Analysis

Topics: Database normalization, Decision support system, Third normal form Pages: 26 (2483 words) Published: June 2, 2014
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 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 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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • System Analysis and Development Sample Essay
  • System Analysis and Design
  • cashiering system Essay
  • Billing System Essay
  • Building Records Appraisal System Essay
  • online grading system Essay
  • Perfume Sales and Inventory System Essay
  • Documentation in Information System Essay

Become a StudyMode Member

Sign Up - It's Free