The external or view level in dbms, Database Management System

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.

156_Logical DBMS Architecture.png

           Logical DBMS Architecture

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







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
Related Questions
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

What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche

This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to mode

Define multivalued dependency and 4NF.  Ans:  Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency  α →→β   holds o


What are the several forms of identity? a) Value b) Name c) Built-in

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

Project Description: Oracle Certified Professional with 20 years of practice, Oracle version 6.0.34, 7.3, 8.0, 8i, 9i, 10G, 11G, 12C. Crossplatform migration, Informix, MSSql

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Explain the function of input controls. Identify four types of input control and explain the function of each. Provide an example of a data integrity error that could occur i