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

PHP Hardware Institute Website Free Download

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

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

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

Download Free PHP FMCG Website Full Source Code

FMCG

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.

PHP Online Test 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

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

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…

Import Microsoft Access Database table to PHP mysql database table

Microsoft Access TO PHP MYSQL

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 ?

/* #############################

      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 ?

/* #############################

      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++)

      {

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];

Degree College Management PHP Project

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.

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 :

b)Create a table Department with following columns: