1. Create a simple admin login interface. 2. Create a customer registration interface for registering customers. Customer information needed are names, marital status, employment status, name of employer, date of birth, ID Card type (Passport, NHIA, NIA, Voters' ID, or driver's license), address, email, and phone number. Note: All fields must be validated using JavaScript.

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter7: User Creation And Management
Section: Chapter Questions
Problem 8HOA
icon
Related questions
Question
QUESTION TWO
FastLink Limited is a microfinance company that gives out loans to deserving customers. Customers
pay simple interests on the loan given (Principal) per annum. FastLink urgently needs a system that
will help them keep proper records on their customers as well as loan records.
1. Create a simple admin login interface.
2. Create a customer registration interface for registering customers. Customer information
needed are names, marital status, employment status, name of employer, date of birth, ID Card
type (Passport, NHIA, NIA, Voters' ID, or driver's license), address, email, and phone number.
Note: All fields must be validated using JavaScript.
3. Customers are charged a simple interest per annum on any approved loan. Assuming every
loan applied for is approved, develop an interface that will help the company to keep records
of their loan applicants in a database. Remember, only registered customers of the company
can access loans.
Simple Interest (SI) = (Principal (P) * Rate(R) * Time (T))/ 100.
The Principal, Rate and Time should be entered.
4. Create an interface for retrieving the loan records of a client showing the basic records of the
client as well as the loan records of the client.
Transcribed Image Text:QUESTION TWO FastLink Limited is a microfinance company that gives out loans to deserving customers. Customers pay simple interests on the loan given (Principal) per annum. FastLink urgently needs a system that will help them keep proper records on their customers as well as loan records. 1. Create a simple admin login interface. 2. Create a customer registration interface for registering customers. Customer information needed are names, marital status, employment status, name of employer, date of birth, ID Card type (Passport, NHIA, NIA, Voters' ID, or driver's license), address, email, and phone number. Note: All fields must be validated using JavaScript. 3. Customers are charged a simple interest per annum on any approved loan. Assuming every loan applied for is approved, develop an interface that will help the company to keep records of their loan applicants in a database. Remember, only registered customers of the company can access loans. Simple Interest (SI) = (Principal (P) * Rate(R) * Time (T))/ 100. The Principal, Rate and Time should be entered. 4. Create an interface for retrieving the loan records of a client showing the basic records of the client as well as the loan records of the client.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Development strategies
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning