Question

I need new and unique answers, please. (Use your own words, don't copy and paste), Please Use your keyboard (Don't use handwriting) Thank you..

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?

Answer 1

In DBMS we need database diagram (schema) from a database theoretical model to get descriptions of the database's actual logical structure.

A database diagram (schema) is sensible and visual engineering of a database based on a database executives framework. It gives a graphical perspective on the engineering and structure of the whole database. It gives a way to legitimately gather and show objects from the database, for example, tables, fields, capacities, and relations. A database schema ordinarily shows the different tables, their fields, and their association with different tables.

The logical schema reflects the logical database system structure. It figures all the Database data. This decides how information is organized, how various connections are mapped, for example, foreign key, primary key, and so on. It incorporates broad database elaboration, which can be effectively derived from the schema.

As a rule, it is the obligation of developers and database administrators (DBA), business examiners, programming engineers, information modelers, and designers.