Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: jaredman384 on Dec 11, 2016



Title: Database Question: Which of the following is not one of the three (3) types of models that make up ...
Post by: jaredman384 on Dec 11, 2016
Which of the following is not one of the three (3) types of models that make up the ANSI/SPARK 3-schema model?

   A.   
External Schema

   B.   
Physical Schema

   C.   
Internal Schema

   D.   
Conceptual Schema



Title: Re: Database Question: Which of the following is not one of the three (3) types of models that make ...
Post by: kpetrsen6925 on Mar 7, 2017
The one that does not belong is B. Physical Schema

ANSI-SPARC consists of 3 tiers:
Internal: How the data is stored on the database is represented to the user.

Conceptual: The relationship between the data members of the database, exactly what data is stored in it and what a user will need to use the database.

External Layer: Allows a user to access a customized version of the data in the database.