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
Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.

What types of adjustments are required to increase chances of inheritance. a)   Some attributes can be added or ignored in  the base class operation  b) Some changes can be

Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

1) 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 pict

Ways for Selecting Data Structure Algorithms operate on data structure. Therefore, selection of the best algorithm means selecting the best data structure from whole bunch. Th

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen