System Fundamentals

Is a software system for creating and managing databases

Refers to a set of connected data accessed through a Database Management System(DBMS), which is a software that allows users to interact with one or more databases

Is a method of organizing data into tables, rows, and columns to show relationship between data points.

• RELATIONAL DATABASES (STRUCTURED QUERY LANGUAGE )

• NoSQL DATABASES (not only SQL)

• DATABASE DESIGN

• NORMALIZATION

This structure makes it straightforward to access, create, read, modify, and delete data using a querying languages.

• RELATIONAL DATABASES (STRUCTURED QUERY LANGUAGE )

• NoSQL DATABASES (not only SQL)

• DATABASE DESIGN

• NORMALIZATION

It useful when working with large or fast moving data that may not fit neatly into a table.

• RELATIONAL DATABASES (STRUCTURED QUERY LANGUAGE )

• NoSQL DATABASES (not only SQL)

• DATABASE DESIGN

• NORMALIZATION

Refers to the process of organizing and structuring data in a way that allows for efficient storage, retrieval, and management.

• RELATIONAL DATABASES (STRUCTURED QUERY LANGUAGE )

• NoSQL DATABASES (not only SQL)

• DATABASE DESIGN

• NORMALIZATION

It involves creating a blueprint for how data is stored in a database system and how the different data elements relate to each other.

• RELATIONAL DATABASES (STRUCTURED QUERY LANGUAGE )

• NoSQL DATABASES (not only SQL)

• DATABASE DESIGN

• NORMALIZATION

Is a technique used in database design to organize data in a way that minimizes redundancy and dependency.

• RELATIONAL DATABASES (STRUCTURED QUERY LANGUAGE )

• NoSQL DATABASES (not only SQL)

• DATABASE DESIGN

• NORMALIZATION

Is a critical process in data management its the method of requesting specific information from a database.

Involves modifying the data stored in a database. This includes actions like adding new data, changing existing data, or removing data.