Conference Room Scheduler Installation Guide | Database Requirements |
Chapter 3 Database Requirements
Conference Room Scheduler requires three databases (i.e., Conference Room, Employee Identification, and Reservation). Two of these databases need to be constructed and thereafter maintained through the APM; the third database (i.e., Reservation) is built by Conference Room Scheduler itself while it is running. Databases are created through the Database Administration option on the APM System Administration Menu. Database creation involves the following
Step 1 – Create | Step 2 – Build |
| Step 3 – Create |
| Step 4 – Process | |
Master |
| Master |
| Application |
| Application |
|
| |||||
|
| |||||
Definition File | Database File |
| Definition File |
| Database | |
1.Create a Master Definition File: This step involves creating the master defini- tion file that defines the fields in the master database file. Generally one master definition file parents databases for several applications. Conference Room Scheduler, however, requires two separate sets of files, one for the conference room data and one for the employee identification data.
2.Build a Master Database File: This step involves entering data (e.g., confer- ence room numbers and number of people accommodated) into the master da- tabase fields that were just defined in Step 1.
3.Create an Application Definition File: In this step, a definition file is created which defines how data from the master files is to be converted to meet the needs of Conference Room Scheduler. The database names in the application configuration file (crminfofil and crmidfile) must be used for these definition file names.
4.Process the Application Database: In this step, the Master Database input is converted to database files according to the definitions created in Step 3, using the Process/Install Application Databases option on the APM Database Admin- istration menu. When the Process command is activated, data is drawn from the master database and converted to the formats specified in the corresponding ap- plication definition file. The Install command is then activated to enable Con- ference Room Scheduler to access the database.
Page 9 |