Char (15) User_L_Name User’s last name Required Non-unique Char (15) User_logon_ID User’s logon ID Required Unique Char (10) User_Password User’s password Required Unique Char (10) User_Auth_Level Authorization level Required for the user Non-unique Look-up Bank Contact_ID Unique identifier Required PK for each contact System assigned Contacts Unique Numeric (10) Unit_ID Unique identifier Required-FK A bank contacts for each business System assigned record can’t exist unit Unique without a Numeric (10) corresponding business unit record Contact_F_Name Contact’s first Required name Non-unique Char (15) Contact_L_Name Contact’s last Required name Non-unique Char (15) Contact_Phone Contact’s phone Required number Unique Char (10) Contact_Email Contact’s email Optional address Business Unit_ID Unique identifier Required PK for each business System assigned Units unit Unique Numeric (10) Division_ID Unique identifier Required-FK A business units for each bank System assigned record can’t exist division Unique without a Numeric (10) corresponding bank division record Unit_Number Number assigned Required to each business Unique unit Char (15) Bank Division_ID Unique identifier Required PK for each bank System assigned Divisions division Unique Numeric (10) Bank_Division Name assigned to Required
Char (15) User_L_Name User’s last name Required Non-unique Char (15) User_logon_ID User’s logon ID Required Unique Char (10) User_Password User’s password Required Unique Char (10) User_Auth_Level Authorization level for the user Required Non-unique Look-up Bank Contacts Contact_ID Unique identifier for each contact Required System assigned Unique Numeric (10) PK Unit_ID Unique identifier for each business unit Required-FK System assigned Unique Numeric (10) A bank contacts record can’t exist without a corresponding business unit record Contact_F_Name Contact’s first name Required Non-unique Char (15) Contact_L_Name Contact’s last name Required Non-unique Char (15) Contact_Phone Contact’s phone number Required Unique Char (10) Contact_Email Contact’s email address Optional Business Units Unit_ID Unique identifier for each business unit Required System assigned Unique Numeric (10) PK Division_ID Unique identifier for each bank division Required-FK System assigned Unique Numeric (10) A business units record can’t exist without a corresponding bank division record Unit_Number Number assigned to each business unit Required Unique Char (15) Bank Divisions Division_ID Unique identifier for each bank division Required System assigned Unique Numeric (10) PK Bank_Division Name assigned to Required
Systems%20Design%20Document%20(2)TA2_commented.docx