Question

Discuss about physical and logical scheme.

Answer 1

A logical schema is a conceptual model of the data. In relational databases, it's often platform-agnostic - i.e. the logical schema can, in principle, be implemented on any SQL database. The logical schema is primarily concerned with understanding the business entities, their attributes and their relationships.

The logical schema is often captured as an entity-relationship diagram (ERD), using tools like ErWin or ERStudio.

The physical schema converts the logical schema into an implementation that works on a particular database platform. Sometimes, this is a largely mechanical exercise, applying the right datatypes to the attributes, but it can also involve performance optimizations such as denormalization, platform-specific features such as triggers, and sizing/performance decisions like physical disk distribution.

Many ERD tools can "automagically" convert a logical design into a physical schema.

The physical schema is converted into an actual database using DDL SQL statements.

PLEASE MARK MY ANSWER AS A BRAINLIEST ANSWER.

Answer 2

hi your answer is
✅✅✅✅✅✅✅✅✅✅
✳✳✳✳✳✳✳✳✳✳

A schema is the set of metadata (data dictionary) used by the database, typically generated using DDL.

It defines attributes of the database, such as tables, columns, and properties.

A database schema is a description of the data in a database.

One or more schemas can reside on the same database.
✅✅✅✅✅✅✅✅✅✅
✳✳✳✳✳✳✳✳✳✳
plz mark as brain list