For proper data storage and processing, an effective data management is required.This particular learning path will introduce you to certain key concepts in Data management for effective data storage and processing as shown below:
This learning path which also focuses on relational data model will start with the constituents of database: Data, Data sets, Database(DB), Database Management System(DBMS), and Database systems. Our first item for discussion is the term "Data".
The subsequent term for our evaluation is "Database".
We will then look at Database Management System (DBMS) thus a designed software package for managing data sets.
Relational Data Model which is integral in this learning path is the next concept we will be looking at; as an important event in the history of the database field based on predicate logic and set theory and using Structured Query Language (SQL).
The next concept we will be looking at in this learning path is SQL which allows us to perform "spatial querying" or explore spatial relationships.
In this regard, we now then have a critical look at the elements of Data Structuring Primitives such as " Attributes", "Tuples", and "Relations". The first of such elements for our consideration here is "Attribute".
The next element we shall look at in this learning path is "Domain" which refers to data type.
The next element of Data Structuring primitives we will be having a look at is "Tuple", which sometimes refers to as "Record"or "Row".
The last element of Data Structuring primitives that we will look at in this learning path is the "Relation" which sometimes known as "Table". This is also splits into parts such as "Relational Schema"; "Relational Instance"; "Data Schema"; and "Relational Database".
The next item we will be looking at in this learning path is the "Relational Database" which deals with database based on relations and denotes a collection of relations structured to recognize relations between stored items of information.
This now takes us to the concept of "Keys" which can be divided into: "Primary Key"and "Foreign Key".