A group of UB students have decided to come together to form a motshelo group. Each member of the group will provide an unique identity number of the type decided by the group for recognition purposes. In addition each member will provide their fullname, residential address (plot number, street and town) and two phone numbers. Members may share the same residential address. The Identity number, fullname, residential address and phone number of their guardian is also needed. In some cases the residential address of the guardian is the same at that of the member. The group has also decided to open an account with Absa bank for safekeeping of their contributions. The bank account has a unique account number and branch number. The group keeps track of the transactions (money contributed/borrowed/paid by each member and date) every month. The contributions are paid directly into the account. Payments for those who borrow are also paid via online banking from the account and the interest calculated and added with the amount borrowed to the balance for that member. The balance is kept for each member of the group. a) Draw an ER diagram that captures the preceding information (you may attach the pdf file of a diagram made outside Moodle below). [10] b) Translate the ER diagram to a relational database schema. [10]

pur-new-sol

Related Questions