Vendors (Vendor_ID, Vendor_Address, Vendor_City, Vendor_Zip, Vendor_Phone, Vendor_Email Notes (Notes_ID, Vendor_ID, Note_Date, Vendor_Contact, Resolve_Date, Inquiry_Detail Bank Divisions (Division_ID, Bank_Divisions Invoices (Invoice_ID, Vendor_ID, Programmer_ID, Contract_ID, User_ID, Invoice_Number, Invoice_Date, Total_Hours, Invoice_Total, Hourly_Rate, Invoice_Start_Date, Invoice_End_Date, Status, Due_Date, PO_Number, Description, Date_Paid, Exception_Detail, Accrued Contracts (Contract_ID, Vendor_ID, Unit_ID, Programmer_ID, Contact_ID, User_ID, Contract_Num, Start_Date, End_Date, Hourly_Rate, Fee_Max, Description, Status, Charge_Unit, Exception_Detail Business Units (Unit_ID, Division_ID, Unit_Number Programmers (Programmer_ID, Vendor_ID, Prog_F_Name, Prog_L_Name, Prog_Phone, Prog_Email System Users (User_ID, User_F_Name, User_L_Name, User_Logon_ID, User_Password, User_Auth_Level Bank Contacts (Contact_ID, Unit_ID, Contact_F_Name, Contact_L_Name, Contact_Phone, Contact_Email These entities, attributes and their relationships are shown in more detail in the Entity Relationship Diagram They are shown with their definitions, domain constraints, and referential integrity constraints in the Metadata Dictionary User Navigation Design (Storyboard) Bank of Xanadu Programming Contract Accounting System was created for the accounting department. Superior I.T. System Solutions has decided on simplicity and a friendly graphic user interface was a necessary component for the overall success of the system. Each menu is easy to navigate from one screen to another. Within the appendix is a visual depiction of the
Vendors (Vendor_ID, Vendor_Address, Vendor_City, Vendor_Zip, Vendor_Phone, Vendor_Email Notes (Notes_ID, Vendor_ID, Note_Date, Vendor_Contact, Resolve_Date, Inquiry_Detail Bank Divisions (Division_ID, Bank_Divisions Invoices (Invoice_ID, Vendor_ID, Programmer_ID, Contract_ID, User_ID, Invoice_Number, Invoice_Date, Total_Hours, Invoice_Total, Hourly_Rate, Invoice_Start_Date, Invoice_End_Date, Status, Due_Date, PO_Number, Description, Date_Paid, Exception_Detail, Accrued Contracts (Contract_ID, Vendor_ID, Unit_ID, Programmer_ID, Contact_ID, User_ID, Contract_Num, Start_Date, End_Date, Hourly_Rate, Fee_Max, Description, Status, Charge_Unit, Exception_Detail Business Units (Unit_ID, Division_ID, Unit_Number Programmers (Programmer_ID, Vendor_ID, Prog_F_Name, Prog_L_Name, Prog_Phone, Prog_Email System Users (User_ID, User_F_Name, User_L_Name, User_Logon_ID, User_Password, User_Auth_Level Bank Contacts (Contact_ID, Unit_ID, Contact_F_Name, Contact_L_Name, Contact_Phone, Contact_Email These entities, attributes and their relationships are shown in more detail in the Entity Relationship Diagram They are shown with their definitions, domain constraints, and referential integrity constraints in the Metadata Dictionary User Navigation Design (Storyboard) Bank of Xanadu Programming Contract Accounting System was created for the accounting department. Superior I.T. System Solutions has decided on simplicity and a friendly graphic user interface was a necessary component for the overall success of the system. Each menu is easy to navigate from one screen to another. Within the appendix is a visual depiction of the
Systems%20Design%20Document%20(2)TA2_commented.docx