Question

________ is known as design of database.

• A. Constraints
• B. Keys
• C. Schema
• D. Tuples

Hint:

Schema = Structural blueprint design of the database (fixed).
Instance = Actual data snapshot at any given instant (changes constantly).

Answer 1

The Correct Option is C

Concept:
In database terminology, a clear distinction is drawn between the overall structural design of the database and the actual data values stored within it at any given moment.

Step 1: Defining Database Schema:
The overall design, structural description, and skeleton of a database is called the Database Schema.
A database schema defines the tables, attribute names, data types, relationships, and integrity rules that govern how data is organized.
The schema remains relatively static throughout the life cycle of the database system.
In contrast, the actual data populated inside the schema at a particular instant in time is referred to as a Database Instance.

Step 2: Evaluating Other Terms:
Constraints are logical assertions, restrictions, or business rules applied on attributes or relations to ensure data integrity.
Keys are specific fields designated to uniquely identify records and establish relations between tables.
Tuples represent individual rows containing actual data instances inserted into the relational tables.
Final Answer:
The structural design and definition of a database is universally termed the Schema.