In the ER Diagram, the field <b>No of Pending Invoices </b>can be computed by counting the number of record with a marked value, if I am not wrong. Maybe we can avoid this field altogether. You can also avoid the <b>marked</b> field by checking whether the field <b>valid </b>is <b>true</b>, <b>false</b>, or null. Or maybe you could use a varchar or int field for <b>valid</b> that will hold three values for these three states. This overall setup should reduce you two fields in the tables, and save you to save multiple fields for a single entry whereas a single field is logically involved. <br>
<br><div class="gmail_quote">On Mon, Jun 6, 2011 at 12:01 AM, puneet goyal <span dir="ltr"><<a href="mailto:puneetgoyal08@gmail.com">puneetgoyal08@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
hello,<br>
i have made a usecase diagram and a data model on the page<br>
<div class="im"><a href="http://community.kde.org/Alkimia/Usecases/payment" target="_blank">http://community.kde.org/Alkimia/Usecases/payment</a><br>
</div>please review it and let me know about the corrections i should make<br>
or any further advancements in it.<br>
thank you<br>
<div><div></div><div class="h5"><br>
--<br>
-----------------------------------------------------------------------<br>
Puneet Goyal<br>
Student of B. Tech. II Year (Software Engineering)<br>
Delhi Technological University, Delhi<br>
-----------------------------------------------------------------------<br>
_______________________________________________<br>
Kde-finance-apps mailing list<br>
<a href="mailto:Kde-finance-apps@kde.org">Kde-finance-apps@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/kde-finance-apps" target="_blank">https://mail.kde.org/mailman/listinfo/kde-finance-apps</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>samir<br>{ <a href="http://www.incurlybraces.com" target="_blank">www.incurlybraces.com</a> }<br><br>