Data Dictionary Form: Data Structure

System: BCA Business Management System

ID: D2

Name: Customer

Definition: Customer Information

Data Element Content:

Field Name / Data Type / Field Size / New Values / Required / Indexed
C_FName / Text / 50 / No / No
C_LName / Text / 50 / No / No
C_Address / Text / 255 / No / No
C_DOB / Date/Time / 50 / No / No
C_Company / Text / 50 / No / No
C_Work_Phone / Number / 50 / No / No
C_Mobile_Phone / Number / 50 / No / No
C_Emer_Contact_Name / Text / 50 / No / No
C_Emer_Contact_Phone / Number / 50 / No / No
Customer_ID / Number / 50 / Yes / No
Flight_ID / Number / 50 / Yes / No

Data Dictionary Form: Data Structure

System: BCA Business Management System

ID: D1

Name: Flight

Definition: Flight Information

Data Element Content:

Field Name / Data Type / Field Size / New Values / Required / Indexed
F_Start_City / Text / 50 / No / No
F_End_City / Text / 50 / No / No
F_Date / Date/Time / 50 / No / No
F_Time / Date/Time / 50 / No / No
F_Num_Customers / Number / 50 / No / No
Flight_ID / Number / 50 / Yes / No
User_ID / Number / 50 / No / No

Data Dictionary Form: Data Structure

System: BCA Business Management System

ID: D4

Name: Invoice

Definition: Invoice Information

Data Element Content:

Field Name / Data Type / Field Size / New Values / Required / Indexed
Payment_ID / Number / 50 / No / No
Flight_ID / Number / 50 / No / No
P_Amount / Currency / 50 / Yes / No
I_Booking_Date / Date/Time / 50 / No / No
Invoice_ID / Number / 50 / Yes / No

Data Dictionary Form: Data Structure

System: BCA Business Management System

ID: D3

Name: Payment

Definition: Payment Information

Data Element Content:

Field Name / Data Type / Field Size / New Values / Required / Indexed
CC_FName / Text / 50 / No / No
CC_LName / Text / 50 / No / No
CC_Address / Text / 255 / No / No
CC_Number / Number / 50 / No / No
CC_Exp_Date / Date/Time / 50 / No / No
CC_Type / Text / 50 / No / No
Flight_ID / Number / 50 / No / No
Payment_ID / Number / 50 / Yes / No
P_Amount / Currency / 50 / Yes / No