Results 1 to 2 of 2
  1. #1
    misscupid is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    3

    Loan and Savings Database

    Hi, please help me on my project in Database. I attach a picture of my ERD, I just do the relationships there, please kindly know if my work is right ? I don't know if my ERD is right so I need some help guys. Pretty please (*/\*)

    Here's my business rule ...

    1. A person needs to be a member of the Manila Teachers' Loan and Savings Inc. to apply for a loan, to contribute and to withdraw.
    2. In filling up the membership form, the last employee number, employee position, employee salary, employee status will be recorded.
    3. The GSIS/SSS Number shall serve as the membership ID.
    4. The latest employer shall be recorded.
    5. A member can only have one account, and an account can be owned by only one.
    6. A member can only apply for one loan.
    7. A member can make many contributions and withdrawal.


    8. In applying for a loan, there should be exactly one co-maker.
    Attached Thumbnails Attached Thumbnails 1.jpg  

  2. #2
    misscupid is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    3
    I cannot work out how to fix them. I would like to work with someone to help me fix this.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Loan Adjusted in instalments
    By jalals in forum Access
    Replies: 4
    Last Post: 10-02-2014, 11:19 PM
  2. Help with Loan Phone Database Subform
    By jakeryan56 in forum Forms
    Replies: 3
    Last Post: 02-19-2013, 02:41 PM
  3. Loan Production Report
    By vickan240sx in forum Access
    Replies: 4
    Last Post: 09-17-2012, 01:47 PM
  4. loan database
    By jlyon in forum Access
    Replies: 5
    Last Post: 07-23-2010, 07:24 AM
  5. Installment Loan manager
    By tedalmeida in forum Access
    Replies: 1
    Last Post: 03-17-2010, 07:11 AM

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
  •  
Other Forums: Microsoft Office Forums