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
How does Tuple-oriented relational calculus vary from domain-oriented relational calculus? The tuple-oriented calculus uses a tuple variables i.e., variable whose only allowed

1.  Define each of the following IN YOUR OWN WORDS: (a)   File: (b)   Record: (c)   Field: (d)   Primary Key: (e)   Secondary Key: 2.  A travel agency wants t

Run the following queries. For each query show 1) What you expect the output to be based upon the data 2) the SQL code and 3) the output running the query in Oracle. 1. Show all c

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode


Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

What function divides one numeric expression by another and returns the remainder? MOD function divides one numeric expression by another and returns the remainder.

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho