answersLogoWhite

0

The database schema is the description of the database. It defines how the database is set up and what data it is to contain and control. This description is given to the DBMS to manage the data. The database state is an image of how the database looks at any given time. The database schema is set unless you change how the database is structured. The database state will change whenever new data is entered into the database and the database is updated.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

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.


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


What six major steps would you take in setting up a database in a particular enterprise?

1. Requirement Analysis2. Conceptual List_six_major_steps_that_you_would_take_in_setting_up_a_database_for_a_particularBase Design3. Logical Data Base Design4. Schema Refinement5. Physical Data Base Design6. Security Design


List six major steps that you would take in setting up a database for a particular?

1. Requirement Analysis 2. Conceptual Data Base Design 3. Logical Data Base Design 4. Schema Refinement 5. Physical Data Base Design 6. Security Design


What are the characteristics of a data base?

database is the collection of data


What is the definition of database?

A data base is a collection of data.


Why do you have data base?

Database is used for storing data that are related. We need database in every field for storing data.


What is a collection of data that is stored electronically as a series of records in a table?

A database.


Who are the database users?

The data base are not people but people make the data base like Steve jobs is a data base maker


Data organized in a way that allows access and use of that data?

A "Database"


What is an organized collection of information?

Database


Is a data base hardware or software?

database is a software.