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

 Database and Database Concepts 

A database is a collection of data that is organised and stored in a structured way, with different types of databases existing to suit different types of data and data handling requirements. Databases are often used as a way of providing quick and efficient access to data, allowing large amounts of data to be stored and retrieved quickly and easily.

Database Advantages :

- Databases provide better data security than traditional systems. This is because databases are designed to protect data from unauthorized access, meaning only those with access privileges can view the data.

- Databases make it easier to retrieve and manipulate data. This is because databases are organized in a structured way, making it easier to search for specific information.

- Databases improve data accuracy. This is because databases use data validation techniques to make sure that the data entered is correct.

- Databases improve access control. This is because databases provide users with the ability to set different levels of access for different users.

• Primary Keys: A primary key is a field or combination of fields in a table which uniquely identifies each row/record in a database table. It is a unique identifier and can’t be null (empty). It is also immutable, meaning it can't be changed or modified. It is used to reference other tables and can be used to create relationships between different tables (Meyer, 2017).

• Foreign Keys: A foreign key is a field or combination of fields in a table which uniquely identifies a row/record in another table. It is used to create a link between two tables and is used to reference data in another table (Meyer, 2017).

Reference :

- Fowler, M., 2017. Understanding Database Basics. [online] Available at: <https://www.mssqltips.com/sqlservertutorial/170/understanding-database-basics/> [Accessed 12 June 2020].

- Meyer, G. (2017). What are primary and foreign keys in a database?. Retrieved from https://www.techopedia.com/definition/25186/primary-key-database-primary-key

- Kumar, P. & Deo, D. (2016). Advantages and Disadvantages of Database Management System. Retrieved from https://www.slideserve.com/neha/advantages-and-disadvantages-of-database-management-system