Entity
Name APPLICATION
Definition An Application is a piece or multiple pieces of software that have been coupled together for a specific purpose.

Attribute
Name Definition Datatype Required Is PK Is FK
Application Identifier An Application Identifier is a unique value assigned to represent a particular software application. INTEGER Yes Yes No
Application Name An Application Name is the word or words by which a particular piece of software is known. VARCHAR(50) Yes No No
Application Description An Application Description is the free form description that further clarifies or defines a piece of software VARCHAR(150) Yes No No
Start Date A Start Date is the specific 24 hour period on the Gregorian calendar that denotes when the application began active use. DATE Yes No No
End Date An End Date is the specific 24 hour period on the Gregorian calendar that denotes when the application ceased to be used. DATE No No No