ADVANTAGES OF DATABASE.
Data consistency
The existence of data redundancy is avoided in a database to achieve data consistency. This means that all data is uniform throughout the database and is identical for all users who access it. Additionally, any alterations made to the database are promptly applied to all users, preventing any discrepancies in the data (kristi,2020).
Data Security
Ensuring data security is a crucial aspect of managing a database. Access to the database should only be granted to authorized users who can authenticate their identity through a username and password. Any attempt by unauthorized users to access the database should be prevented, as it would compromise the integrity constraints (kristi,2020).
Privacy
In a database, the principle of privacy dictates that access should only be granted to authorized users in accordance with the established privacy constraints. The level of access to the database is restricted, meaning that users can only view data that they are authorized to see. For instance, on social networking sites, the access constraints for different accounts may vary, depending on the user's privileges (kristi,2020).
Robust backup and recovery
One major challenge for businesses is the possibility of data loss. Traditional file systems require manual backups of data, which can be a time-consuming process, particularly for large amounts of data. To address this issue, the use of DBMS has become increasingly popular. DBMSs are equipped with powerful software that enables automatic backup and recovery of the database in the event of failures. By following preset schedules, they can ensure automatic backup for all of your data, thereby reducing the risk of data loss (Valcheva, 2020).
No Redundant Data
One of the key benefits of database is the removal of redundancy in data storage. By eliminating data duplication, storage space is saved, and access times are improved. Instead of having multiple copies of the same data for each user in a company, database enables centralized storage for all data, making storage space more efficient (Valcheva, 2020)..
PRIMARY KEY
A primary key is a column or a combination of columns that serves as a unique identifier for each record in the table. Its primary purpose is to facilitate fast and efficient data retrieval from the table. It is important to note that a table can only have one primary key (Rabelo,2020).
The main characteristics of a primary key are as follows:
- It must have a distinct value for each record in the table.
- It cannot contain null values.
- Each record in the table must have a primary key value.
A foreign key is a column or a set of columns that establishes a connection between two tables by referencing the primary key of another table. This cross-reference enables the data to be linked between the tables. The majority of tables in a relational database system use the foreign key concept. In large and intricate databases or data warehouses, data must be stored across multiple tables while maintaining their relationships. The principle of referential integrity is built upon the theory of foreign keys (Rabelo,2020).
Referencing
Foreign key in DBMS - javatpoint (no date) www.javatpoint.com. Available at: https://www.javatpoint.com/foreign-key-in-dbms (Accessed: March 15, 2023).
Ram (2022) Advantages and disadvantages of database: What are the advantages and disadvantages of database?, NCERT Books. Available at: https://www.ncertbooks.guru/advantages-and-disadvantages-of-database/ (Accessed: February 28, 2023).
Rabelo, J. (no date) What is a primary key? - definition from Techopedia, Techopedia.com. Available at: https://www.techopedia.com/definition/5547/primary-key (Accessed: March 15, 2023).
Rabelo, J. (no date) What is a foreign key? - definition from Techopedia, Techopedia.com. Available at: https://www.techopedia.com/definition/7272/foreign-key (Accessed: March 15, 2023).
Valcheva, S. (2020) Database: Meaning, advantages, and disadvantages, Blog For Data-Driven Business. Available at: https://www.intellspot.com/database-meaning/ (Accessed: February 28, 2023).
Yasar, K. (2022) What is a primary key? - definition from whatis.com, Data Management. TechTarget. Available at: https://www.techtarget.com/searchdatamanagement/definition/primary-key (Accessed: March 15, 2023).
Comments
Post a Comment