Discuss the different layers of ansi sparc architecture, Database Management System

Assignment Help:

Q.1 Briefly discuss the different layers of ANSI SPARC architecture.

Ans: The three layers of ANSI SPARC architecture are like this:

1. Internal view is at the lowest level of abstraction, closest to the physical storage method employed. It points out how the data will be stored and explains the data structures and access methods to be employed by the database. There is one internal view for the whole database.

2. Global or Conceptual View: At this level of abstraction all the database entities and the relationships between them are included. There is one conceptual view for the whole database.

3. External or User View: The external or user view is at the highest level of database abstraction in which just only those portions of the database concern to a user or application programme are involved. Some external or user views may exist for a specified global or conceptual view.


Related Discussions:- Discuss the different layers of ansi sparc architecture

What is a b+-tree index, What is a B+-Tree index? A B+-Tree index takes...

What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

Fire dementpart, The State of NewYork certifies firefighters throughout sta...

The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb

Create a database, Project: Microsoft Access You have been asked by the ...

Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access

Attributes, Attributes and its types explain?

Attributes and its types explain?

Basics of relational models, In the first unit of this block, you have been...

In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you informat

What is null, What is NULL? Simply NULL means not in value.

What is NULL? Simply NULL means not in value.

Explain relevance of data dictionary in a database system, Explain the rele...

Explain the relevance of Data Dictionary in a Database System? Data dictionary is a database in its own right residing on the disk that consist of Meta data which is = Data abo

Provide the steps involved in ethical analysis, Question : Mr. Smith Ha...

Question : Mr. Smith Harry has a car manufacturing company which has recently integrated management information system. He wishes to obtain more information on ethics and socia

Organize the clients from email marketing, Function requirement as given: ...

Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd