Sylvia said:
I have to create a student database. There are students that live in the same
household. What do I do - to be able to update the information only one time
and those sisters and brothers information change as well?
You need two tables, one for the addresses, and one for the people. They
might look something like this:
addresses table:
address_id (primary key)
address_line_1
address_line_2
address_line_3
zip_code
people table:
person_id (primary key)
address_id
person_name
Note that the tables are related using the address_id. Note also that this
will significantly complicate your database. I have a great deal of
experience with names and addresses in Access databases, and in my opinion
the extra complexity is justified only for business addresses, where there
are often many people at the same address. For a database of residential
names/addresses, multiple people at one address is relatively rare, and the
additional complexity is unlikely to be justifiable.
