Entity Name Attribute Definition Domain Referential Name Constraints Integrity Constraints Vendors Vendor_ID Unique identifier Required PK for each vendor System assigned Unique Numeric (10) Vendor_Name Vendor name Required Non-unique Char (25) Vendor_Address Vendor’s street Required address Unique Char (25) Vendor_City City the vendor is Required located in Non-unique Char (25) Vendor_State State the vendor Required is located in Non-unique Look-up Vendor_Zip Vendor’s zip code Required Non-unique Char (5) Vendor_Phone Vendor’s phone Required number Unique Char (10) Vendor_Email Vendor’s email Optional address Programmers Programmer_ID Unique identifier Required PK for each System assigned programmer Unique Numeric (10) Vendor_ID Unique identifier Required-FK Programmer for each vendor System assigned record can’t exist Unique without a Numeric (10) corresponding vendor record Prog_F_Name Programmer’s first Required name Non-unique Char (15) Prog_L_Name Programmer’s last Required name Non-unique Char (15) Prog_Phone Programmer’s Required phone number Unique Char (10) Prog_Email Programmer’s Optional email address Invoices Invoice_ID Unique identifier Required PK for each invoice System assigned Unique Numeric (10) Vendor_ID Unique identifier Required-FK Invoice record for each vendor System assigned can’t exist without Unique a corresponding Numeric (10) vendor record
Entity Name Attribute Name Definition Domain Constraints Referential Integrity Constraints Vendors Vendor_ID Unique identifier for each vendor Required System assigned Unique Numeric (10) PK Vendor_Name Vendor name Required Non-unique Char (25) Vendor_Address Vendor’s street address Required Unique Char (25) Vendor_City City the vendor is located in Required Non-unique Char (25) Vendor_State State the vendor is located in Required Non-unique Look-up Vendor_Zip Vendor’s zip code Required Non-unique Char (5) Vendor_Phone Vendor’s phone number Required Unique Char (10) Vendor_Email Vendor’s email address Optional Programmers Programmer_ID Unique identifier for each programmer Required System assigned Unique Numeric (10) PK Vendor_ID Unique identifier for each vendor Required-FK System assigned Unique Numeric (10) Programmer record can’t exist without a corresponding vendor record Prog_F_Name Programmer’s first name Required Non-unique Char (15) Prog_L_Name Programmer’s last name Required Non-unique Char (15) Prog_Phone Programmer’s phone number Required Unique Char (10) Prog_Email Programmer’s email address Optional Invoices Invoice_ID Unique identifier for each invoice Required System assigned Unique Numeric (10) PK Vendor_ID Unique identifier for each vendor Required-FK System assigned Unique Numeric (10) Invoice record can’t exist without a corresponding vendor record
Systems%20Design%20Document%20(2)TA2_commented.docx