Three other milestones were achieved since last report was submitted,

These are:

·        Design of data model

·        Design of process model

·        Feasibility Analysis of project alternatives.

 

 

Design of data model :

 

            This model documents the data that must be captured  and stored by a system, independently of showing how that data is or will be used , that is independently of inputs, outputs, and processing. Its graphical representation of data entities.

Three data models were designed :

-Context level data model

-Key based data model

-Non key based data model.

 

Main entities in our data model are customer, order, purchasing department and inventory products.   This also shows the number of correspondence, each entity has with the other entity or entities.

 

Key based data model shows the primary key and foreign key associated with each entity.

 

Non key based data model mainly emphasis on non key based attributes which are associated with each entity. Its representation is crucial in the phase of database design.

Its nothing but descriptive properties of the entity  like each order can be differentiated with other order in terms of order date, order cost, order quantity, etc.

 

Design of process model :

 

Here the technique for organizing and documenting the structure and flow of data through system’s processes  has been illustrated with use of  three different process model,

Mainly :

            -Context level process model

-Level 1 decomposition of process model

            -Level 2 decomposition of process model

 

main processes related to inventory database are product query for availability of the product, database updating at the time of sales of the product, and updating database at the time of purchase of the product as inventory is replenished.

 

A complex system is usually too difficult to fully understand when viewed as a whole, not so much in our case as the number of processes involved in the system are less ,but though it’s always  more comprehensive to decompose the processes.

 

Our level one decomposition shows the component subsystems such as account subsystem, checkout subsystem, sales subsystem, etc.

 

Second level decomposition further decomposes the subsystems into sub processes.

 

The last set of diagram in this series is Event diagram , the main emphasis is on the data repository ,the change agents of it, and input and output associated with each repository.

 

It shows all three data entities , processes and data repository. In out case the main repository is the inventory database which is central to the system.

 

Feasibility Analysis:

 

It is the measure of how beneficial or practical the development of an system will be to an organization,  we have mainly two system alternatives on hand,

First is the MS Access based database server to manage the inventory database ,and second alternative is the Oracle based database server.

We used mainly three type of feasibility,

            -Operational feasibility

            -Economic feasibility

            -Technical feasibility

In economic feasibility mainly two parameters were compared ,one is Payback period and other is Net present value of the system.

Payback period for the first alternative is found to be 3 years, and that for the other alternative is more than 3 years,

All three feasibility criteria were assigned their own weights like for Operational feasibility it’s 30% ,for economic feasibility 30% and for technical feasibility was assigned the 40% of weight.

 

Based on the ranking received by both alternatives on various criteria ,MS Access based database server is decided to be implemented for the system.

 
go to top