CIVIL lAB MANUAL FROM CIT

CIVIL ENGINEERING LAB MANUAL

LAB MANUAL IV SEM

• Strength of Materials Lab
• Hydraulic Engineering
• surveying-II lab manual

LAB MANUAL VI SEM

• Environmental Engineering Laboratory
• • Environmental and Irrigation Engineering Drawing

Revised GRE Books!!!

 Revised GRE Books!!!

GRUBER 2012 [REVISED GRE]

Code:

www.mediafire.com/?ttz0​asvecyvqqr5 

Manhatten GRE for TC AND SE [REVISED GRE]

Code:

www.mediafire.com/?3dnc​l7zuc13lnpc

Manhatten GRE for RC [REVISED GRE]

Code:

www.mediafire.com/?44a1​idji822ku78

BARRON's 19th EDITION [CD] [ISO]

Code:

www.mediafire.com/?3dnc​l7zuc13lnpc

GATE - 2012 Question Papers & Answer Keys

GATE - 2012 Question Papers & Answer Keys

ACE Engg Academy

Branch	GATE 2012 Key	GATE 2012 Question Paper
EC	EC Key	EC Set C Question Paper
EE	EE Key	EE Set B Question Paper
CS	CS Key	CS Set C Question Paper
CE	CE Key	CE Question Paper
ME	ME Key	ME Set A Question Paper
PI	PI Key	PI Question Paper
IN	IN Key	IN Question Paper

Gate Forum
GATE 2012 Answer Keys and Solutions

EC

CS

ME

EE

IN

CE

BT

CH

MySQL by Examples

-- Database-Level

DROP DATABASE databaseName                 -- Delete the database (irrecoverable!)

DROP DATABASE IF EXISTS databaseName       -- Delete if it exists

CREATE DATABASE databaseName               -- Create a new database

CREATE DATABASE IF NOT EXISTS databaseName -- Create only if it does not exists

SHOW DATABASES                             -- Show all the databases in this server

USE databaseName                           -- Set the default (current) database

SELECT DATABASE()                          -- Show the default database

SHOW CREATE DATABASE databaseName          -- Show the CREATE DATABASE statement

-- Table-Level

DROP TABLE [IF EXISTS] tableName, ...

CREATE TABLE [IF NOT EXISTS] tableName (

   columnName columnType columnAttribute, ...

   PRIMARY KEY(columnName),

   FOREIGN KEY (columnNmae) REFERENCES tableName (columnNmae)

)

SHOW TABLES                -- Show all the tables in the default database

DESCRIBE|DESC tableName    -- Describe the details for a table

ALTER TABLE tableName ...  -- Modify a table, e.g., ADD COLUMN and DROP COLUMN

ALTER TABLE tableName ADD columnDefinition

ALTER TABLE tableName DROP columnName

ALTER TABLE tableName ADD FOREIGN KEY (columnNmae) REFERENCES tableName (columnNmae)

ALTER TABLE tableName DROP FOREIGN KEY constraintName

SHOW CREATE TABLE tableName        -- Show the CREATE TABLE statement for this tableName

-- Row-Level

INSERT INTO tableName

   VALUES (column1Value, column2Value,...)               -- Insert on all Columns

INSERT INTO tableName

   VALUES (column1Value, column2Value,...), ...          -- Insert multiple rows

INSERT INTO tableName (column1Name, ..., columnNName)

   VALUES (column1Value, ..., columnNValue)              -- Insert on selected Columns

DELETE FROM tableName WHERE criteria

UPDATE tableName SET columnName = expr, ... WHERE criteria

SELECT * | column1Name AS alias1, ..., columnNName AS aliasN

   FROM tableName

   WHERE criteria

   GROUP BY columnName

   ORDER BY columnName ASC|DESC, ...

   HAVING groupConstraints

   LIMIT count | offset count

-- Others 

Java programming: 
Java program code consists of instructions which will be executed on your computer system to perform a task as an example say arrange given integers in ascending order. This page contains examples for beginners to understand how to use java programming to write simple Java programs. These codes demonstrate how to get input from user, working with loops, strings and arrays. Programs are provided with output (image file) and you can also download class file and execute it directly without compiling the source file.

Compiling and executing java programs

Java programming software: To compile and run Java program code you need to download JDK (Java Development Kit).
To compile type: javac file_name.java where file_name is name of file containing java source code.
Javac is the Java compiler which converts java code into bytecode.
To run type: java main_method_class where main_method_class is the name of class which defines main method.

Learn Java through books

If you are just starting to learn Java then it is recommended to buy Java programming book. A Java book will help you to easy learn basic concepts and will act as a reference for all time.

