Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. What is an External Schema ? Group of answer choicesThe object-oriented mapping of a (relational) database in an external client program. A database schema

1. What is an External Schema?

Group of answer choicesThe object-oriented mapping of a (relational) database in an external client program.

A database schema that only contains data about some entities that are external to your organisations - such as the customers or the suppliers.

A number of view definitions that provides an user a restricted view of a given logical schema.

A schema that was created by an external IT developer.

2.

Select three main components of a database management system (DBMS).

Group of answer choices

Query Optimizer

System Catalog Files

Buffer Manager

Replication Coordinator

HTML user interface

Transaction Manager

SQL Clients

C link library

3.

What are the three Levels of Abstraction of a database schema?

Group of answer choices

External Views, Conceptual Schema, Hardware Schema

Conceptual Schema, Physical Schema, Hardware Level

External Views, Physical Schema, Hardware Level

External Views, Logical Schema, Physical Schema

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is DDL?

Answered: 1 week ago