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
How to Insert data in your table from another table? insert into e.g, To insert tuples from employee into N_emp created above, use following statement Insert into N_emp

what is RDBMS? how it works? good example.

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

Question: A DBMS built for Online Transaction Processing (OLTP) is generally regarded as unsuitable for data warehousing. Each system is designed with a different set of requir

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio

Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

Update Operations and Dealing with Constraint Violations There are three basic operations to be executes on relations: Insertion Deletion Update The INSER


Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall

what does glory be mean