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
What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is

i want notes on this topic

Question (a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an general procedure and event procedure. (c)

Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHE

PART MARKING:  We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with

Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to

I need a help with my assignment of data envelopment analysis which is due for submission next week on monday the 10th Dec. Will you be able to help so that I can submit it on tim

System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

#quesDefine 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 pi