SCHEMA is the physical arrangement of the data as it appears in the DBMS. SUB-SCHEMA is the logical view of the data as it appears to the application program.
Conceptual - a model that captured the essential data that needed to be stored and the relationships between elements * Physical - the on disk representation of data that accounts for layout,...
The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.
STAR SCHEMA ::contains dimension tables mapped around a fact table. it is a de normalised model.no need to use complicated joins.queries results fastly. @ahsan_ravian@hotmail.com
Database schema are the logical structure of entities (tables or object classes) and their relationships (keys, or object associations) in a database. Schema can exist at different levels of...