Relational databases are used in many large websites to quickly sort through information.
In this case, the amount of information is more easily managable;
when dealing with larger amounts, however,
relational databases can be quite useful for organization.
Below are the tables for which you can search
for information from further down:
id | firstname | lastname | annual_salary | date_first_employed |
---|---|---|---|---|
1 | Alan | White | 100000 | 2004-09-03 | 2 | Jake | Michaels | 80000 | 2007-11-18 |
3 | Jessica | Stirling | 120000 | 1999-03-28 |
4 | Jim | Schmim | 60000 | 2012-05-17 |
contact_id | email_address | home_phone_number | emergency_phone_number |
---|---|---|---|
Alan W. | Alan@mail.com | 650-939-8504 | 650-249-7128 |
Jake M. | Jake@mail.com | 650-421-7730 | 650-855-2217 |
Jessica S. | Jessica@mail.com | 650-419-2350 | 650-273-8530 |
Jim S. | Jim@mail.com | 650-769-8230 | 650-289-6530 |
The tables above are linked by this following table:
id | contact_id |
---|---|
1 | Alan W. |
2 | Jake M. |
3 | Jessica S. |
4 | Jim S. |
The following fields can be used to search for information
found in the tables above: