answersLogoWhite

0

Database Instance

The term instance is typically used to describe a complete database environment, including the RDBMS software, table structure, stored procedures and other functionality. It is most commonly used when administrators describe multiple

instances of the same database.Also Known As: environment

Examples: An organization with an employees database might have three different

instances: production (used to contain live data), pre-production (used to test new

functionality prior to release into production) and development (used by

database developers to create new functionality).

RELATION SCHEMA

A relation schema can be thought of as the basic information describing

a table or relation. This includes a set of column names, the data types associated

with each column, and the name associated with the entire table. For example, a

relation schema for the relation called Students could be expressed using the

following representation:

Students(sid: string, name: string, login:

string, age: integer, gpa: real)

There are five fields or columns, with names and types as shown above.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is the Difference between relation schema and relation instance?

difference between relation sehema and relation instance in dbms


What is the Difference between instance and physical database?

The terms instance and database are closely related, but don't refer to the same thing. The database is the set of files where application data (the reason for a database) and meta data is stored. An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the database. A database can be opened (or mounted) by more than one instance, however, an instance can open at most one database.


Distinguish between a relation and a relationship in database?

Relation is one record in the database or a tuple. Relationship is that how tables are connected to each other.


What is relation in terms of database management system?

A relation is an assciation between two or more entities.


What is the difference between relation and relationship in database?

Relation: In Database a relation represents a table or an entity that contain diffrenet attributes.An Entity constructs a relation(table) in DBMS . Relationship: In Data base relationship is that how the two entities are connected to each other ,i.e what kind of relationship type they hold between them.Primary/Foreign key is used to specify or hold this relationship. By Tanzeel Ur Rahman Bhatti


What is Difference between real time database and simple database?

the difference is about the transactions. the normal database is not included deadline, but the real time database is.


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


Difference between light and electricity?

Difference?? There is no relation.


Difference between database and database instance?

In general, a database is a collection of related data. In more specific terms, a database is typically a collection of computer files, usually stored on disk, used to contain and manage this data. The logical structure of a database (as organized in tables, indexes, views, etc.) does not necessarily correspond directly to its physical structure (the data files, transaction log files, etc.). A database instance is the instantiation of memory structures and processes by a database management system manages the logical and physical structures and the data organized and stored therein. An application program must connect to and interact with the database instance in order to insert, retrieve, modify, and/or delete data stored in the database.


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


What is the difference between database management and documents management systems?

differences between document management and database technology


What is the difference between a database management system and a database?

DBMS: Set of software applications combined w/ a database