Define the terms - physical schema and logical schema, Database Management System

Define the terms  1) physical schema 2) logical schema. 

Physical schema:  The physical schema explains the database design at the physical level, which  is  the  lowest  level  of  abstraction describing  how  the  data  are actually kept. 

Logical schema: The logical schema explains the database design at the logical level, which explains what data are kept in the database and what relationship exists between the data.  

 

Posted Date: 7/27/2013 6:36:21 AM | Location : United States







Related Discussions:- Define the terms - physical schema and logical schema, Assignment Help, Ask Question on Define the terms - physical schema and logical schema, Get Answer, Expert's Help, Define the terms - physical schema and logical schema Discussions

Write discussion on Define the terms - physical schema and logical schema
Your posts are moderated
Related Questions
Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description

#question.ERD of any car

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

What is an object design? Object design is a very interactive method, which decides the relationship among objects, classifies operations on classes, determines overall system

Which language used in application programs to request data from the DBMS is referred? Language which is used in application program is DML to request data from the DBMS is ref

Consider a research paper submission process. The process starts when an author submits a draft research paper (the paper may have up to 3 authors) to the chair of the organizing c

Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.

How can we Classify the operations on classes  This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue