Understanding of Databases, Advantages of Databases, and Primary/Foreign Keys

 By: Stanley Yun Kai Fok

On this page, I will write about my understanding of databases, the advantages of the database, and discuss primary and foreign keys. 

(fullvector, 2018)

In my own words and understanding, generally, a database is a form of structure that allows the storage of vital information online. 

According to Intellipaat,

The advantages of databases include the following: 

• Minimum data redundancy

• Improved data security

• Increased consistency

• Lower updating errors

• Reduced costs of data entry, data storage, and data retrieval

• Improved data access using host and query languages

• Higher data integrity from application programs

(Intellipaat Blog, 2023)

What are primary and foreign keys?

-A primary key is a term used to specify the unique identity of a table making the value in the column created and not borrowed.

-On the other hand, a foreign key is a term used to label a column that has been borrowed to form relationships between tables.

(BYJUS, 2022)

Reference(s):

BYJUS (2022) Difference between Primary Key and Foreign Key. Available at: https://byjus.com/gate/difference-between-primary-key-and-foreign-key/ (Accessed: February 27, 2023).

Intellipaat Blog (2023) What is Database? Types, Examples and Advantages. Available at: https://intellipaat.com/blog/what-is-database/ (Accessed: February 27, 2023).

fullvector (2018) Server room, cloud storage icon, datacenter and database concept, data exchange process. Available at: https://www.freepik.com/free-vector/server-room-cloud-storage-icon-datacenter-database-concept-data-exchange-process_3628676.htm (Accessed: March 13, 2023).