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

 What is a database?

A database is information that is set up for easy access, management and updating.

(Lutkevich, B. (2023)

 USF Health Online (2022)

Types of databases include:                                                                                                                                                                          

1. Rotational 
2. NoSQL
3. Distributed 
4. Cloud 

(Lutkevich, B. (2023)

Advantages of database

• Data Abstraction
• Minimized data inconsistency
• Data manipulation easily
• Controlling data redundancy
• Data security
• Concurrent access 
• Support multi-users view

(Prashant, 2023)

Disadvantages of databases

• Cost of hardware and software
• Cost of data conversion 
• Cost of staff training 
• Data integrity 

AA((Prashant, 2023)

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?

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

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

Reference:

What is database theory? (2022) USF Health Online. Available at: https://www.usfhealthonline.com/resources/health-informatics/what-is-database-theory/ (Accessed: March 15, 2023).

Lutkevich, B. and Hughes, A. (2023) What is a database?: Definition from TechTarget, Data Management. TechTarget. Available at: https://www.techtarget.com/searchdatamanagement/definition/database (Accessed: March 15, 2023).

Prashant (2023) Advantages and disadvantages of DBMS, The Study Genius. Available at: https://www.thestudygenius.com/advantages-and-disadvantages-of-database/ (Accessed: March 15, 2023).