Intranet Human Resource Portal

Intranet Human Resource Portal

Prepared by

01CE101 Nehal Adhikary

01CE102 Anuj Agarwal

01CE008 Rishi Bhilawadikar

Submitted in the partial fulfillment of the requirements of PROJECT II

for the award of

Bachelor of Engineering Degree

in

Computer Engineering

Under the guidance of

Mr. R.K.Shende (Internal Guide)
Mr.Pankaj Sharma (External Guide)

to

UNIVERSITY OF MUMBAI
RAMRAO ADIK INSTITUTE OF TECHNOLOGY, NAVI MUMBAI.

in

May 2005

Chapter 3

Design And Formulation

3.1 Entity – Relationship Diagram

Shown below is the E.R. Diagram for the Intranet HR portal database. The database is normalized to the Boyce - Codd normal form.

[pic]

Fig 3.1.1: ER diagram for the Intranet HR portal database

3.2 Database Design

[pic]

Fig 3.2.1: Table Description

[pic]

Fig: 3.2.2: Table Description (continued)

[pic]

Fig: 3.2.3: Table Description (continued)

[pic]

Fig 3.2.4: Table Description (continued)

[pic]

Fig 3.2.5: Table Description (continued)

3.3 Data Flow Diagrams

The following level 0 and level 1 and level 2 Data flow diagrams clarify the flow of information in the system.

Initial analysis of the system leads to the following context level data flow diagram.

[pic]

Fig 3.3.1 Level 0 DFD

Further analysis led to the following level –1 data flow diagram fragments.

[pic]

Fig 3.3.2: Level 1 DFD fragments

[pic]

Fig 3.3.3 Level 1 DFD fragments

[pic]

____________________________________________________________

____________

Fig 3.3.4: Level 1 DFD

The level 1 DFD can be further refined to the following level 2 DFDs

[pic]

Fig 3.3.5 Level 2 DFD

[pic]

Fig 3.3.6: Level 2 DFD
Chapter 4

Implementation

4.1 Conceptual and Task modeling

The Following Activity