Java programming examples

Example 1: Display message on computer screen.

class First {
  public static void main(String[] arguments) {
    System.out.println("Let's do something using Java technology.");
  }
}

This is similar to hello world java program. Download java programming class file.
Output of program:

Example 2: Print integers

class Integers {
  public static void main(String[] arguments) {
    int c; //declaring a variable
 
  /* Using for loop to repeat instruction execution */
 
    for (c = 1; c <= 10; c++) {
      System.out.println(c);
    }
  }
}

Output:

If else control instructions:

class Condition {
  public static void main(String[] args) {
    boolean learning = true;
 
    if (learning) {
      System.out.println("Java programmer");
    }
    else {
      System.out.println("What are you doing here?");
    }
  }
}

Output:

Command line arguments:

class Arguments {
  public static void main(String[] args) {
    for (String t: args) {
      System.out.println(t);
    }
  }
}

Aim:- C program which draws a pie chart showing percentage of various components drawn with different filling styles and colors.

C programming code

/* Program to draw a pie chart */

#include<graphics.h>
#include<conio.h>
 
int main()
{
   int gd = DETECT, gm, midx, midy;
 
   initgraph(&gd, &gm, "C:\\TC\\BGI");
 
   setcolor(MAGENTA);
   rectangle(0,40,639,450);
   settextstyle(SANS_SERIF_FONT,HORIZ_DIR,2);
   setcolor(WHITE);
   outtextxy(275,10,"Pie Chart");
 
   midx = getmaxx()/2;
   midy = getmaxy()/2;
 
   setfillstyle(LINE_FILL,BLUE);
   pieslice(midx, midy, 0, 75, 100);
   outtextxy(midx+100, midy - 75, "20.83%");
 
   setfillstyle(XHATCH_FILL,RED);
   pieslice(midx, midy, 75, 225, 100);
   outtextxy(midx-175, midy - 75, "41.67%");
 
   setfillstyle(WIDE_DOT_FILL,GREEN);
   pieslice(midx, midy, 225, 360, 100);
   outtextxy(midx+75, midy + 75, "37.50%");
 
   getch();
   return 0;
}

C graphics examples

1. Drawing concentric circles

#include <graphics.h>
 
int main()
{ 
   int gd = DETECT, gm;
   int x = 320, y = 240, radius;
 
   initgraph(&gd, &gm, "C:\\TC\\BGI");
 
   for ( radius = 25; radius <= 125 ; radius = radius + 20)
      circle(x, y, radius);
 
   getch();
   closegraph();
   return 0;
}

2. C graphics program moving car

#include <graphics.h>
#include <dos.h>
 
int main()
{
   int i, j = 0, gd = DETECT, gm;
 
   initgraph(&gd,&gm,"C:\\TC\\BGI");
 
   settextstyle(DEFAULT_FONT,HORIZ_DIR,2);
   outtextxy(25,240,"Press any key to view the moving car");
 
   getch();
 
   for( i = 0 ; i <= 420 ; i = i + 10, j++ )
   {
      rectangle(50+i,275,150+i,400);
      rectangle(150+i,350,200+i,400);
      circle(75+i,410,10);
      circle(175+i,410,10);
      setcolor(j);
      delay(100);
 
      if( i == 420 )
         break;
      if ( j == 15 )
         j = 2;
 
      cleardevice(); // clear screen
   }
 
   getch();
   closegraph();
   return 0;
}

Animation Graphics in Windows 7

Most of the functions are two dimensional except bar3d which draws a 3d bar, you can also implement these functions using already existing algorithms. You can also use these functions in C++ programs. You can use these functions for developing programs in Windows 7 and Vista using Dev C++ compiler. For that you need to download an additional package WinBGIm, download WinBGIm. Now open Dev C++ compiler go to tools->Package Manager, use install button and then browse the package location. Now create new project and select WinBGIm. This library also offers many functions which can be used for image manipulation, you can open image files, create bitmaps and print images, RGB colors and mouse handling.

Civil Engineering Web Directory: General/Engineering History/Pyramids

Civil Engineering Web Directory: General/Engineering History/Pyramids

Learn how to build the Pyramids? The following websites are all you needed!

Mr. Pitonyak's Pyramid Puzzle
Contains vital information, recourses and some other stuffs related to pyramid.

The Egyptian Pyramid
Answer to the FAQ to the Egyptian Pyramid by the Smithsonian Institution.

The Pyramids: Design and Construction
Introduction of how the pyramids were built, and the evolution in design from the step pyramid to the true pyramid.