00:01
Hello student list the three design goals for the relational database and explain why these are desirable.
00:06
So three goals are data integrity, number two data, data consistency and number three data security.
00:14
So first is data integrity.
00:16
Data integrity refers to the accuracy, consistency and the reliability of the data stored in the database.
00:22
This is desirable goal for the relational database because it ensure that the data is correct and can be trusted for the decision making and analysis.
00:32
Data integrity can be achieved through various mechanisms such as data validations, referral integrity and normalizations.
00:40
So by maintaining data integrity a relational database can prevent data corruption, duplications, loss ultimately leading to the more efficient and effective data management.
00:51
So this is all about data integrity and data consistency.
00:55
Data consistency means that the data in a relational database is always presented in the uniform and coherent manners.
01:04
So regardless of how it is accessed and manipulated, this is desirable goal because it allows the user and the application to interact with the data in a predictable and reliable way...