Summer Internship-Automated Paint Selection System (Website)

How Started

My summer internship, I was given a task to make a full stack website for automated paint selection system so first of all we prepare UI, database design and data flow diagram for application and learned few technology for front end development & few for back end development which are used in the organisation. Firstly we see company overview and then clear few terminology.

Company Overview

Linde is a leading global industrial gases and engineering company with 2019 sales of $28 billion (€25 billion). Company mission of making the world more productive every day by providing high-quality solutions, technologies, and delivers services which are making the customers more successful and helping to sustain and protect our planet. Linde delivers innovative and sustainable solutions to its customers and creates long-term value for all stakeholders. Linde plants are used in petrochemical industries, refineries, fertilizer industries, gas processing, and pharmaceutical industries.

Few Terminology

What Is Website ?

A website is a collection of web pages and related content that is identified by a common domain name and published on at least one web server.

What Is Front End Technology ?

What we see and interact with as the visitors of a website, or as the end user of a any application, is considered front end technology. It’s code for better user friendly experience and enhanced web application.

What Is Back End Technology ?

What the end user can’t see and which handle the ‘behind-the-scenes’ functionality of web applications. It’s code that connects the web to a database, manages user connections, and powers the web application.


What Is The Purpose ?

Manual selection of painting system involves various risks in project. Which may lead to time delay and huge cost or any typical painting system miss out. In view of this, it is required to develop an approach and understanding to involve right stack holder at right stage to select correct painting system and reduce human error to least possible.

It is time consuming process as well as having inherent risk of erroneous outcome due to having limited competency as well as required more of ordination and consultation from ICP experts for finalization of painting system selection.

Automated Paint system is use for to find equipment’s properties like their temperature of equipment and which color is suitable at their desire temperature. In this project there are many other factor is useful for calculate their result. For the paint system selection which required specific skills and verification of various parameter like corrosivity category, material of construction, operating temperature, insulation, fire proofing, steam out condition etc.

Which Technology Is Used ?

Front End Technology/Language — Hypertext Markup Language(add structure), Cascading Style Sheets(add styling), Java Scripts(makes interactive).

Back End Technology/Language — ASP.NET mvc core, SQL(used for database), Entity(framework for database).

ASP.NET mvc core

The ASP.NET Core mvc framework is a lightweight, open source, highly testable presentation framework optimized for use with ASP.NET Core.

ASP.NET Core mvc provides a patterns-based way to build dynamic websites that enables a clean separation of concerns. It gives you full control over markup, supports friendly development and uses the latest web standards.


SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

Entity Framework

Entity Framework is an open-source framework for .NET applications supported by Microsoft. It enables developers to work with data using objects of domain specific classes without focusing on the underlying database tables and columns where this data is stored. With the Entity Framework, developers can work at a higher level of abstraction when they deal with data, and can create and maintain data-oriented applications with less code compared with traditional applications.


User interface (UI) design is the process designers use to build interfaces in software or computerized devices, focusing on looks or style. Designers aim to create interfaces which users find easy to use and pleasurable. UI design refers to graphical user interfaces and other forms.

User Interface Design


Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.

Database design

Data Flow Diagram

A data flow diagram shows the way information flows through a process or system. It includes data inputs and outputs, data stores, and the various sub processes the data moves through.

Data Flow Diagram


Resultant Paint System can be calculate with other fields like Prime coat, Intermediate coat, Top coat, Total & Max NDFT.

Ral number can be calculated of respective items/equipment.

Master, Ral Master & Notes data can be added, updated and deleted based on user need.

Project wise data are managed.

Activities Done

1. UI design

2. Database design

3. Data flow design

4. Add initial data to database

5. System development

6. Testing

7. Documentation including user guide


Due to privacy policy of company I can’t show demo or any of snapshot of live website but the pages where data is not shown can be display. So I have just displayed the home page of website.

Home Page


Although there are no technical or functional risk associated with Automated Paint System Selection, but user needs to take care of the results which are going to be used because incorrect input may affect Resultant Paint System or Ral number.


It was an great experience during internship I came to know about how to things works in company like agile scrum methodology. I also learn how to work step by step to build any system first create wire frame for designing and create relation schema for database and how to divide work in group.





Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store