0
What else can I help you with?
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
What do you mean by degree in DBMS?
It is the number of attribute of its relation schema. Its is an association among two or more entities..
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.
What is sub schema?
The schema is the physical arrangement of the data as it appears in the DBMS. The sub-schema is the logical view of the data as it appears to the application program.
What is difference between Schema and Subschema?
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.
Difference between schema sub schema and instance in DBMS in detail?
the overall logical data base description is referred to as a schema. it is sometimes also referred to as an overall modal of the data, a conceptual modal of the data, a conceptual schema
Difference between database schema and a database state in dbms?
The distinction between database schema and database state is very important. When we define a new database, we specify its database schema only to the DBMS. At this point, the corresponding database state is the empty state with no data. We get the initial state of the database when the database is first populated or loaded with the initial data. From then on, every time an update operation is applied to the database, we get another database state. At any point in time, the database has a current state. The DBMS is partly responsible for ensuring that every state of the database is a valid state-that is, a state that satisfies the structure and constraints specified in the schema. The DBMS stores the descriptions of the schema constructs and constraints-also called the meta-data-in the DBMS catalog so that DBMS software can refer to the schema whenever it needs to. The schema is sometimes called the intension, and a database state an extension of the schema.
What are the 3 views of dbms?
A Database has three views. The External Schema: What the end user sees. The Internal Schema: What the programmers of the program see. The Conceptual Schema: The basic plan of the database. Most of the time this is in paper form as a Conceptual Schema Diagram (CSD)
What is the Difference between relation schema and relation instance?
difference between relation sehema and relation instance in dbms
What do you mean by lossiess join in dbms?
what do u mean by lossiess join in dbms
What does schema mean?
a kid answer
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
