I Googled the definition online, and I asked some friends, but it is still not clear. Could someone please tell me what a relational database is specifically?
Hello @pabloramosescalona ,
Most simply explained, a relational database has data organized into tables connected to each other through a common data element. In each table, there are rows and columns of data.
An example of tables and it’s columns:
Columns: Customer Id, Customer Address, City, State, Country
Columns: Order Id, Order Number, Order Date, Customer Id
To access the customer data and order data, you would
join these two tables using the
Maybe, it helps to understand the other other types of databases.
What do you mean by a “common data element”? The header of the table?
Juan P. Ramos.
It could be one or more columns that are the same between the tables. In the example above, the
CUSTOMER ID is the same between the two tables.
Thank you so much! You are awesome!