Write about your understanding of databases. Explore the database advantages and write about database concepts such as primary and foreign keys

on

 Database:

A database is an organized collection of structured information, or data, typically stored 

electronically in a computer system. A database is usually controlled by a database management

 system (DBMS). Together, the data and the DBMS, along with the applications that are associated

 with them, are referred to as a database system, often shortened to just database.

Data within the most common types of databases in operation today is typically modeled in 

rows and columns in a series of tables to make processing and data querying efficient. The data

 can then be easily accessed, managed, modified, updated, controlled, and organized. Most

 databases use structured query language (SQL) for writing and querying data. 

(Cavell-Clarke, S. 2018) 


The advantages of database are :

1. Enhances data access (Sahana, 2021)


 Offshoreonlinedataentry.com


2. Improves data security (Sahana, 2021)

Archivistonline.Pk. 

3. Reduces data redundancy (Sahana, 2021)


Tiwari, R

4. Diminishes the number of errors and increases consistency (Sahana,2021)

Medhat, N.

5.Reduces operating costs (Sahana,2021)

Skevofilax, M.



Primary key
A primary key is a column or a set of columns in a table whose values uniquely identify a row
in the table. A relational database is designed to enforce the uniqueness of primary keys by
allowing only one row with a given primary key value in a table.(IBM documentation, 2021)

Foreign Key:
A foreign key is a column or a set of columns in a table whose values correspond to the 
values of the primary key in another table. In order to add a row with a given foreign key 
value,there must exist a row in the related table with the same primary key value.
(IBM documentation, 2021)












Reference:

Cavell-Clarke, S. (2018) What is a database? King’s Lynn, England: BookLife Publishing.

Sahana (2021) Advantages and disadvantages of database, Tech Quintal. Swalih. Available at: https://www.techquintal.com/advantages-and-disadvantages-of-database/ (Accessed: February 26, 2023).


IBM documentation (2021) Ibm.com. Available at: https://www.ibm.com/docs/en/ida/9.1.1?topic=entities-primary-foreign-keys (Accessed: February 26, 2023).

 
Offshoreonlinedataentry.com.  https://www.offshoreonlinedataentry.com/wp-content/uploads/2018/03/Tips-to-Enhance-Data-Accuracy-min.jpg(Accessed: February 26, 2023).

Archivistonline.Pk. https://www.archivistonline.pk/wp-content/uploads/2019/09/data-security-768x640.jpg (Accessed: February 26, 2023).

Tiwari, R. (2022, September 9). Ways to reduce Data Redundancy. DBSync Blogs. https://www.mydbsync.com/blogs/ways-to-reduce-data-redundancy/(Accessed: February 26, 2023).

Medhat, N. (2021, March 29). Understanding consistency - nerd for tech - medium. Nerd For Tech. https://medium.com/nerd-for-tech/understanding-consistency-37156d9f4608 (Accessed: February 26, 2023).


Skevofilax, M. (2011) How to reduce operating expenses in business, PORTAL CFO Consulting. Available at: https://portalcfo.com/how-to-reduce-operating-expenses-in-business/ (Accessed: February 26, 2023).






Comments

Post a Comment