| Questions |
 |
|
| Answers |
|
|
| What refers to the method of presenting data contained in a table using rows to represent records and columns to represent the fields containing the attributes |
Datasheet format |
| What makes a relational database different from other database systems |
The establishment of relationships between the tables contained in the database |
| If you are having trouble with MDS rejecting an attribute value you are trying to input, what could be the cause |
A referential integrity rule |
| What is the key to understanding the MDS |
Understanding the attributes (data elements) and structure of MDS |
| What are the two sides of the MDS network |
Server and client |
| What interface allows HQ AETC to match instructor requirements to training needs |
TPS (Training Planning System) |
| What owner name is assigned to Air Force common tables within MDS |
QFMD |
| What record is established in the current active peacetime and authorization requirements (CURR_RQMNT_AUTH) table if the position is sourced |
Authorization record |
| What code identifies the function to which a manpower requirement belongs |
Functional account code (FAC) |
| What code identifies a manpower requirement as wartime execution, authorization, peace time, wartime plan, or contract man-year equivalent (CME) |
Manpower type |
| What code identifies the organization to which a manpower requirement belongs |
System management menu |
| What MDS screen do you use to view manpower data or produce the UMD |
Extended unit manpower document |
| What function under the project menu in MDS do you use to create a manpower project to add, change, and delete manpower requirements |
Manpower |
| What menu option do ou use to unlock a locked manpower project |
System management menu |
| Which type of UMD would you request if you needed all the information on the manpower requirements in the report |
Extended unit manpower document |
| In what two sequences can you request the UMD to be produced |
Functional account code (FAC) and organization structure code (OSC) |
| What does the select statement printed on the UMD represent |
A statement in special query language (SQL) created to esablish the criteria for selecting the manpower requirements to include in the report |
| At what level is an ACR initiated |
At any level |
| What is the most critical step in the ACR process |
Evaluating the authorization change request (ACR) |
| Why do you coordinate ACR actions involving civilian positions with the servicing Civilian Personnel Office (CPO) |
To avoid an adverse impact to the incumbent |
| What office is responsible for approving and implementing manpower projects |
MAJCOM MO office |
| What is the fundamental structure of a relational database system |
Tables |
| What is used to distinguish records contained in the same table from one another |
Primary key |
| What is the most common relationship used in a relational database |
One-to-many |
| What is the most importand data in the Manpower Data System (MDS) |
Unit authorization data |
| How may database servers are used in the Manpower Data System (MDS) network |
7 |
| What interfaces provide organizational data to the Manpower Data System (MDS) |
Personnel Accounting Symbol (PAS) |
| What Major Command (MAC) attributes is the one most often used in reports |
Owning |
| What attributes classifies a manpower requirement record as Wartime Execution, Authorization, Peacetime, Wartime Plan, and Contract Man-year Equivalent (CME) |
Manpower Requirement Type (Manpower Type) |
| What menu would you use to change the Major Command (MAC) you are working on |
File menu |
| What menu would you use to create a Unit Manpower Document (UMD) |
Manpower Data System (MDS) data menu |
| What Unit Manpower Document (UMD) sequence s optional and is primarily used to apply manpower standards |
Functional Account Code (FAC) |
| On the Unit Manpower Document (UMD), what is the sequence of requirement records within each Functional Account Code (FAC) and Organizational Structure Code (OSC) |
Personnel Accounting Symbol (PAS) |
| At what level is an Authorization Change Request (ACR) initiated |
At any level |
| What is the most critical step in the Authoriztion Change Request (ACR) process |
Evaluation |
| What agencies do you submit your manpower project to for approval |
Major Command |
| What is the first thing you should accomplish upon receipt of an Authorization Change Notice (ACN) |
Check for errors |
