ISRO2016-56

Question

Goals for the design of the logical scheme include

• A. avoiding data inconsistency
• B. being able to construct query easily
• C. being able to access data efficiently
• D. All of the above

Answer 1

A database's logical schema is its overall logical plan. This schema is developed with diagrams that define the content of database tables and describe how the tables are linked together for data access.
 

During the first part of Logical Design, a conceptual model is created based on the needs assessment performed in stage one. A conceptual model is typically an Entity -Relation( ER)diagram that shows the tables, fields, and primary keys of the database, and how tables are related (linked) to one another. 

The tables sketched in the ER diagram are then normalized. The normalization process resolves any problems associated with the database design, so that data can be accessed quickly and efficiently.

Hence,Option(D)All of the above.

Reference:http://www.relationaldbdesign.com/relational-database-design/module3/schema-architecture.php

Comments

Point (B) could be checked directly. Could you please explain how logical schema helps in satisfying point (A) and (C) ?

Answer 2

Correct answer is option (d).