HNGU Transcript process for WES

You may find HNGU Transcript WES process pretty backward. No online system is available as of Sept-2020.

Download Transcript format from University website

• Visit https://www.ngu.ac.in/FormsDownload.aspx
• Download Transcript format (PDF and Word file available)

Prepare Transcripts

• Fill detail as mentioned in your mark-sheet as it is.
• Fill Study hours detail of each subject by confirming from your college. (Mostly its 3 hours for the BCA course)
• Print 3 sets of transcripts (each for WES, University, and You)
• Print one WES request form (You get it on the WES site, Mention your WES reference number in it)

Visit College

• Get one set Verified, Stamped, and Signed by Principle of College, Keep the other 2 as it is.
• They may ask you for the original mark sheet to verify marks

Go to HNGU, Patan

• Confirm timing from HNGU by contacting first. (Alternate Saturday is off)
  https://www.ngu.ac.in/Contact.aspx
  
  
• Visit HNGU Admin building here: https://goo.gl/maps/apjLMRPGefBbbfCj7
  
  
• Work starts at 11am onwards
  
  
• Take form for transcript processing request(mention your basic detail like name, course, present home address) [Please fill mobile and address detail correctly, they will call the same number if there is any query, they will send a copy of the transcript on the same address]
  
  
• Go to student help center(Just near admin building)
  
  
• Give 3 sets of transcript(including 1 signed by the college), 1 set of Marksheet(self-attested), 1 transcript request form
  
  
• One person will verify details, suggest changes if any
  
  
• He will tell you how much fee required to pay and tell you to visit the cashier department(near the admin building), 
  Fees as of Sept-2020
• Rs. 600 for Transcript processing
• 2000 for courier charge for WES Canada
• Have to pay through Card(Debit/Credit) if the fees are more than 500
• Take 2 receipts for payment
  
  
• Go to the Student section again and submit 1 copy of payment recepit and all your transcript documents
  
  
• Huff, It's Done (Now pray God. If University find any query in transcript details, you have to all process again)

Document Checklist for HNGU WES process

• 3 Sets of Transcript (1 signed, stamped by College)
• 1 Sets of all mark sheet (they does not ask for original but I suggest you to carry all originals)
• WES Academic request form (fill WES reference number)
• Min Rs. 2600 (should be paid through Card) 

I request all students of HNGU to pray god that HNGU does implement a modern transcript process as followed by GTU where my transcript dispatched within 30hours of online application without visiting college or university. 

Spring Basic Hello World Program

Let's start learning Spring Framework with actual programing instead lengthy theory.

Program Definition

Write a simple Spring Application which will print "Hello World!" or any other message based on the configuration done in Spring Beans Configuration file.

Step-1 Create Maven Project in Eclipse IDE

Create Maven project in Eclipse IDE. 

File > New > Maven Project > Create Simple Project

Provide following details:

Group Id: com.iamlearninghere

Artifact Id: helloworld

Project Name: helloWorld

Click Finish. Now project setup is done

Step-2 Add Spring Library in pom.xml

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.iamlearninghere</groupId>
  <artifactId>helloworld</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>helloworld</name>
  <url>http://maven.apache.org</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <org.springframework-version>4.1.4.RELEASE</org.springframework-version>
  </properties>

  <dependencies>
        <!-- Spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
      
        <!-- Spring ORM -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>

  
        <!-- Test -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.7</version>
            <scope>test</scope>
        </dependency>

    </dependencies>
</project>

This will automatically download all required jar from Maven Repository

Step-3 Do Actual Code For Program

Create HelloMessage.java and modify App.java as below:

HelloMessage.java

package com.iamlearninghere.helloworld;

import org.springframework.beans.factory.DisposableBean;
import org.springframework.beans.factory.InitializingBean;

public class HelloMessage  {

    private String message;

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }
}

App.java

package com.iamlearninghere.helloworld;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

/**
 * Hello world!
 *
 */
public class App {
    public static void main(String[] args) {
      
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("beans.xml");
        HelloMessage helloMessage = (HelloMessage)applicationContext.getBean("helloMessage");
      
        System.out.println("This is message: " + helloMessage.getMessage());
    }
}

• Create Application Context using ClassPathXmlApplicationContaxt, This API load beans.xml configuration file from classpath. It will take care of creating, initializing and destroying beans.

Step-4 Create Bean Configuration File

Create beans.xml file under src folder to define beans(POJO).

beans.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

   <bean id="helloMessage" class="com.iamlearninghere.helloworld.HelloMessage">
       <property name="message" value="Hello World!"/>
   </bean>

</beans>

Step-5 Running Program

Run App.java using Ctrl_F11 and if everything is write, it will print following output

Output:

This is message: Hello World!

Congratulations, you have created your first Spring Application successfully. Hope this helped to start with Spring Framework.

Introduction to Database System

• A database is a collection of related data.
• By data,we mean known facts that can be recorded and that have implicit meaning.
• A database can be of any size and complexity. For example, the list of names and
  addresses referred to earlier may consist of only a few hundred records, each with a
  simple structure.

A database has the following implicit properties:

• A database represents some aspect of the real world, sometimes called the miniworld or the universe of discourse (UoD). Changes to the miniworld are reflected in the database.
• A database is a logically coherent collection of data with some inherent meaning. A random assortment of data cannot correctly be referred to as a database.
• A database is designed, built, and populated with data for a specific purpose. It has an intended group of users and some preconceived applications in which these users are interested.
  

An example of a large commercial database is Amazon.com

It contains data for over 20 million books, CDs, videos, DVDs, games, electronics, apparel, and other items. The database occupies over 2 terabytes (a terabyte is 1012 bytes worth of storage)
and is stored on 200 different computers (called servers). About 15 million visitors
access Amazon.com each day and use the database to make purchases. The
database is continually updated as new books and other items are added to the
inventory and stock quantities are updated as purchases are transacted. About 100
people are responsible for keeping the Amazon database up-to-date.

A database management system (DBMS)

A database management system (DBMS) is a collection of programs that enables
users to create and maintain a database. The DBMS is a general-purpose software system
that facilitates the processes of defining, constructing, manipulating, and sharing
databases among various users and applications.

• Defining a database involves specifying
  the data types, structures, and constraints of the data to be stored in the database.
• Constructing the database is the process of storing the data on some storage medium that is controlled
  by the DBMS.
• Manipulating a database includes functions such as querying
  the database to retrieve specific data, updating the database to reflect changes in the
  miniworld, and generating reports from the data.
• Sharing a database allows multiple users and programs to access the database simultaneously.

Other important functions provided by the DBMS include protecting the database
and maintaining it over a long period of time. Protection includes system protection
against hardware or software malfunction (or crashes) and security protection
against unauthorized or malicious access. A typical large database may have a life
cycle of many years, so the DBMS must be able to maintain the database system by
allowing the system to evolve as requirements change over time.
we will call the database and DBMS software together a database system.