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?
Correct Answer: C
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, and accessed.
References: The concept of logical schemas is discussed in IT and database design textbooks and CompTIA IT Fundamentals resources as part of learning about effective database management and design.