Hi ,
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
Invoice
Amount
Account
Profit_center
Customer
A invoice can sometimes split in to 3 parts
therefore i have create table invoice
with following column
Invoice_id (PK)
Customer_ID(FK)
Date
I have created a Amount table
with
Invoice_id
Profit_center_ID
ACCOUNT_ID
Amount
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.