A database administrator would like to create a visual diagram of the layout of a new relational database. Which of the following should the administrator use?

The correct answer is B. Physical schema. A logical schema in database design is a visual diagram that represents the framework or structure of the database, without getting into the details of physical storage. It includes tables, views, and the relationships between them, and is used to conceptualize and plan the struc

Database Fundamentals

Question

Options

AFlowchart schema
BPhysical schema
CLogical schema
DTable schema

How the community answered

(37 responses)

A
3% (1)
B
86% (32)
C
8% (3)
D
3% (1)

Explanation

A logical schema in database design is a visual diagram that represents the framework or structure of the database, without getting into the details of physical storage. It includes tables, views, and the relationships between them, and is used to conceptualize and plan the structure of the database at a high level. This makes it an essential tool for a database administrator when planning a new relational database, as it helps in understanding how data will be stored, linked,

Topics

#Database schema#Physical schema#Relational database design

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice