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

What three major types of actions includes databases, What three major type... What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

Define the query optimisation, Define the Query optimisation The query ... Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Need point of sale software for pizza restaurant, Project Description: N... Project Description: Need Point of Sale software for pizza restaurant. Delivery and take out service, client's database, inventory control, order history, last order, order from

Lack of standards and experience, Lack of standards and experience: The la... Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha

Give short note on the following terms- dirty pages and etl, Give short not... Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

Describe the algorithm to draw the dependency graph, Describe the algorithm... Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

horizontal fragmentation, Horizontal Fragmentation- Horizontal fragmentati... Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

What is a heterogeneous distributed database, What is a heterogeneous distr... What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

What is an operand, What is an Operand? The data on which the operation... What is an Operand? The data on which the operation is to be performed is known as an Operand

Explain the term - handling boundary condition, Explain the term - Handling... Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro