so i'm still in the design phase of this database. Anyways, every person, whose PK is their name, has a FK to a contact table then I'm very confused as to what's next as every contact table contains a reference to the address table. Person -> Contact -> address Tables contain as follows:
Person: PK | name contact info references contact table (?) contact: PK | address(?) email Address: PK | street name (?)
First Question: What would be the PK for my contact table? Second question: What would be the PK for my address table? Would it even have a PK or is it just referenced?
Essentially one person would have one entry into the contact table, then in the contact table it references the address table and I'm just trying to figure out the best way to do that.