Define instance and schema, Database Management System

Define instance and schema? 

Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database. 

Schema: The overall design of the data base is known as the data base schema.  

 

Posted Date: 7/27/2013 6:35:40 AM | Location : United States







Related Discussions:- Define instance and schema, Assignment Help, Ask Question on Define instance and schema, Get Answer, Expert's Help, Define instance and schema Discussions

Write discussion on Define instance and schema
Your posts are moderated
Related Questions
Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

What is the difference between a key and a superkey? Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

to develop elrctronic database from manual forms

I am going to develop a web site to present decision tree structure. For this, I want a web application with AJAX technology to connect the database and prepare the decision tree's

The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing