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
Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

i am required to come up with entities relationships, optionality and cardinality from a scenario. there is a night club and bookings for a musician band

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form

Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?

Explain Deadlock detection and recovery Deadlock Detection - A deadlock is said to take place when there is a circular chain of transaction, every waiting for the release of a

In Database software have only pure security or some dis secured by administrator?


What is a query tree?     Ans:  A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu

Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha