Data & Databases
Relational database
A database that stores structured data in tables connected by defined relationships.
Example
Orders and customers live in related tables connected by customer IDs.
Why it matters
It helps keep related business information consistent without repeating it everywhere.
You'll hear it
“That order should link to this customer record.”
Can you control it?
Set by the team
The people building or running the AI choose this setup. An everyday user generally needs their help to change how this part works.
Common questions
- Does a table relationship prove the real-world connection is correct?
- No. Incorrect identifiers can link the wrong records.
- Can missing related records cause problems?
- Yes. Applications need rules for incomplete or removed relationships.
- Must every question read only one table?
- No. Queries can combine information from several connected tables.