Explain instance and schemas, Database Management System

Assignment Help:

Explain Instance and schemas?

Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database at a particular moment in time is known as Instances and the whole design of database is known as schemas.

Related Discussions:- Explain instance and schemas

Recovery management component, Ask question #Minim 100 words accepted#what ...

Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

Three levels of ANSI-SPARC architecture, a need some real life examples of...

a need some real life examples of database management systems three level of ANSI SPARC architecture life teacher and student ,company and employee or for NGO etc.

Define the wait for graph, Define the Wait for graph Ans: The wait-for-...

Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

State the meaning of object representation, State the meaning of Object Rep...

State the meaning of Object Representation The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

3NF Normalization, Need 2 projects completed in 3NF format.

Need 2 projects completed in 3NF format.

What is a b+-tree index, What is a B+-Tree index? A B+-Tree index takes...

What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

What is system r?what are its two major subsystems?, System R was develop...

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

To eliminate duplicate rows-data manipulation language, To eliminate duplic...

To eliminate duplicate rows (distinct operator) Example: SELECT DISTINCT DEPTNO FROM EMP;

Explain foreign key, Explain Foreign Key? Foreign Key - Let there are...

Explain Foreign Key? Foreign Key - Let there are two relations (tables) R and S. Any candidate key of the relation R that is referred within the relation S is known as the fo

Explain the aggregation implies concurrency, Explain the Aggregation implie...

Explain the Aggregation implies concurrency Concurrency actually is: This in objects can be identified by the way they change state. Present objects can change state independen

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages