MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

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: -A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated.

There is 1 question to complete.