exercise 21 database

 

(Mayo, 2022)

This blog will be going over five different things which are ; what is a database, advantages of a database , examples of a database, what are primary keys  and lastly what are secondary keys

Database is full of data which is carefully organised information. Database is where the data is being securely stored in.

The advantages of a database , one of the advantages of a database is that its an organised way to have your data stored which makes your life easier as you know where everything is. Another  advantage is that is a safe place for you to keep your data .

 Some examples of a database are ; FileMaker Pro, MySQL , Microsoft Access .

A primary key is unique column in a database  table , the primary key is used as a unique identifier.

A secondary key is  is  another key  thats used in addition to  locate specific data

Reference list

Ibm.com. 2022. IBM Docs. [online] Available at: <https://www.ibm.com/docs/en/tnpm/1.4.4?topic=administration-secondary-keys> [Accessed 22 February 2022].

Techopedia.com. 2022. What is a Primary Key? - Definition from Techopedia. [online] Available at: <https://www.techopedia.com/definition/5547/primary-key> [Accessed 22 February 2022].

GeeksforGeeks. 2022. Advantages of Database Management System - GeeksforGeeks. [online] Available at: <https://www.geeksforgeeks.org/advantages-of-database-management-system/> [Accessed 22 February 2022].

Oracle.com. 2022. What is a database?. [online] Available at: <https://www.oracle.com/uk/database/what-is-database/> [Accessed 22 February 2022].

Mayo, M., 2022. Database Key Terms, Explained - KDnuggets. [online] KDnuggets. Available at: <https://www.kdnuggets.com/2016/07/database-key-terms-explained.html> [Accessed 7 April 2022].