Question

A _______ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
1. relational algebra
2. schema diagram
3. relational query languages
4. flow diagram

Answer 1

Correct Answer - Option 2 : schema diagram

A schema diagram is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes and primary keys and foreign keys.

Explanation:

In database, schema is the organization and structure of a database. Schema contains tables, views, procedures, primary keys, foreign key etc.

Schema is represented with the help of diagram which shows the relation between tables, attributes, primary and foreign keys etc. Such diagram is known as schema diagram.