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?