A project that I developed for a company I previously worked in Dubai, U.A.E.

Here is a project that I developed for a retail company I used to work in Dubai, U.A.E. The project requires a report to consolidate sales from the different retail shop across U.A.E. and other Gulf Countries. I desgined this application in VB.Net as front-end and SQL Server as back-end. Business Objects Crystal Report Designer was used to design the reports. The application involves a sales report by providing details on Daily Sales, MTD, YTD, and a chart and other summary details. It is very complex though but I was still able to design it. I included in the application some charting reports for business analysis. Some of the screenshot of the project is shown above.

The application was designed using 3-tier or n-tier application design that is separating the presention layer or user interface, business logic and data access layer, and the database management layer.

The Advantages/Disadvantages of N-tier Design

The advantages of N-Tier system design are multifold. The list below shows some of the advantages.

1. You can modify the business logic without making changes to either the user interface or the database.
2. If built correctly, the business logic object can be used by multiple user interfaces
3. Isolates the knowledge required in any given tier to that tier

Some of the disadvantages are;

1. The system design is more complex with increase in the line of codes
2. Memory footprint of the application is increased