Storing multiple values for a single field in a database
database, database-design, oracle, sql
Solution
You're supposed to create an `ADDRESS` table that has a foreign key linking it to a `PERSON` record, i.e. `PERSON_ID`. This is the "relational" component of a relational database, and it's why it's more flexible than a flat file (which is like a single table).
Problem
Suppose i have a table with 3 fields Person_id, Name and address. Now the problem is that a person can have multiple addresses. and the principle of atomic values says that data should be atomic. So then how am i suppose to store multiple addresses for a single person ?