Lab Sheet: Data Manipulation Language (DML) Syntax & Example – Database

Lab Sheet: Database Management System ( DBMS )
Title: Data Manipulation Language ( DML )

Introduction to Data Manipulation Language – MySQL

Data manipulation is

  • The retrieval of information stored in the database
  • The insertion of new information into the database
  • The deletion of information from the database
  • The modification of information stored in the database

A data-manipulation language ( DML ) is a language that enables users to access or manipulate data as organized by the appropriate data model. There are basically two types: (more…)


Image File Types: When to use JPEG, GIF & PNG

Image file formats are standardized means of organizing and storing digital images. Image files are composed of digital data in one of these formats that can be rasterized for use on a computer display or printer. An image file format may store data in uncompressed, compressed, or vector formats. Once rasterized, an image becomes a grid of pixels, each of which has a number of bits to designate its color equal to the color depth of the device displaying it.

Choosing the right file format to save your images in is of vital importance. There are three image formats in constant use on the net — GIF, JPG and PNG. Each is suited to a specific type of image, and matching your image to the correct format should result in a small, fast-loading graphic. Saving and exporting into these formats will require a decent image editor. (more…)


Creating Simple Login Page Template using Bootstrap

Twitter Bootstrap provides an easy and fastest way to create different types of form using its already defined css classes like form-group and form-control. We can use twitter bootstrap forms as per our need and create different types and styles of forms. Bootstrap supports inline form, horizontal form and vertical form.

In this section of our Bootstrap Tutorials we will discuss about designing and creating simple login page template using bootstrap forms. If you are already familiar with html and bootstrap then you can directly understand the design else start learning html and bootstrap basics. You can go through the explanation of the code or simply download the source code and use it in your web project.  (more…)


Building Your First Project in Visual Basic – Math Calculator – Chapter 3 – Visual Basic

Chapter 3

Build your first project on VB6. – Math Calculator

Includes:

  1. Deciding what the application will do and its working
  2. Starting Visual Basic 6
  3. Designing the User Interface
  4. Programming the Math Calculator
  5. Math Operations

Before doing any project you (programmer) have to collect some ideas, and methods how you are going to make that project complete in a short time period with less bugs and thus obtained output is user friendly. There is a model called SDLC (System Development Life Cycle) which describes the concept of programming or software development in a systematic or step by step model. I will try to describe our first project in concept of SDLC. There are somewhat like seven steps in SDLC in detail but you can also make it yourself in your comfort – shorter or lengthen). (more…)


Introduction to Visual Basic – Chapter 2 – Visual Basic

Introduction to Visual Basic 

Includes:

  1. What is Visual Basic?
  2. Structure of Visual Basic Application
  3. The state of Visual Basic Application

 

What is Visual Basic?

Visual Basic is a Visual programming tool that allows you to develop Windows (Graphic User Interface – GUI) and browser based applications.  These applications have a simple user interface and are easier for user to use. (more…)


C Program implementing Lagrange Interpolation Formula (Numerical Computing)

In numerical analysis, Lagrange polynomials are used for polynomial interpolation. For a given set of distinct points Xi and numbers Yi, the Lagrange polynomial is the polynomial of the least degree that at each point Xj assumes the corresponding value Yj (i.e. the functions coincide at each point). The interpolating polynomial of the least degree is unique, however, and it is therefore more appropriate to speak of “the Lagrange form” of that unique polynomial rather than “the Lagrange interpolation polynomial”, since the same polynomial can be arrived at through multiple methods.

The Lagrange interpolating polynomial is the polynomial P(X) of degree <=(n – 1) that passes through the n points (x1, y1 = f(x1)),(x2, y2 = f(x2)) ,.., (xn, yn = f(xn)), , and is given by (more…)


Database Management System (DBMS) – Advantages and Uses

Definition: Database management systems (DBMSs) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

A   database   management   system   (DBMS)   consists   of   a collection of interrelated data and a set of program to access those data. The collection of data, usually referred to as the database, contains information about one particular    enterprise.    The   primary   goal   of   DBMS   is   to provide   an environment that is both convenient and efficient to use in retrieving and storing database information.

Example of database management systems are MS Access, DB2, ORACLE, SQL Server, MySQL, Ingress, Paradox, SYBASE, INFORMIX, etc. (more…)


Database – Data and Information [Need of Database]

What is Database?

Definition: A Database is a repository for collection of related data or facts stored so that it is available to many users for different purposes. The content of database is obtained by combining data from all the different sources in an organization, so that data are available to all users and redundant data can be eliminated or at least minimized. A database contains a collection of related items or facts arranged in a specific structure called Data and Information.

Databases are used in every part of day-to-day life. Examples of common database use include: depositing or withdrawing money from a bank, making a travel reservation, accessing a library catalog, buying something from the internet via a web page, etc. (more…)


Basic Understanding of Java Programming Language

Java programming language was invented for two fundamental reasons:

  • to adapt the changing environments and used and
  • to implement improvements in the art of programming

Firstly it was called OAK and was designed by James Gosling, Patrick Naughton, Chris Warth, Ed Frank and Mike Sheridan at Sun Microsystems in 1991. Java is not the “Internet version of C++”. Java was not designed to replace C++, but to solve a different set of problems. Java is now used to create web pages with dynamic and interactive  content, to develop large-scale enterprise applications, to enhance the functionality of world wide web servers, to provide apps for consumer devices and so on.

Java is purely object-oriented programming language. To understand more about Object Oriented Programming Structures, see our previous article on Object Oriented Programming – Theory and Examples. (more…)


How do we begin to construct Data Flow Diagrams (DFDs)?

A data flow diagram (DFD) is a graphical representation of the “flow” of data through an information system, modeling its process aspects. A DFD is often used as a preliminary step to create an overview of the system, which can later be elaborated.

Data flow diagram is a popular way to visualize the major steps and data involved in software system processes. This is not the same as business process modeling; DFDs were usually used to show data flows in a computer system, although they could in theory be applied to business process modeling. DFDs were useful to document the major data flow or to explore a new high-level design in terms of data flow. (more…)


Bisection Method Algorithm and Flowchart [Numerical Computing]

Illustration of Bisection Method

Illustration of Bisection Method

The bisection method is one of the simplest and most reliable of iterative methods for the solution of nonlinear equations. This method, also known as binary chopping or half-interval method, relies on the fact that if f(x) is real and continuous in the interval a < x < b, and f(a) and f(b) are of opposite signs, that is,

f(a)*f(b) < 0

then there is at least one real root in the interval between a and b. (more…)