Monday, 17 October 2016

HTML an Introduction

HTML (Hypertext Markup Language) is used to make website around the globe. HTML is easy to learn and supported by the entire browser around the world.

Let’s start with some world of full form. Why “Markup language “has been used in full form?
The Name of markup language has been used because all the HTML code is written inside of <>.

Syntax and Example

<Body bgcolor=”red”>
…………………
………………….
</Body>
HTML Tag Information

Saturday, 15 October 2016

Algorithm

Computer Algorithm


Algorithm : Computer Science 

To understand algorithm you need to understand following terms
  • Computer is a combination of software and hardware.
  • Hardware is physical component of system which we can touch and feel.
  • Software is a collection of related program.
  • Program is a combination of related statement.
  • Statements are actual command which computer follows to perform an action.

Friday, 14 October 2016

Write a program to find smallest and highest number from an array?

Q1. : Write a program to find smallest and highest number from an array?

/*    ##################################
            Girfa : Student Help
            Program : Count Highest/smallest
            For more program visit : http://girfahelp.blogspot.in/2012/09/some-program-of-c-language.html
      ###################################
      */
#include<stdio.h>
#include<conio.h>
void main()
{
      int ar[5],i,small=0,big=0;
      clrscr();
      for(i=0;i<5;i++)

Flow Chart



Flow Chart

 Flow chart a diagram is use to graphically represent program logic, algorithm and workflow model because A picture is worth a thousand words. Flow chart is easy way to write down programming logic using various symbols which help programming easily convert these symbols of logic into its equivalent code in any language. Flow chart decreases software development process.


The first structured method for document process flow, the "flow process chart", was introduced by Frank and Lillian Gilbreth to members of the American Society of Mechanical Engineers (ASME) in 1921 in the presentation "Process Charts: First Steps in Finding the One Best Way to do Work". The Gilbreths' tools quickly found their way into industrial engineering curricula. In the early 1930s, an industrial engineer, Allan H. Mogensen began training business people in the use of some of the tools of industrial engineering at his Work Simplification Conferences in Lake Placid, New York.

Practice Question Data and Variable C language

Q1. What is difference between sign and unsigned data type in C language?

 Q2. What is difference between float and double data type?

 Q3. What do you understand by garbage data?

 Q4. If a variable is used in any expression without initialization then what will be result?

 Q5. What the use of scientific notation?

Thursday, 13 October 2016

Microsoft Excel Rate Depreciation List for Car Sale

Prepare a worksheet for the following problem:

You are looking to buy a car. You are considering two options: to buy a second hand car and keep it for ten years or to buy a new car and keep it for four years. The depreciation per year is simply the difference between the purchase price and the resale price divided by the numbers of years. The total running cost per year is the sum of service/repair cost, the fuel cost per year (miles per year multiplied by fuel cost per mile) , the tax and the insurance. The total cost per year is the sum of the depreciation and the running costs. You are supposed to calculate average depreciation per year, fuel cost per year, total running cost per year and total cost per year for both the options. Type in labels: car purchase option, initial cost, resale, years ,average depreciation per year, running cost, services/repairs per year, miles per year, fuel cost per mile, fuel cost per year, tax, insurance, total running cost and total cost per year. Prepare the worksheet having all the details as given below:

Wednesday, 12 October 2016

July, 2015 A8-R4: BASICS OF OS, UNIX & SHELL PROGRAMMING

July, 2015
A8-R4: BASICS OF OS, UNIX & SHELL PROGRAMMING

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 The fast and expensive storage device
A) Register
B) Electronic disk
C) Magnetic disk
D) Optical disk
1.2 Which command is used to change protection mode of files starting with the string emp and
ending with 1,2, or 3?
A) chmod u+x emp[1-3]
B) chmod 777 emp*
C) chmod u+r ??? emp
D) chmod 222 emp?

Variable Input Output C Language

c-language-variable-input-o

As you have in previous chapter what is a variable now I am going to demonstrate that how to declare and read/write into a variable.
Declaration syntax

Declare single variable

Data_type Variable_name;

Declare more than one variable

Data_type Var_name1,var_name2…var_nameN

Declare and initialize

Data_type var_name1=val1,var_name2=val2…var_nameN=valM

Variable Declaration

When you make a variable. It’s known as declaration in terms of C language. Declaration request OS for claiming space on physical memory.

Initialization

First value assign to a variable after declaration. What if you didn’t initialize a variable then an unpredicted value assigned which is known as garbage so initialization   is mandatory for denied facing socking result.

Monday, 10 October 2016

January, 2016 A8-R4: BASICS OF OS, UNIX & SHELL PROGRAMMING

January, 2016
A8-R4: BASICS OF OS, UNIX & SHELL PROGRAMMING

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 What does the following command do?
who | wc –l
A) List the number of users logged in
B) List the users
C) List the number of users in the system
D) Display the content of who command
1.2 What is the default number of files open per user process?
A) 0
B) 1
C) 2
D) 3
1.3 $ oneko &

Sunday, 9 October 2016

NIELIT Assignment 12 : Basics of Os, Unix and Shell Programming

Assignment 12

a) Write a command to change modification time of a file without modifying the
file.

b) Write a command to display name of a file in your current directory whose
size is maximum.

NIELIT Assignment 11 : Basics of Os, Unix and Shell Programming

Assignment 11.

a) Write a command to convert contents of a file a.txt to upper case

b) Write sequence of commands to convert 1st line of a file a.txt to upper case

NIELIT Assignment 10 : Basics of Os, Unix and Shell Programming

Assignment 10.

Using vi editor

a) Write a command to undo last action.

b) Write a command to create abbreviation LU as Linux Unix.

NIELIT Assignment 10 : Basics of Os, Unix and Shell Programming

Assignment 10.

Using vi editor

a) Write a command to undo last action.

b) Write a command to create abbreviation LU as Linux Unix.

NIELIT Assignment 9 : Basics of Os, Unix and Shell Programming

Assignment 9.

Using vi editor
a) Write a command to copy line number 1,10 after line number 25.

b) Write a command to move line number 1,10 after line number 25.

NIELIT Assignment 8 : Basics of Os, Unix and Shell Programming

Assignment 8.

Using vi editor write commands to do the following
a) Combine five lines into a single line.

b) Search a pattern printf and then repeat the search in opposite direction.

NIELIT Assignment 7 : Basics of Os, Unix and Shell Programming

Assignment 7.

a) Use chmod –w . and then try to create and remove a file in the current
directory. What is its output.

b) Run the commands (i) ls –ld . and (ii) ls –l .. Explain its output.

NIELIT Assignment 6 : Basics of Os, Unix and Shell Programming

Assignment 6.

a) Write a command to compare two text files.

b) Write a command to copy a file with permission 444.Copy it again and explain
your observation.

NIELIT Assignment 5 : Basics of Os, Unix and Shell Programming

Assignment 5.

a) How does the command mv bar1 bar2 behave , where both bar1 and bar2 are directories, when (i) bar2 exists and (ii)bar2 does not exist

b) Write a command to display lines common to a.txt and b.txt?

c) Write a command to display lines unique to a.txt?

NIELIT Assignment 4 : Basics of Os, Unix and Shell Programming


Assignment 4.

a) Run the following command and explain its output
(i) cd ../.. (ii)mkdir ../bin (iii)rmdir .. (iv)ls ..

b) Write a command to remove entire directory structure
DOEACC/ALEVEL/AL55 in one command?

NIELIT Assignment 3 : Basics of Os, Unix and Shell Programming

Assignment 3.

a) Convert the decimal number 192 to octal and hexadecimal using bc command.

b) Run ps , the script command and run ps again . What is its output. Explain

NIELIT Assignment 2 : Basics of Os, Unix and Shell Programming

Assignment 2.

a) Explore the filesystem tree using cd, ls, pwd and cat. Look in /bin, /usr/bin, /sbin, /tmp and /boot. What do you see?.

b) Explore /dev. Can you identify what devices are available? Which are character-oriented and which are block-oriented? Can you identify your tty (terminal) device (typing who am i might help); who is the owner of your tty

NIELIT Assignment 1: Basics of Os, Unix and Shell Programming

Assignment 1.

