COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
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: -The overall design of a database is called schema. A database schema is the skeleton structure of the database. It represents the logical view of the entire database. A schema contains schema objects like table, foreign key, primary key, views, columns, data types, stored procedure, etc.
Detailed explanation-3: -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).