Write about your understanding of databases. Explore the database advantages and write about database concepts

 What is a database?

This is an organized collection of structured data typically stored electronically within a computer system.

(Khan, 2023)

(Martinez, 2017)

Examples of some types of databases include

1. Microsoft Access

2. SQL Server 

3. Oracle Database

(Khan, 2023)

Give some advantages of databases

• Minimum data redundancy.
• Improved data security.
• Increased consistency.
• Lower updating errors.
• Reduced costs of data entry, data storage, and data retrieval.
• Improved data access using host and query languages.
• Higher data integrity from application programs.

(Khan, 2023)

What are some disadvantages of databases?

• More Costly
• High Complexity
• Database Handling Staff Required
• Database Required

(Castro, No Date)

What are the 3 Main concepts of a relational database?

1. Tables

2. Keys (Primary and Foreign Keys)

3. Relationships

What is a primary and foreign key?

Primary Key - This is a special column in a database to uniquely identify a table record

Foreign Key - This is a column in a table which shows a link between two tables (This key is not unique and found in only one table)

References:

Khan, A. (2023) What is Database? Types, Examples and Advantages, Intellipaat Blog. Intellipaat. Available at: https://intellipaat.com/blog/what-is-database/ (Accessed: March 6, 2023).

Castro, K. (no date) Limitations of Database Management System, Tutorialspoint.com. Available at: https://www.tutorialspoint.com/Limitations-of-Database-Management-System (Accessed: March 6, 2023).

Martinez, F. (2017) Bad practices in database design: Are you making these mistakes?, Toptal Engineering Blog. Toptal. Available at: https://www.toptal.com/database/database-design-bad-practices (Accessed: March 6, 2023).