0
Schema means structure of the databse. Like, tables, constraints, relation
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is a database schema?
A database schema is described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables. Schemas 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 Levels of database schema 1. Conceptual schema, a map of concepts and their relationships 2. Logical schema, a map of entities and their attributes and relations 3. Physical schema, a particular implementation of a logical schema 4. Schema object, Oracle database object 5. Schema is the over all structure of the database
Functions of schema?
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 trainingsEducate, Learn & Servewww.Inclus.net
What is a system based system?
A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)
What is data system?
A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)
What is a data system?
A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)
What is a data based system?
A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)
What is the term for the database that contains information about Windows Server 2003 objects and their attributes?
Schema
Is schema a logical structure or physical structure in oracle database?
the schema can be termed either conceptual or logical or physical. But mostly speaking, the term schema is used to refer to a logical structure.
What is the term for the reservation database used by Travel Management Companies in DTS?
Global distribution system
Another term for document properties?
The properties of a database are commonly called a schema. The schema describes the tables in the database, the fields inside each table, the contents of each field, etc.
What does a databse do?
database is a structured collection of records or data that is stored in a computer system. A database usually contains software so that a person or program can use it to answer queries or extract desired information.[1] The term "database" refers to the collection of related records, and the software should be referred to as the database management system (DBMS). Other terms for DBMS are database manager or database system. When the context is ambiguous, however, many database administrators and programmers use the term "database" to refer to both the data collection and the software that enables it to be accessed. Typically, for a given database, there is a structural description of the type of facts held in that database: this description is known as a schema. The schema describes the objects that are represented in the database, and the relationships among them. There are a number of different ways of organizing a schema, that is, of modeling the database structure: these are known as database models (or data models). The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships (see below for explanation of the various database models). Database management systems are usually categorized according to the database model that they support. The data model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.
Are there any major similiarities between object oriented databases and relational databases?
In a Object Oriented Database, information is given in the form of objects as used in programming languages. "When database capabilities are combined with object programming language capabilities, the result is an object database management system (ODBMS). An ODBMS makes database objects appear as programming language objects in one or more object programming languages." (http://en.wikipedia.org/wiki/Object_database)"A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how those data are arranged). Common usage of the term "Relational database management system" technically refers to the software used to create a relational database, but sometimes mistakenly refers to a relational database." (http://en.wikipedia.org/wiki/Relational_database)
