Problem

Explain the differences between user views, a conceptual schema, and an internal schema...

Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.

Step-by-Step Solution

Solution 1

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.

Add your Solution
Textbook Solutions and Answers Search