CLOUD COMPUTING
DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Focuses on the design of the database structure that will be used to store and manage end-user data
|
|
|
Poorly designed database causes difficult-to-trace errors
|
|
|
Facilitates data management
|
|
|
Generates accurate and valuable information
|
Detailed explanation-1: -Third option is Correct. Explanation: There are three different types of data relationships in a database: one-to-one relationship: It is defined as the relationship between two tables where a row from table A is associated with at most one row in table B, and an row in table B is associated with one entity in table A.
Detailed explanation-2: -A good database design is, therefore, one that: Divides your information into subject-based tables to reduce redundant data. Provides Access with the information it requires to join the information in the tables together as needed. Helps support and ensure the accuracy and integrity of your information.
Detailed explanation-3: -Data Integrity Data integrity means data is consistent and accurate in the database. It is essential as there are multiple databases in DBMS. All these databases contain data which is visible to multiple users.
Detailed explanation-4: -A database management system must include concurrency control subsystems. This feature ensures that data remains consistent and valid during transaction processing even if several users update the same information.