The role of the external schema is to support user views of data and thus to provide programmers with easier data access
Chat with our AI personalities
Logical Structure of database is know as database schema. All database entities are defined and relation between then is represented in structured way. It includes all constraints to be apply on each identity.
Relational Schema refers to meta-data elements which are used to describe structures and constraints of data representing a particular http://wiki.answers.com/Describe_the_differences_in_meaning_between_the_terms_relation_and_relation_schema#. Whereas a relation is a property or predicate that ranges over more than one argumentHere's some translation from "Relational Algebra" to http://wiki.answers.com/Describe_the_differences_in_meaning_between_the_terms_relation_and_relation_schema#terminology:"Relation" = Table."Relation Schema" = Table definition.So for example, the "schema" for the Person "relation" is: Person(FirstName, LastName, Age, Gender, Address)Also in relational Algebra, a "tuple" is a table row, and an "attribute" is a table column.
External is out side emotional is in
EXT. Stands for External, as in external location (outside).
external 20 internal 200