Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.
Differences between conceptual schema, user views, and an internal schema
Conceptual schema | User views (External schema) | Internal schema |
• This schema is a combination of different external views of enterprise data. | • This schema is a combination of enterprise data model and user views. | • This schema is a combination of two separate schemas such as logical schema and physical schema. |
• This schema is viewed by the data architect or data administrator. | • It is viewed by managers and other employees such as database users. | • This schema is viewed by the database administrator. |
• It defines the entire database without referencing how data are stored in the secondary memory of the computer. | • It describes both bottom-up and top-down views of users. | • It defines the way in which the data management technology is represented and how the data is represented in secondary storage. |