This may come as the second step for a BI project. A physical schema is a detailed graphical structure of a database. The physical schema is designed based on the logical data model. We can create any number of physical schema from a logical data model. Physical schema shows tables and columns.