each bank division Unique Char (25) Notes Notes_ID Unique identifier Required PK for each note System assigned Unique Numeric (10) Vendor_ID Unique identifier Required-FK A notes record for each vendor System assigned can’t exist without Unique a corresponding Numeric (10) vendor record Note_Date Date the note was Required created Non-unique Date: xx/xx/xxxx Vendor_Contact Vendor contract Required that the note Unique applies to Char (15) Resolve_Date Date the inquiry is Required resolved Non-unique Date: xx/xx/xxxx Inquiry_Detail Reason for the Required inquiry Non-unique Look-up Navigation Design:
each bank division Unique Char (25) Notes Notes_ID Unique identifier for each note Required System assigned Unique Numeric (10) PK Vendor_ID Unique identifier for each vendor Required-FK System assigned Unique Numeric (10) A notes record can’t exist without a corresponding vendor record Note_Date Date the note was created Required Non-unique Date: xx/xx/xxxx Vendor_Contact Vendor contract that the note applies to Required Unique Char (15) Resolve_Date Date the inquiry is resolved Required Non-unique Date: xx/xx/xxxx Inquiry_Detail Reason for the inquiry Required Non-unique Look-up Navigation Design:
Systems%20Design%20Document%20(2)TA2_commented.docx