Trade Federation Sells Droids Maintains Database Shown Erd Keep Track Customer Purchases C Q37048774

Invoice Customer InvoiceLine PK InvlD s on ann PK,FK1 InvID has CID Date Total PayTerms Status Total PK,FK2 DID Name Phone CrTrade Federation sells droidsand maintains the database shown in the ERD below to keep track oftheir customer purchases. A customer can make many droid purchaseswith each purchase generating an invoice. The customer’s balance isadjusted with credit purchases (increases the balance) or payments(decreases the balance), so it is always current. In addition, thelast purchase date and last payment dates are updated when thecustomer makes some business transaction with tradefederation.
Invoices contain a line for each product purchased

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.