The External or View Level

The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see only the data of interest to them. The user can be either an end user or an application program. There can be a lot of external views as any number of external schemas can be defined and they can overlap each other. It contains of the definition of logical records and relationships in the external view. It also has the methods for deriving the objects such as attributes, entities and relationships in the external view from the Conceptual view.

           Logical DBMS Architecture

Posted Date: 3/5/2013 4:59:31 AM | Location : United States

Ask an Expert

Related Discussions:- The external or view level in dbms, Assignment Help, Ask Question on The external or view level in dbms, Get Answer, Expert's Help, The external or view level in dbms Discussions

Write discussion on The external or view level in dbms
Your posts are moderated

Write your message here..

Related Questions

Relationship between two tables-strategic decision making, In a job intervi... In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a s

Entity integrity, Before defines the second type of integrity constraint, v... Before defines the second type of integrity constraint, viz., Entity Integrity, we should be well-known with the concept of NULL. Mostly, NULL is intended as a basis for dealing

Describe log based recovery, Describe log based recovery The most usabl... Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

The concurrent transactions, The Concurrent Transactions  Almost every ... The Concurrent Transactions  Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

Define dba database administrator, Define DBA database administrator? ... Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:

Determine bcnf-dcnf and key relation, (A) For the relation; CarSales (R... (A) For the relation; CarSales (RegNo, BuyerName, Address, SalesPerson, Make, Model, Commission) The following functional dependences hold, RegNo _ID à Make, Model Reg

Define cascading rollback, Define Cascading rollback The phenomenon whe... Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.

How to rearrange the execution order for efficiency, Rearrange the Executio... Rearrange the Execution Order for Efficiency  Rearranging execution order for efficiency means executing such job that requires less execution time. By rearranging the object

Create student db and execute insert query, Create Student DB and execute I... Create Student DB and execute Insert query? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course

Oracle fusion middleware, Oracle Fusion Middleware: Key Skills: Consul... Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink