Explain the difference between intension and extension in a database.

1.	Explain the difference between intension and extension in a database.
Answer» Following is the major DIFFERENCE between intension and extension in a database: Intension: Intension or POPULARLY known as database schema is used to define the description of the database and is specified during the design of the database and MOSTLY remains unchanged. Extension: Extension on the other hand is the measure of the number of TUPLES present in the database at any given point in time. The extension of a database is also referred to as the snapshot of the database and its VALUE keeps changing as and when the tuples are created, updated, or destroyed in a database.

Answer»

Following is the major DIFFERENCE between intension and extension in a database:

Intension: Intension or POPULARLY known as database schema is used to define the description of the database and is specified during the design of the database and MOSTLY remains unchanged.
Extension: Extension on the other hand is the measure of the number of TUPLES present in the database at any given point in time. The extension of a database is also referred to as the snapshot of the database and its VALUE keeps changing as and when the tuples are created, updated, or destroyed in a database.

Discussion