92.0k views
3 votes
Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host language, data sublanguage, database utility, catalog, client/server architecture, three-tier architecture, and n-tier architecture.

User Freinn
by
6.4k points

1 Answer

4 votes

Answer:

Following are the solution to the given terms:

Step-by-step explanation:

Data Model: A set of concepts that are ideal for describing the layout, computational tools, relations, semantics, constraints on accuracy.

Database Scheme: It is also known as the overall design of the database.

Database State: It is the data in the database at a particular moment in time.

Internal Schema: The physical structure of the database is defined.

Conceptual Schema: It hides the details of physical storage.

External Schema: It describes the part of the database the user group sees. In other words, we can say that it is a view of the database.

Data Independence: The ability to modify the schema at a single level while modifying the schema at a higher level is often recognized.

DDL: It stands for the Data Definition Language, which is used by DBA and dev use for creating With particular scheme.

DML: It refers to the Data Manipulation Language, which is used to manipulate, add, recover, insert, remove, and alter data.

SDL: It stands for the storage definition language, in which the internal schema of the database is applied for storage description.

VDL: The view definition language specifies the user to view and mapping their conceptual schema.

Query Language: It is just an independent, dynamic, high-level dialect used during manipulation.

Host Language: It is also the machine language, that would be incorporated into the general programming language by low-level data handling commands.

Data sublanguage: It uses for embedding in the last language.

Database Utility: It is a program, which helps to handle the database with DBA's modules.

Catalog: The entire structure and constraints of the database is defined.

client/server architecture: The design of the database server system that device usability: model user, model server (landless storage) software Government computer design in which many users (remote processors) demand a central server to receive service (host computer).

Three-tier architecture: It is the application, data, user interface.

n-tier architecture: multiple levels. The nth level must only be able to handle the n+1 application and transmit it to the n-1 point.

User Teru
by
5.9k points