Question

In DBMS, what would you use to obtain information about the current logical structure of the database? How this information is recorded in the DBMS and who is responsible to maintain it?

Sometimes I can't understand the handwriting, so make it clear, please.

Thank you.

Answer 1

I have already answered the question once before. So, requesting you to mention if you have any question or doubt.

First Part:

In DBMS, database schema is used to obtain information about the current logical structure of the database.

Second Part:

Logical schema represents the logical structure of the database system. It provides the information about the following:
(i) Organization of data in the database,

(ii) Primary key,

(iii) Foreign key,

(iv) Key mapping,

(v) Constraints of the attributes, etc.

• The database designer is responsible for logical schema maintenance.

Hope this helps.