Table INVOICES to Table INVOICE_LINE_ITEAMS have one too many relations. One-to-many relations create when one recordin a tablecan be associated with one or more forms in another. In this case, The INVOICE ITEMS can have one or many INVOICES. The INVOIVE_ID column is the link between two tables. While in the relation between table INVOICE_LINE_ITEAMS and GENERAL_LEDGER_ACCOUNTS is the ACCOUNT_NUMBER column. The account_number column is the primary key in the genereal_ledger_account table, while in the Invoice_line_Iteams, it is a foreign key. They have one to many relations because one Invoice can have one or more Accounts. While the General_ledger_aacount and Vendors also has the one to many relationship. The Account_number column helps to link between these two table. The Account number is a primary key in General_ledger_account while in Vendors it is a foreign key. They have one to many relation because in order to exists vendor accounts in table it need to have one or many accounts.
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order Now
Get Online
Assignment Help Services
