Entity
Name APPLICATION STAFF
Definition An Application Staff is the association of an individual to a particular application.

Attribute
Name Definition Datatype Required Is PK Is FK
Application Staff Identifier An Application Staff Identifier is a unique value that represents the intersection between the person in the organization and the application database that the individual is responsible for. INTEGER Yes Yes No
Application Identifier An Application Identifier is a unique value assigned to represent a particular software application. INTEGER No No Yes
Staff Identifier A Staff Identifier is a unique value assigned to represent a particular person within the organization. INTEGER Yes No Yes
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
Start Date An (Application Staff) Start Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff member became associated with a unique piece of software. DATE Yes No No
End Date An (Application Staff) End Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff memeber ceases to be associated with a unique piece of software. DATE No No No