Computer Science
Differentiate between database state and database schema.
Relational Database
4 Likes
Answer
| Database state | Database schema |
|---|---|
| The data stored in database at a particular moment of time (i.e., the state of the database at a particular instance of time) is called database state or instance of database. | The database schema defines the design, structure, and organization of the database, serving as the blueprint or skeleton that determines how data is organized and related within the database. |
Answered By
4 Likes
Related Questions
Give the terms for each of the following:
(a) Collection of logically related records.
(b) DBMS creates a file that contains description about the data stored in the database.
(c) Attribute that can uniquely identify the tuples in a relation.
(d) Special value that is stored when actual data value is unknown for an attribute.
(e) An attribute which can uniquely identify tuples of the table but is not defined as primary key of the table.
(f) Software that is used to create, manipulate and maintain a relational database.
Why foreign keys are allowed to have NULL values? Explain with an example.
Differentiate between primary key and foreign key.
Differentiate between degree and cardinality of a relation.