FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ decides how the logical DB design is to be physically realised
A
Data Administrator (DA)
B
Database Administrator (DBA)
C
Database Designers (Logical & Physical)
D
Application Programmers
Explanation: 

Detailed explanation-1: -Physical data models are used to visualize the physical structure of databases and data files. Logical data models are used to visualize data entities, attributes, keys, and relationships.

Detailed explanation-2: -Definition. Logical database design is the process of transforming (or mapping) a conceptual schema of the application domain into a schema for the data model underlying a particular DBMS, such as the relational or object-oriented data model.

Detailed explanation-3: -The logical design is more conceptual and abstract than the physical design. In the logical design, you look at the logical relationships among the objects. In the physical design, you look at the most effective way of storing and retrieving the objects. Your design should be oriented toward the needs of the end users.

There is 1 question to complete.