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

(Martinez, 2022)

A database in computing is a structured collection of data that is electronically accessible and stored. Large databases are housed on computer clusters or cloud storage, whilst small databases can be kept on a file system. Data modelling, effective data representation and storage, query languages, security and privacy of sensitive data, and distributed computing challenges, such as providing concurrent access and fault tolerance, are all part of the design of databases.

To guarantee that the data in a given column is unique, a primary key is employed. There can be no NULL values in this column. It is either a column from an existing table or one that the database specially creates using a predetermined sequence.

A relational database table's foreign key is a column or set of columns that create a connection between the data in two tables. It is a column (or columns) that refers to a column in another table, often the primary key.(EL-kariouny, 2022)

References

EL-kariouny, M., 2022. What is a Database? Definition, Meaning, Types, Example. [online] DEV Community 👩‍💻👨‍💻. Available at: <https://dev.to/mahmoudessam/what-is-a-database-definition-meaning-types-example-4nhp> [Accessed 8 September 2022].

Martinez, F., 2022. Bad Practices in Database Design: Are You Making These Mistakes?. [online] Toptal Engineering Blog. Available at: <https://www.toptal.com/database/database-design-bad-practices> [Accessed 8 September 2022].