System assigned can’t exist without for the each Unique a corresponding vendor Numeric (10) vendor record Unit_ID Required-FK A contract record Unique identifier System assigned can’t exist without for the each unit Unique a corresponding Numeric (10) business unit record Programmer_ID Required-FK A contract record Unique identifier System assigned can’t exist without for the each Unique a corresponding programmer Numeric (10) programmer record Contact_ID Required-FK A contract record Unique identifier System assigned can’t exist without for the each Unique a corresponding contact Numeric (10) contact record User_ID Required-FK A contract record Unique identifier System assigned can’t exist without for the each user Unique a corresponding Numeric (10) user record Contract_Num The number Required assigned to this Unique contract Char (15) Start_Date The date the Required contract starts Non-unique Date: xx/xx/xxxx End_Date The date the Required contract ends Non-unique Date: xx/xx/xxxx Hourly_Rate The hourly rate of Required the contract Non-unique Currency Fee_Max The maximum fee Required for the contract Non-unique Currency Description Description of Required services to be Non-unique provided Notes Status Current status of Required the contract Non-unique Yes/No Charge_Unit Number assigned Required to the unit being Unique charged Look-up Exception_Detail Reason for Optional contract Look-up exception System Users User_ID Unique identifier Required PK for each user System assigned Unique Numeric (10) User_F_Name User’s first name Required Non-unique
for the each vendor System assigned Unique Numeric (10) can’t exist without a corresponding vendor record Unit_ID Unique identifier for the each unit Required-FK System assigned Unique Numeric (10) A contract record can’t exist without a corresponding business unit record Programmer_ID Unique identifier for the each programmer Required-FK System assigned Unique Numeric (10) A contract record can’t exist without a corresponding programmer record Contact_ID Unique identifier for the each contact Required-FK System assigned Unique Numeric (10) A contract record can’t exist without a corresponding contact record User_ID Unique identifier for the each user Required-FK System assigned Unique Numeric (10) A contract record can’t exist without a corresponding user record Contract_Num The number assigned to this contract Required Unique Char (15) Start_Date The date the contract starts Required Non-unique Date: xx/xx/xxxx End_Date The date the contract ends Required Non-unique Date: xx/xx/xxxx Hourly_Rate The hourly rate of the contract Required Non-unique Currency Fee_Max The maximum fee for the contract Required Non-unique Currency Description Description of services to be provided Required Non-unique Notes Status Current status of the contract Required Non-unique Yes/No Charge_Unit Number assigned to the unit being charged Required Unique Look-up Exception_Detail Reason for contract exception Optional Look-up System Users User_ID Unique identifier for each user Required System assigned Unique Numeric (10) PK User_F_Name User’s first name Required Non-unique
Systems%20Design%20Document%20(2)TA2_commented.docx