Try the following command sequence and write its output:
cd ; pwd ;ls -al ; cd . ;pwd (where did that get you?) ; cd .. ;pwd ; ls -al ; cd .. ; pwd;ls -al ;cd

UGC Net Computer Science Paper 3 July-16 Page 5

41. Which of the following statements is not correct ?
(1) HTML is not screen precise formatting language.
(2) HTML does not specify a logic.
(3) DHTML is used for developing highly interactive web pages.
(4) HTML is a programming language.

Answer D
Expiation : No, HTML is not a programming language. The "M" stands for "Markup". Generally, a programming language allows you to describe some sort of process of doing something, whereas HTML is a way of adding context and structure to text.

42. When one object reference variable is assigned to another object reference variable then
(1) a copy of the object is created.
(2) a copy of the reference is created.
(3) a copy of the reference is not created.
(4) it is illegal to assign one object reference variable to another object reference
variable.

Answer : B
Explanation : A reference variable in C++ is an alternate name/alias of a variable/object, which must be initialized at the declaration time. One a reference variable has been assign an object address then it became an alias of that object so any change from reference variable will affect original object data. So we can say that a reference variable is a copy of refer variable/object.

class test
{
     int i;
     public:
     test()
     {
          i=0;
     }
     void change()
     {
          i++;
     }
     void print()
     {
          cout<<endl<<i;
     }
};
void main()
{
     test ob1;
     test &ob2=ob1;
     ob1.change();
     ob2.print();
     ob1.change();
     ob2.print();

}

Introduction of Variable in C Language

Variable in any programming language when we start programming then first thing which we start with is variable. This chapter will give full knowledge of variable’s operation .So let’s start learning process with constant.

Constant

A constant is a value that newer get change. Like value of g (gravitational force) is 9.8, value of PI is 3.14 or your date of birth. Examples of different type of constant are follows

Integer


Integer is numbers that exclude decimal part. For Example if I ask to you that how many siblings you have. Your reply will always be in integer without decimal part.
123,123.45,5

Saturday, 8 October 2016

Inquiry Report

Inquiry Report


Rule

  • Positive response less than negative
  • Negative less than positive

Friday, 7 October 2016

C Language Data Type

A block diagram can represent a system working model .Here I am going to show you block diagram of computer which is also  follows by many types of machines.
Block diagram of computer

Thursday, 6 October 2016

Features of C Language

C Language Feature

Modular

C language is also known as building block of function because everything you have do in C with the help of functions. That is why C language uses modular approach to solve huge problem through small modular approach. Modules make our work easy to solve any type of programming problem in a simple way. example of modules are function. A function is a collection of statements which design for some specific task.

Recursion

When a function called by itself known as recursion. Recursion helps to solve a complicated task in a few line of code which decrease compile time and increases software performance.

A8-R4 : BASICS OF OS, UNIX AND SHELL PROGRAMMING Syllabus

Objective of the Course


The objective of the course is to make students aware of the functioning of a multi-user operating
system. This course will serve as a foundation course for the higher level course in Unix. The
students are expected to learn the commands while doing practical and emphasis should be
given to those switches/options and flags, which are most frequently used in real life.

After completion of the course students will be able to:

   • Understand Operating System concepts.
   • Use System calls and memory management.
   • Use Unix commands and editors.
   • Carry out Unix File management and shell programming in Unix.
   • Do Network configuration and security management in Unix.

Wednesday, 5 October 2016

Save Image In Access and Retrieve in Datagridview Using VB.net

This small project will help you to understand how can you handle image processing in your VB.net Window Application. There are many times when we want to save images in our project software for instance  in school software Saving student image. So you can achieved this through following approach

  1. Saving Image into database
  2. Saving image into a folder
First approach is not so much popular because image get more size than normal data  So your database saved thousands of byte for an image which lead decline in record retrieval. if you want to follow this approach click on Following Link

Save Image into MS Access  database

This post deal with second approach because its good practice to save information into database and image in a folder . you can save image name into database or rename uploaded image as your table  ID (PK) field value. I am saving image name into database which is easy to implement but renaming image is more suitable because its decrease  database storage.

Screen Shot

Add Image
Image Add Screen

Dennis Ritchie Computer Scientist


Dennis  Ritchie Computer Scientist



