0
The schema (pronounced skee-ma) of a database system is its structure described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, Java, XML schema's and other elements.
Schema's are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure.
Hope this helps!
Inclus - We provide indivdual and coporate trainings
Educate, Learn & Serve
www.Inclus.net
What else can I help you with?
Five main functions of database administrator?
Schema Definition Storage structure and access method definition Schema and physical organization modification. Granting authorization for data access. Routine Maintenance
What is star flake schema?
A starflake schema is a combination of a star schema and a snowflake schema. Starflake schemas are snowflake schemas where only some of the dimension tables have been denormalized. hardkingofflirt@gmail.com
Why Shared schema are valuable for organizations network?
The schema contains all the information how the objects need to be created, what type of objects can be created in the forest what are its attributes, functions, its class files etc .if we have the shred schema in the network all the objects in the forest and domain will be same types so it will be easy to manage,administer, apply security in the network
What is schema and sub-schema?
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.
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
What part of speech is the word schema?
Schema is a noun.
Which holds writable copy of AD schema?
Schema Master
What is schema in mysql?
Schema is structure you created for your tables in My SQL
Why do you need mapping between schema levels?
There is need for mappings between schema levels for visualization and schema matching. The mappings between schema levels helps in the different types of transformation.
Why should a sub schema be independent of schema?
I do not do not sens me something today
How do different schema definition languages support schema architecuret?
poda
What is a neural schema of a robot?
Neuron schema is brain of a robot in which the datas
