A customer is an employee of one organisation that has an agreement with LoanMan General Assignment Information No cover page is required, every page to include footer with the following details: CIS_Number_CIS112 CT Assignment_Semester_1_2021 Word Limit: 1200-1500 Submission of the reports should be on TURNITIN Submission of the MS Access database (System) and Excel files should be on SERVER. (URL to be communicated later) The system should provide the LoanMan employee with a menu to perform the various task only after they have managed to log into the system: Logging in and out of the system. Capturing records for the new customer, Products. Organisation and loans. View a list of all the Organisation and Customer list in the system. Compute total money of the various loan for the different Customers. Update the loans for existing Customer. Part A Task 1 - Management System Database (MS - Access) LoanMan Microlending System LoanMan is a company in the business of Microlending services. They provide a wide number of financial services with major focus being short term loan facilitation. The company is currently in the process of replacing their old manual system of using spreadsheet with a new computerised system. In the new system an authorized employee is responsible for capturing the details of new customers into the system. The customer would have applied for a specific product such as short-term loan and long-term loan, the loan details should be captured into the system. The product information will include different services offered by the company such as those mentioned above. Their services are for specific organisation or companies which they have an agreement with only. The System should be able to store information about the following entities: Employee, Product, Loan and Organisation. Employee is responsible for processing the loan of a customer A customer can qualify for one or more products within their services Task to be addressed a. Produce a logical model (Entity Relationship Diagram) which shows how the entities are interacting or the relationships. Indicate foreign keys with letters (FK) on your diagram, and a primary key with the letter (PK) e g. Customer Customer. Firstname, Lastname, Address, OrganisationID (FK). etc). (8 marks] b. Using MS Access produce relational database using the four entities identified above (Task 1.a) together with their respective fields (attributes). You should indicate the primary key for each entity as well as the data type for the attributes and appropriate field size. For example- Customer Customel (Auto number). Firstname (Shorttext,50). gender (Shorttext,50). etc) where Customer is the primary key. [12 marks] [NB: Students are to come up with a minimum of four (4) attributes per entity] Page 2 of 2 Page 3 of 7
