DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Stores definitions of the data elements and their relationships
|
|
|
Data transformation and presentation
|
|
|
Ensures efficient performance of the database in terms of storage and access speed
|
|
|
Security management
|
Detailed explanation-1: -Data dictionary management. DBMS stores definitions of data elements and relationships (metadata) in a dictionary. DBMS looks up required data component structures and relationships. Changes automatically recorded in the dictionary. DBMS provides data abstraction and removes structural and data dependency.
Detailed explanation-2: -A Data Dictionary is a collection of names, definitions, and attributes about data elements that are being used or captured in a database, information system, or part of a research project.
Detailed explanation-3: -Data dictionaries store and communicate metadata about data in a database, a system, or data used by applications. A useful introduction to data dictionaries is provided in this video. Data dictionary contents can vary but typically include some or all of the following: A listing of data objects (names and definitions)
Detailed explanation-4: -A data dictionary is composed of data dictionary elements (DDEs) of which there are three types: Simple, Composite, and Collection elements. Simple DDEs are primitive elements such as strings, numbers, dates, and Boolean values that hold information such as a city name.
Detailed explanation-5: -A data dictionary contains metadata i.e data about the database. The data dictionary is very important as it contains information such as what is in the database, who is allowed to access it, where is the database physically stored etc.