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 schema

Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of

While sorting field groups we cannot use more than one key field False.

what are information system hirarchy?

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

WHY SHOULD NULL IN A RELATION BE AVOID AS possible?