Explain the three Level Architecture of the Database System



Explain the three Level Architecture of the Database System..

Answer / Raja Singh

The Three-Schema Architecture, also known as the Three-Level Model or TTM (Terry's Triple Models), is a database design which involves a logical schema, a view schema, and a physical schema. The logical schema organizes data from the user's perspective, the view schema translates the logical schema into the capabilities of the database management system, and the physical schema stores data on disk.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

how to generate an auto incremental number in a ssis package?

1 Answers  


What is cardinality in db?

1 Answers  


Can we linked SharePoint to a SQL databasebe?

1 Answers   Sans Pareil IT Services,


What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1 Answers  


How do you organize a database?

1 Answers  


Can you drop all the columns of a table ?

1 Answers   MCN Solutions,


1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

0 Answers  


What do you understand by e-r model?

1 Answers  


What is the main purpose of normalization?

1 Answers  


Explain types of indexing in dbms?

1 Answers  


Why do I need netlib?

1 Answers  


What are the 5 databases?

1 Answers  


Categories