WRITE ABOUT YOUR UNDERSTANDING OF DATABASES. EXPLORE THE DATABASE ADVANTAGES AND WRITE ABOUT DATABASE CONCEPTS SUCH AS PRIMARY AND FOREIGN KEYS

                                                                          (`Curator, C.,2023)

A database is a structured collection of information or data that is typically stored electronically in a computer system. A database management system (DBMS) controls the database, along with the associated applications, and together they form a database system. The data in most databases are organized into tables with rows and columns, allowing for efficient processing and querying. This structured data can be easily managed, modified, updated, controlled, and organized. SQL is the most common language used for querying and writing data in databases.

Advantage 
These include the following:

Further developed information sharing: The use of a database administration approach has the advantage of improving end-user access to well-managed data. With the help of a database management system (DBMS), users can access more and higher quality data, enabling them to respond quickly to changes in their environment.

Further developed information security: As the number of users accessing corporate data increases, so do the risks of data security breaches. To ensure that data is used properly, organizations invest significant amounts of time, effort, and money in maintaining data security. A DBMS provides a framework for enforcing data privacy and security policies, thereby improving data protection.

Better information reconciliation: Improved access to well-managed data promotes an integrated view of an organization's operations, providing a clearer understanding of the big picture. With a database system, it becomes easier to see how activities in one part of the organization impact other areas, leading to better decision-making and a more coordinated approach to operations.


Limited information irregularity: Data inconsistency occurs when different versions of the same data appear in multiple locations. For example, data inconsistency can arise when an organization's outreach team stores a salesman's name as "Bill Brown," but the staff at the company's retail stores refers to the same person as "William G. Brown." Similarly, if the local sales office displays the price of a product as $45.95, but the national sales office lists the same product's price as $43.95, this creates data inconsistency. Properly designed databases can greatly reduce the likelihood of data inconsistency.

Further developed independent direction: Improved management of data and better access to it allow for the production of higher quality data, which in turn leads to better decision-making. The quality of the data produced depends on the quality of the underlying data. Data quality is an approach aimed at promoting the accuracy, validity, and timeliness of data. While a DBMS does not guarantee data quality, it provides a framework for working with data quality initiatives.

Expanded end-client efficiency: The combination of data accessibility and tools that convert data into useful information enables end-users to make informed decisions quickly. These decisions can make the difference between success and failure in the global economy.

Component

A primary key is a column or a group of columns in a database table that ensures that every row is unique and can be easily identified. It is used to uniquely identify each row in the table and must contain only unique values. Additionally, primary keys cannot contain NULL values, meaning that every row must have a value in the primary key column(s). The primary key is used to enforce data integrity and to create relationships between tables.

A foreign key is a column or a set of columns in a database table that creates a relationship between two separate tables. Its primary purpose is to maintain data consistency and integrity between related tables. When a foreign key is created, it refers to the primary key in another table, establishing a connection between the two tables. This relationship ensures that any data added or modified in one table must correspond to the data in the related table. Thus, foreign keys help maintain data consistency and prevent the insertion of invalid data into the tables, enforcing referential integrity.

Here are the Differences between Foreign Keys and Primary keys

REFERENCES

Admin (2022) Difference between primary key and foreign key, BYJUS. BYJU'S. Available at: https://byjus.com/gate/difference-between-primary-key-and-foreign-key/#:~:text=1-,A%20primary%20key%20generally%20focuses%20on%20the%20uniqueness%20of%20the,relationship%20between%20the%20two%20tables. (Accessed: March 15, 2023).

Curator, C. (no date) What is database management, C# Corner. Available at: https://www.c-sharpcorner.com/article/what-is-database-management/ (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: March 15, 2023).

What is a database? (no date) What Is a Database | Oracle United Kingdom. Available at: https://www.oracle.com/uk/database/what-is-database/ (Accessed: March 15, 2023).