Explain the ansi sparc architecture, Database Management System

Assignment Help:

Explain the ANSI SPARC architecture

The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user applications and the physical database. The view at every of these levels is described by a schema. The procedures of transforming requests and results among levels are known as mappings. In this architecture, schemas can be illustrated at the following three levels:

  • External Level or Subschema - It is the highest level of database abstraction in which only those portions of the database of concern to a user or application program are involved. Any number of user views might exist.
  • Conceptual Level or Conceptual Schema - At this levels of database abstraction all the database entities and the relationships between them are included. There is just only one conceptual schema per database.
  • Internal Level or Physical Schema - It is closest to the physical storage method employed.

Related Discussions:- Explain the ansi sparc architecture

Explain data sublangauges, Explain Data Sublangauges ? Data sublanguage...

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

Draw an erd for the above relational schema, The following relational datab...

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

Determine the objectives of object oriented design, Determine the Objective...

Determine the Objectives of object oriented design provide an overview of object oriented design; partitioning system to subsystems; describe how a software desig

Define query by example, Define Query by Example QBE is a query languag...

Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of

HRM, is Chipo carrying his baby

is Chipo carrying his baby

Express the subsequent query in sql assumes, Express the subsequent query i...

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

Describe the storage structure of indexed sequential file, Describe the sto...

Describe the storage structure of indexed sequential files and their access method. Ans: Index offers a lookup capability to rapidly reach the vicinity of the desired record.

Project operation, The PROJECT operation The project operation is used t...

The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

Define deferred update technique of recovery, Discuss deferred update techn...

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

Explain about primary key, Explain about primary key Primary Key: It ...

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

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