Dennis was an American computer scientist. He created the C programming language and, his colleague Ken Thompson, the Unix operating system. Ritchie and Thompson received the Turing Award from the ACM in 1983, the Hamming Medal from the IEEE in 1990 and the National Medal of Technology from President Clinton in 1999. Ritchie was the head of Lucent Technologies System

Martin Richards (computer scientist)

Martin Richards

Martin Richards (born 21 July 1940) is a British computer scientist known for his development of the BCPL programming language which is both part of early research into portable software, and the ancestor of the B programming language invented by Ken Thompson in early versions of Unix and which Dennis Ritchie in turn used as the basis of his widely used C programming language.

History of C Language

Timescale of C language History

History of C Language

1966

BCPL (Basic Combined Programming Language) is a procedural, imperative, and structured computer programming language designed by MartinRichards of the University of Cambridge in 1966.This language for invented to design compiler for other languages. Later on BCPL became B Language. Some people say BCPL means before C language.

Monday, 3 October 2016

C Language Introdunction

C language is general purpose computer programming language. It is in category of high level language with low level facility which enables you to direct access of your computer hardware. C language is also known as building block of function because all the programming task is implemented through function whether it is user defined or built in any library function. Mainly C language is used for system programming from the time of it had been invented.

C Language Introdunction

C language is general purpose computer programming language. It is in category of high level language with low level facility which enables you to direct access of your computer hardware. C language is also known as building block of function because all the programming task is implemented through function whether it is user defined or built in any library function. Mainly C language is used for system programming from the time of it had been invented.

C Language Introdunction

C language is general purpose computer programming language support structure approach of programming. It is in the category of high level programming language with low level feature which enables you to direct access of your computer hardware. C language is also known as building block of function because all the programming task is implemented through function whether it is user defined or built in any library function. Mainly C language is used for system programming from the time of it had been invented.

Sunday, 2 October 2016

July, 2010 A7-R4: INTRODUCTION TO DBMS

 July, 2010
A7-R4: INTRODUCTION TO DBMS

PART ONE
(Answer all the questions)
1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 Description of data stored in database is called
A) Schema
B) Meta Data
C) Information
D) None of the above
1.2 When one transaction updates a database item and then transaction fails for some reason.
The updated item is accessed by another transaction before it is changed back to its original
value is a
A) Lost update
B) Temporary update
C) Incorrect summary
D) None of the above

January, 2011 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

January, 2011
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Given the relation schema:
EMPLOYEE(EMP_NUM,EMP_NAME, JOB_CODE)
JOB(JOB_CODE, JOB_DESCRIPTION)
What is the cardinality of relationship between entities EMPLOYEE and JOB?
A) One to One
B) One to Many
C) Many to One
D) Many to Many
1.2 Given the relation schema R(A,B,C,D)and functional dependencies C-->B and AB-->C,D.
What is the highest normal form of Relation R?
A) 2NF
B) 3NF
C) BCNF
D) 1NF

July, 2011 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

July, 2011
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 A view is a
A) Base table
B) Derived table
C) Named derived table
D) None of the above
1.2 System failures are also known as
A) Soft crashes
B) Media crashes
C) Hard crashes
D) System failures are non-existent

January, 2012 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

January, 2012
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM


PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 Which one of the following is not an example of 1:N relationship?
A) Faculty-belongsto-Department
B) BANK-has-Branches
C) University-has-Vicechancellor
D) None of the above
1.2 Consider the relation R(ABCDE) with following functional dependencies:
AB ® C, CD ® E, DE ® B
The key of the relation is
A) AC
B) AB
C) ABD
D) A

July, 2012 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

July, 2012
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS


PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 The language used application programs to request data from the DBMS is referred to as
A) DML
B) DDL
C) Query Language
D) All of the above
1.2 When two transactions run concurrently types of problems encounter are
A) Data delete Problem, Dirty read problem, Incorrect summary problem
B) Lost update problem, Dirty read problem, Incorrect summary problem
C) Lost update problem, Data delete Problem, Incorrect summary problem
D) Lost update problem, Dirty read problem, Data delete Problem

Saturday, 1 October 2016

Artistic Website Full Source Code Free Download

Banner Artistic  Website

Artistic Website Full Source Code Free Download


If you are art lover then this website is best for you. Virtual it seems that you are working on letter pad.Because a true letter pad is used as main background image for all the pages. If you want to make a website with a traditional graphic like letter then this template is for you.

Feature

  • Letter pad background
  •  Article look
  • Light weight

Friday, 30 September 2016

July, 2012 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

July, 2012
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 The language used application programs to request data from the DBMS is referred to as
A) DML
B) DDL
C) Query Language
D) All of the above
1.2 When two transactions run concurrently types of problems encounter are
A) Data delete Problem, Dirty read problem, Incorrect summary problem
B) Lost update problem, Dirty read problem, Incorrect summary problem
C) Lost update problem, Data delete Problem, Incorrect summary problem
D) Lost update problem, Dirty read problem, Data delete Problem

Thursday, 29 September 2016

PHP Hardware Institute Website Free Download

hardware institutte website

Girfa Hardware Institute is a website that Is suitable for all types institution or university or any educational body who running hardware courses. You can launch your business globally on web with a professional way. Content of this website is highly standardized by the expert. A comprehensive syllabus material has been added which will help you to design your course material. Online certificate verification enhances your working standard. So I am representing a tangible solution to you if you want to make such type of website.

Feature

  • All necessary content based of live project
  • PDF syllabus
  • Online Certificate Verification
  • Digital certificate download facility

Monday, 26 September 2016

January, 2013 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS (DBMS)

January, 2013
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS (DBMS)

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 A database user manually notes that “The file contains two hundred records, each record
containing nine fields”. Translating this statement in database terminology means
A) 200 attributes and 9 rows
B) 200 rows 9 tuples
C) 200 tuples and 9 attributes
D) 200 attributes and 9 tuples
1.2 Given the following relation schemas
EMPLOYEE (EMP_CODE, EMP_NAME, JOB_CODE)
PLAN (PLAN_CODE,PLAN_DESCRIPTION)
BENEFIT(EMP_CODE,PLAN_CODE)
Attribute PLAN_CODE in relation BENEFIT is
A) Primary Key
B) Foreign Key
C) Candidate Key
D) Alternate Key

July, 2013 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

July, 2013
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 A view is a
A) Base table
B) Derived table
C) Named Derived table
D) Soft table
1.2 Which of the following do you need to consider when you make a table in SQL?
A) Data types
B) Primary Keys
C) Default Keys
D) All of the above

January, 2014
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which of the following schemas defined the stored data structures in terms of the database
model used?
A) External
B) Conceptual
C) Internal
D) None of the above
1.2 Object oriented data models are used to
A) specify overall structure of the database
B) describe data and its relationships.
C) higher level description of storage structure and access mechanism.
D) all of the above

July, 2014
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 In DBMS the structure of a data file is stored separately from the access program. This
feature allows us to enforce
A) Program-Operation Independence
B) Program-data Independence
C) Physical Data Independence
D) Logical Data Independence
1.2 In DBMS Protection includes
A) System Protection against software/hardware malfunction
B) Security against unauthorized access
C) both A) and B)
D) None of the above

January, 2015 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

January, 2015
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 The separation of the data definition from the program is known as
A) Data dictionary
B) Data independence
C) Data integrity
D) Referential integrity
1.2 The data dictionary of a DBMS is called.
A) DBMS directory
B) DBMS Catalog
C) System Catalog
D) All of the above

PHP Consultancy Website Template Free Download

php Consultancy website free Template

Girfa Consultancy is a template is lightweight responsive website. Design of this site is based on current trend and you can modified is easily as your project requirement. I have made this for consultancy but it is global template that can be used in any type field. So download it do whatever you want to do.

Feature

  • Processional Design
  • Responsive website
  • Light weight
  • Dynamic
  • Content scrolling and Animation

Sunday, 25 September 2016

Download Free PHP FMCG Website Full Source Code

FMCG

FMCG Banner

Fast Moving consumer goods are a type of business worldwide which cover broad range market and consumer. We used any product of belongs to FMCG within every hour of our daily life. Any type of person investing small amount of money can start their own FMCG Business. Most of startup start FMCG business and try to promote their business so they can cover huge amount of people for achieve this some business person need a website. So I am providing A FMCG website with full source code. So if you want make any FMCG business or project then this site is your one click solution.

Saturday, 24 September 2016

PHP Online Test Website

PHP Online Test Website Website

PHP online test is website written in PHP as server side language, MySQL as back end database. This website has 10 set of test. Each exam consist 50 mcq type question.  A timer will start when exam start , there is not any specific time for test. On the Result page summary of test displayed.

Feature

  • 10 Set of Exam
  • MCQ type question
  • Timer
  • Instant Result

July, 2015 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

July, 2015
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which of the following is NOT a basic element of the E-R model?
A) Entities
B) Attributes
C) Relationship
D) Primary keys
1.2 The result of the operation RUS includes all tuples that are
A) Either in R or S
B) Both in R and S
C) Both A) and B)
D) None of the above

Friday, 23 September 2016

Smart Phone Impact

Smart Phone Impact

January, 2016 A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

January, 2016
A7-R4: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which of these is an advantage of the database systems?
A) Data Abstraction
B) Program-data Independence
C) Centralized data management
D) All of the above
1.2 Which of the following phases of database design is the E-R model related to?
A) Conceptual Database design
B) Logical Database design
C) Requirement analysis
D) None of the above

Thursday, 22 September 2016

CBSE based Inter College based template with full source Code and Content


CBSE based Inter College Inter College based template with full source code so if you want to make any website for CBSE associate college then this project is complete solution. I have included CBSE based standard text content and image, you don’t have to do lots of work for content. I bet you that you will not download such type of project net free of cost …. So enjoy …CBSE based Inter College Inter College based template with full source code so if you want to make any website for CBSE associate college then this project is complete solution. I have included CBSE based standard text content and image, you don’t have to do lots of work for content. I bet you that you will not download such type of project net free of cost …. So enjoy It…

Wednesday, 21 September 2016

Import Microsoft Access Database table to PHP mysql database table

Microsoft Access TO PHP MYSQL

acess to mysql  Conversion

Follow the upcoming steps to import access data to mysql PHP based database

  • Export your access database to excel


  • Open excel file and save this file as csv by save as option go to others format

Q. Write a program to make three array name mArry, even & odd move array value in even & odd array respect to this type ?

event odd sepration program output


/* #############################
      Girfa Student Help
      Event Odd Sepration Program
      for more programs visit : http://girfahelp.blogspot.in/2012/09/some-program-of-c-language.html
   ##############################
*/
#include<stdio.h>
#include<conio.h>
#define MAX 5
void main()
{
      int even[MAX*2],odd[MAX*2],ar[MAX],i,oddindex,evenindex;
      clrscr();
      for(i=0;i<MAX;i++)
      {

Q. Write a program to make three array name mArry, even & odd move array value in even & odd array respect to this type ?

event odd sepration program output


/* #############################
      Girfa Student Help
      Event Odd Sepration Program
      for more programs visit : http://girfahelp.blogspot.in/2012/09/some-program-of-c-language.html
   ##############################
*/
#include<stdio.h>
#include<conio.h>
#define MAX 5
void main()
{
      int even[MAX*2],odd[MAX*2],ar[MAX],i,oddindex,evenindex;
      clrscr();
      for(i=0;i<MAX;i++)
      {

Tuesday, 20 September 2016

Template Class In C++

A class or function which can operate any type of with single bunch of code (Run time data type initialization)

Template is one of the features added to C++ recently. It is a new concept which enable programmer to make generic class which can operate any data type. A Template class takes data type as an argument which run time set data type of calling object so there is no need to make different version of class and function different types of data type.
Syntax:
                Template <Class name Ob_Name>
                Class Class_name
                {
                                _____
                                _____
                }
A template can be considered as a kind of macros. When an object of a specific type is defined for actual use. The template definition for that class is substituted with the required data type. since a template is defined with a parameter that would be replaced by a specific data type at the time of actual use of the class or  function. The template is sometimes called parameterized or function. 

/* ##############################
      Girfa Student Help
      Template Class
      Date : 21-Sep-2016
      for more example visit:  http://girfahelp.blogspot.in/p/c-tutorial_20.html
   ###############################
*/
#include<iostream.h>
#include<conio.h>
const int size=3;
template <class t>
class vector
{
      t *v;
      public:
      vector()
      {
            v=new t[size];

Monday, 19 September 2016

Degree College Management PHP Project

Degree College Management

Degree College Management is a PHP based website for any type of degree and other higher level institution, with many customized feature from which you can claim to a dynamic website. This is a live project running from last 5 years. So you are just one jiffy away from submit your project and start working with advance professional programming.

Saturday, 17 September 2016

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 12

a)Create a tables Employee with following columns :

Employee table
b)Create a table Department with following columns:

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level Introduction to Database Management System Assignment 11

Manufacturing
Consider the following relation that keeps track of the orders placed by a manufacturing
company:
Orders(orderDate, deliveryDate, supplier, partID, material, price).
Suppose the following functional dependencies hold on the relation:
orderDate, supplier -> deliveryDate
partID, supplier, orderDate -> price
partID -> material
material -> supplier.

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level Introduction to Database Management System Assignment 11

Manufacturing
Consider the following relation that keeps track of the orders placed by a manufacturing
company:
Orders(orderDate, deliveryDate, supplier, partID, material, price).
Suppose the following functional dependencies hold on the relation:
orderDate, supplier -> deliveryDate
partID, supplier, orderDate -> price
partID -> material
material -> supplier.

Friday, 16 September 2016

NIELIT A Level Introduction to Database Management System Assignment 10

NIELIT A Level
Introduction to Database Management System
Assignment 10

Wholesale Dealer

Consider the following relation that keeps track of the sales of a wholesale dealer in trousers:
TrousersSold(customerID, customerName, model, size, day, numberSold, price)
Suppose the following functional dependencies hold on the relation:

customerID -> customerName
customerID, model, size, day -> numberSold
model, size -> price
model, price -> size

NIELIT A Level Introduction to Database Management System Assignment 9

NIELIT A Level
Introduction to Database Management System
Assignment 9

Exam Administration
Consider the following relation that keeps track of the exams taken by students at
a University department:
Exam(studID, studName, courseID, courseTitle, acadYear,
examSession, mark, degreeCourse)

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 8

Normalization of the CAR_SALE Table.
The purpose of this exercise is for you to demonstrate your ability to take a database schema and convert it up through the Third Normal Form. Upon completion of this exercise you will have:

a) Listed the functional dependencies for a database schema
b) Explained why a specific schema is not in Second or Third Normal Form
c) Normalized a given schema into the Third Normal Form
The below scenario has been created to help you determine the table structures r

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 7

The NBA (NDHU Basketball Association) is in dire need of a database in order to keep track of the 
activities in their league.
The entities in the database are

  • People (with attributes id, name and age),
  • Teams (with attributes team name and manager), and
  • Courts (with attributes court id, address and capacity).

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 6

Produce an E-R diagram, which documents the entities and relationships involved in the staff management and pay-roll for the employees working in a super market. Create a relational schema to hold information. Identify the tables, perform normalization to the tables
and fully implement the code with necessary validations using MS-Access / FOXPRO /

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 5

Assume that a Consumer item lease Company which leases various household items to its clients for their use for a specific period of time, maintains the following tables:

Clients (clientID, name, address, contact Phone)
Itemlist (itemID, itemName, itemCost, purchase Date )
Leaselist (clientID, transactionNO, itemID, startDate, returnDate, amountTObeCharged)

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 4



Consider the following requirements for a construction company that uses database system to keep track of its projects, workers and material requirements of various projects.

The projects for the company are of two kinds: (i) Turn key projects and (ii) Others.All the projects have a life cycle (Please note that the turn key projects have a maintenance phase in addition.) and workers are allotted as per the phase of the project. Each project has its own plan of completion that is drawn at the start of the project. The worker and material requirement of project is calculated at the start of the project.

Thursday, 15 September 2016

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level
Introduction to Database Management System
Assignment 3

Performa following queries in SQL using the above schema:
a) Find details of Teachers who taught DBMS.
b) Find details of students who did MCA from PB University.
c) Find courses taught by T# 5078.