DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Application prgm
|
|
|
DDL
|
|
|
Schema
|
|
|
Source code
|
Detailed explanation-1: -A schema is an overall description of a database, and it is usually represented by the entity relationship diagram (ERD).
Detailed explanation-2: -Which one of the following is commonly used to define the overall design of the database? In order to define the overall design of the database, generally, the schema is used. Therefore the correct answer is C.
Detailed explanation-3: -ER diagram (entity-relationship model) An ER diagram is a diagram that helps to design databases in an efficient way.
Detailed explanation-4: -The overall design of the database is called the database schema.
Detailed explanation-5: -The database schema is the structure of a database described in a formal language supported by the database management system (DBMS). The term “schema” refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases).