Entity
Name STAFF
Definition A Staff is an individual who works within the organization

Attribute
Name Definition Datatype Required Is PK Is FK
Staff Identifier A Staff Identifier is a unique value assigned to represent a particular person within the organization. INTEGER Yes Yes No
First Name A First Name is the word by which an individual is generaly known by VARCHAR(50) No No No
Last Name A Last Name is the word or words which makes up the last part of an individual's name. VARCHAR(50) No No No
Staff Role Code A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. VARCHAR(10) Yes No Yes
Work Telephone Number
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier.  This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
VARCHAR(14) No No No
Cell Telephone Number
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier.  This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
VARCHAR(14) No No No
Start Date A Start Date denotes the specific 24 hour period on the Gregorian calendar that an individual became a part of the Staff DATE Yes No No
End Date An End Date denotes the specific 24 hour period on the Gregorian calendar that an individual ceased to be an active member of the staff. DATE No No No
Team Code A Team Code is an alphanumeric representation of a particalur collection of Staff who either perform the same function or work on the same DBMS. VARCHAR(10) Yes No Yes
Enterprise Data Architecture Group Identifier An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group INTEGER Yes No Yes