PROGRESS REPORT-3

After the analysis phase we have entered in to the design phase of the our project ,e-home, so this report covers the different milestones achieved during the design phase of the project. Last progress report was submitted on 24^th of Oct.

 We have achieved following milestones of this phase (design phase) during the course of project.

         1)                  prototype of all Inputs and outputs

-functional diagram of detail processes and documents

-Different Input screens and  Output Reports

  2)      Design of database and population with test data. 

1) Prototype of all Inputs and Outputs

Functional diagram of detailed processes. :         

            As being a standalone store, this gives idea about all processes, which are being taken place inside the store in relation with product inventory. This includes inflow of product in to the store, outflow of product from the store to the end user, and different queries made by the salesman, technicians, accountant and cashier for particular product in to the inventory database. 

When customer comes to the store the salesman inquires about a particular product with the use of salesman input screen and get the result of status of the product as well as the other information related to the product. 

If sale of  product is taken place then cashier comes into picture to update the database through his input screen.

In the same way when new product enters in to the warehouse then accountant is the key entity responsible for updating the existing database with the inclusion of new product. He also gives unique product id to each and every product. 

Design of input screens and output reports : 

There are four different input screens are available to the four different entities of the store, which are mainly

a)      for salesmen

b)      for accountant

c)      for cashier

d)      for technician

In the same way output reports are generated for accountant and cashier.

There are couples of exceptional report in the case of special inquiries. 

While designing the input screens and output screens few important things are kept in consideration such as color, fonts, error messages,

 2)         Design of Database and populate with test data:

             For designing the database for inventory system of our project e-home, nine tables were created.

These nine tables were created to fulfill the requirements of the customer, salesmen, accountants and cashier by providing the sufficient information.These tables were created based on nine different areas of  product, which are mainly category, subcategory, brand, supplier, payment mode, product status, invoice, damage goods, etc.

We have created relationship between these nine tables through primary key and foreign key, and this relationship was tested with test data.