DATABASE FUNDAMENTALS
WHAT IS 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: -Types of Integrity Constraints. Integrity constraints in DBMS are used to ensure that data is consistent and accurate. There are four main types of integrity constraints: domain, entity, referential, and key.
Detailed explanation-3: -To ensure data accuracy, you must design a database that only stores relevant and valuable information. A well-designed database is essential to guarantee information consistency, eliminate redundant data, efficiently execute queries, and improve the database’s performance.
Detailed explanation-4: -Explanation: The answer is logical. The logical level describes the relationships between the data.