Force Platform Fundamentals: An Introduction to Custom Application Development in the Cloud

What’s a Relational Database?

Now you have some information stored in your database, but so what? You could easily make a list of positions using Microsoft Excel or some other spreadsheet software. For each position, you could even list the hiring manager in a field called Hiring Manager, like this:

Figure 8. Position Information with Hiring Manager Field

[View full size image]

But what if a hiring manager is responsible for hiring more than one position? You would need to have duplicate records for the same hiring manager so you could capture every position for which that hiring manager is responsible, like this:

Figure 9. Position Information ...