|
From: Ben <ct...@co...> - 2001-11-05 19:25:32
|
See attatched- Ben On Mon, 5 Nov 2001, Powell, Jim (EER) wrote: > Well, if e-mail is the way we have to do it, then that's the way we have to > do it. I remember being in college, there is not a lot of free time, and > yes, something like this would look really good on your resume. > > Well, I had time to go through the MetaKit API, and it looks like our best > rchoice. There isn't a lot involved in getting the database part up and > running that way, and there is no need to have the user go out and get any > other programs in order to get our program to run. > > OK, either way, I see the DB Schema as our first order of business. Once we > have that defined, that will fall into our UML and we can seriously get > started. Nice thing about learning Rose is that it is pretty universal, of > course using Thorn you don't get all the nice things, but close enough. OK, > here is what I see as the major things to go into the DB, this is not a > schema, just a first pass at the data so we can begin to come up with one. > > Bank Accounts > ID The Record Number (The key for the record) > Active Is the account active (Boolean) > Bank This will be the banks 9 digit Routing Number, we > need > to determine what the approach is in Europe, I think > the 12 digit number is standard. If it is, we can > use > this number as a lookup into a Bank Table. > Account This will contain the account number > On-line Whatever is needed to perform online banking with this > bank. > Balance The calculated balance > Transaction A pointer to the First of a link list of > Transactions. > > Transaction > ID The key > Check The check number (not used for savings) > To The name to whom the check is made out > Reconciled Whether the check has been Reconciled (Boolean) > Withdrawal Check/ATM Withdrawal/etc. > Deposit Money going in. > Balance Balance as of this transaction. > Next ID of next transaction for this account. > > > That's probably everything you can do with Checking/Savings, I'll let you > think about stocks/bonds/securities. You might want to look up the > Financial Information Exchange (FIX) Protocol, that seems to be the protocol > by which online trading is done (maybe online banking as well, I haven't had > time to look into it yet. > > Well, that looks like a good start. Have fun trying to digest all of it. > > Jim Powell > AV-8B Weapons Integration Group > EER Systems, Inc > (760)939-9089 > mailto:pow...@na... > > > > -----Original Message----- > > From: Ben [mailto:ct...@co...] > > Sent: Monday, November 05, 2001 1:28 AM > > To: Jim Powell > > Cc: mos...@li... > > Subject: RE: [Mospft-admin] Meeting > > > > Ah sorry, I was here till about 7pm our time.... Pulled another all day > > sat in front of the computer from about 9 o'clock. Weve had about 30 > > models in rational rose to do before tuesday so everyones been working > > very hard. > > > > If you definetly still want to do this then we can start trying to sort > > things out over email?? IF your not sure then Ill come up with something > > else to work on... Id like to work with you though because I think ill > > learna lot from you and you seem like you would actually get something > > done unlike most of the people on sourceforge- > > > > let me know what you think... > > > > ben > > > > > > On Sun, 4 Nov 2001, Jim Powell wrote: > > > > > Well, I'm home, you don't seem to be online. > > > > > > Jim Powell > > > Owner > > > Frail Moon Enterprises > > > po...@gs... > > > > > > > > > > -----Original Message----- > > > > From: mos...@li... [mailto:mospft-admin- > > > > ad...@li...] On Behalf Of Ben > > > > Sent: Sunday, November 04, 2001 3:39 AM > > > > To: mos...@li... > > > > Subject: [Mospft-admin] Meeting > > > > > > > > > > > > Hi, > > > > > > > > I went home about 5 pm my time yesterday as I had been working all day > > > and > > > > wanted to sleep! However, I should be here a bit later today.... It > > > would > > > > be cool if we could get started on the project- > > > > > > > > Rgds, > > > > Ben > > > > > > > > > > > > -- > > > > Ben Wootton > > > > ct...@co... > > > > > > > > > > > > > > > > _______________________________________________ > > > > Mospft-admin mailing list > > > > Mos...@li... > > > > https://lists.sourceforge.net/lists/listinfo/mospft-admin > > > > > > > > > _________________________________________________________ > > > Do You Yahoo!? > > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > > > > _______________________________________________ > > > Mospft-admin mailing list > > > Mos...@li... > > > https://lists.sourceforge.net/lists/listinfo/mospft-admin > > > > > > > -- > > Ben Wootton > > ct...@co... > > > > > > > > _______________________________________________ > > Mospft-admin mailing list > > Mos...@li... > > https://lists.sourceforge.net/lists/listinfo/mospft-admin > > _______________________________________________ > Mospft-admin mailing list > Mos...@li... > https://lists.sourceforge.net/lists/listinfo/mospft-admin > -- Ben Wootton ct...@co... |