What is Database Architecture ?

Each database will be divided into two types of implementations
•Logical implementation
Tables, views, procedures ..etc
•Physical implementation
.LDF, .MDF and NDF files

When using a database, you work primarily with the logical components such as tables, views, procedures ..etc The physical implementation of files is largely transparent. Typically, only the database administrator needs to work with the physical implementation.