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
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT