Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Trouble creating a logical model for a simple school cashier environment.

    I have to create a system design for a cashier system. Most of the transactions would be payments for fees in a student account.
    Fees like Tuition, Books, Enrollment Fees. The problem with these fees are their special characteristics like Tuition fees being staggered in MONTHLY itemization (if that's a correct term), Books can also be staggered but payable throughout a year without itemization, and Enrollment Fees which consist of the Reg Fee and the Misc Fee (which is broken down into a bunch of items) both of these Enrollment Fees required for payed during enrollment. Other fees would be just simple fees, and some other special ones are to be payed by students who've succeeded to a certain year level like Prom Fees for 3rd & 4th year students.
    The thing is they need to formatted and outputted to a Student Ledger and of course an Official Receipt.

    This "subsystem" is the last part of an amateur School Management System I have to design as the "System Analyst" for the team. Other subsystems are Library, Registrar, Admission.
    Yes, I am a student and this is our Finals requirement.
    Accounting system design I found is in such a whole new level.
    Fortunately, our scope for this one is according to our adviser "easy and simple", using terms like "only debit and credit". Specifically, our scope doesn't include more complicated accounting. Only to a couple of reporting--Student Ledger and Official Receipt generation--and handling student-to-school transaction processes. But despite this "simplicity" I am a noob after all.

    There's a bit more explanation but I hate to repel people would could potentially help me with a much longer wall of text than I have now.

    Currently I'm stuck trying to create an ERD for this system. I'm considering flexibility of the fees, and formatting the output in the ledger and OR.

    Forgive this noobishness, everyone.
    I've tried my best with a 2 month deadline and there's only 1 week left, so I really need help. These accounting stuff is all that's in the way of me passing this subject.

    Thank you very much.

  2. #2
    Join Date
    Mar 2013
    Posts
    2
    I basically have this so far:

    Student Account
    ID (PK)
    Student ID (FK)
    Enrollee ID (FK)

    Student Account Fees
    ID (PK)
    Fee ID (FK)
    Credit

    Fees
    ID (PK)
    Desc
    Charge Amount

    Fees Template
    ID (PK)
    Fee ID (FK)

    Transaction
    ID (PK)
    OR Number
    Mode of Payment
    Date
    Debit
    Credit
    Balance

    Particulars
    ID (PK)
    Transaction ID (FK)
    Fee ID (FK)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •