To transform an ER model into a dimensional model, you need to understand the difference between different types of attributes and distinguish them in your design.

Please identify the most accurate attribute types of the individual attributes in the tables below:

AgentID

Full Name

Last Name

Email

OfficeID

$1$

Ean

Monroe

EM@company.com

$001$

$2$

Bailey

Conway

BC@company.com

$002$

$3$

Hana

Huffman

HH@company.com

$003$

$...$

$...$

$...$

$...$

$34$

Graham

Gomez

GG@company.com

$001$

$35$

Rey

Wilson

RW@company.com

$004$

$...$

$...$

$...$

$...$

OfficeID

Office$\_$Name

Postal code

Phone number

$001$

Toowong

$4066$

$(70)300$

$002$

Indooropilly A

$4068$

$(70)301$

$003$

Indooropilly B

$4068$

NULL

$...$

$...$

$...$

$...$

$-$

AgentID

$-$

Email

$-$

OfficeID

$-$

First Name

$-$

Last Name

$-$

Office$\_$name

$-$

Postal code

$-$

Phone Number

$1.$

Primary Key

$2.$

Attribute

$3.$

Candidate Key