Database - Definitions

     A database is a collection of interrelated data stored in the memory of computers and used by the application programs of an institution or organization, together with software that allows defining, using and modifying this data (Oracle, 2023).

    A database management system (DBSM) is a software or computer system designed to manage a database. Database management systems allow the manipulation and updating of data stored in computer systems (Oracle, 2023).

    Primary and foreign keys - Primary Key, is a column or set of columns that uniquely defines a row in a table. A foreign key is a column or set of columns that is the primary key in another table. You can say that a foreign key is a copy of the primary key from another table (IBM, 2021).

Reference

IBM (2021) Primary and foreign keys. Available at: https://www.ibm.com/docs/en/ida/9.1.1?topic=entities-primary-foreign-keys (Accessed: 13 March 2023)

Oracle (2023) What Is a Database?. Available at: https://www.oracle.com/uk/database/what-is-database/ (Accessed: 14 March 2021).