Entity
Name APPLICATION DATABASE
Definition An Application Database is the part of an application that is used to store data for a given piece of software or pieces of software for a particular set of related functions.

Attribute
Name Definition Datatype Required Is PK Is FK
Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER Yes Yes No
Application Identifier An Application Identifier is a unique value assigned to represent a particular software application. INTEGER Yes No Yes
Database Instance Name A Database Instance Name is the word or words by which a particular instance of an Application Database is known by. VARCHAR(50) Yes No No
Start Up Procedure Text A Start Up Procedure Text is the free form text that describes the steps necessary to bring up the database instance. VARCHAR(4000) No No No
Shut Down Procedure Text A Shut Down Procedure Text is the free form text that describes the steps necessary to bring down the database instance. VARCHAR(4000) No No No
Login Procedure Text A Login Procedure Text is the free form text that describes the steps necessary to log into the application database for a specific purpose, usually maintenance of some kind. VARCHAR(4000) No No No
Backup Procedure Text A Backup Procedure Text is the free form text that describes the steps necessary to backup the database. VARCHAR(4000) No No No
Environment Code An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. VARCHAR(10) Yes No Yes
Start Date A (Application Database) Start Date is the specific 24 hour period on the Gregorian calendar that the Application Database began operations. DATE Yes No No
End Date An (Application Database) End Date is the specific 24 hour period on the Gregorian Calendar that denotes when the Application Database ceased operations. DATE No No No
Tablespace Name
A Tablespace Name is the word or words by which a particular tablespace in the database is known.  Usually one or more is assigned to a specific database.
VARCHAR(50) No No No
Current Size Bytes Number A Current Size Bytes Number is the numeric value in bytes that shows the current size of the entire Application Database NUMBER(15,2) No No No
Service Level Agreement Code A Service Level Agreement Code is a specific alphanumeric code assigned to represent a particular response time to critical events and the timing of their resolution VARCHAR(10) Yes No Yes
Database Management System Identifier A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. INTEGER Yes No Yes
Application Database Status Code An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. VARCHAR(10) Yes No Yes