| 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 |
