I have designed a database that is to create a application simlar to microsoft money
The database erd is aattched with this post. The database has following table
A invoice can sometimes split in to 3 parts
therefore i have create table invoice
with following column
I have created a Amount table
I have created amount table as the amount of the invoice is dependent on Profit_center and Account.
From the application i will first update the amount table and then the invoice table.
I wanted to cross check if this is correct.