Topic

Lecture

Tutorial/Practical

No. of hours

Introduction.

1

-

3

Problem Solving.

1

-

3

Approach.

2

-

6

Identify Sources of Data.
Determine the Data Gathering Tools.
Project Planning..

System Proposal.

1

-

3

Logical DFD of the existing system..
Physical DFD of the existing system.

Deriving data structure from the DFD.

Forms, Reports, and other Documents.

Identifying Data Elements..
Identifying Improvements

2

-

6

Normalization of Existing Tables.

RDBMS and Dimensional Data.
Creating Logical Entity-Relationship Diagram from the Results of Data Structure.
Deriving Physical ERD from the Logical ERD.
Data Dictionary.
Input Design.
Output Design.

2

-

6

Identifying System Architecture from DFD Partitioning.

Identifying Reusable Modules using Structure Chart.
Deriving File Architecture.
Documenting Cross Reference Matrix.
Deployment Plan with Risk Analysis.

1

-

3

Equipment Research.

Determining Need for New Equipment.
Evaluating Equipment.
Bench-marking Techniques.

1

-

3

Software Package Research.

1

-

-

Project Control.

2

-

6