Question

In 175 words:

• Explain two differences between an External Schema and a Conceptual Schema.
• Provide an example of how each schema type would be used to support a business case for a database.

Answer 1

Solution:

Conceptual Schema or logical schema:

1. All of the data which is stored in the database is describes by the conceptual schema. Despite being several views available for the database there exist only one conceptual schema for all of the users.
2. The database structure for the whole database is depicted with the help of conceptual schema. for the whole community.

Example: the example will be semantic of any organization which describes and represents a series of assertions about its nature.

External schema:

1. The data access can be customized here, allows data access to be customized (and authorized)at the level of individual users or groups of users.
2. An external schema describes the part of the database which specific user is interested in
3. Unrelated details are hidden from the user in an external schema
4. The data which is viewed by the specific end-user is shown by the external schema.
5. External schema level is closest to the end-user

Hit the thumbs up if you liked the answer. :)