Person and Address tables using the personId column as the join key.firstName, lastName, city, and state columns to be included in the final result.city and state to be null.erDiagram
Person ||--o{ Address : has
Person {
int personId PK
varchar lastName
varchar firstName
}
Address {
int addressId PK
int personId FK
varchar city
varchar state
}