DATABASE QUESTION PLEASE ANSWER BELOW QUESTION 1 & QUESTION 2:

YOUR ANSWER SHEET, SAVE AS PDF AND SUBMIT THE DIGITAL VERSION (.PDF) USING THE LINK PROVIDED IN THE E-LEARNING. NSWER AND WRITTENJ UN PAPER. A COMPUTER TYPED AND DRAWINGS ARE be Music 84550&cmid=357120 * YouTube > Jimat Hosting Turnitin and Endnote THE CASE STUDY: BBCB is one of the famous banks in Malaysia. It has many branches all over the country. Each branch has many customers. BBCB wants to develop an information system to be used by the customer service staff to keep the records of the customers. Customer data that need to be stored are: Customer ID, First Name, Last Name, Home Phone Number, HP Number and address BBCB offers many types of accounts for its customers for example Conventional Bank Account (Savings-c Account and Current-c Account) and Islamic Bank Account (Savings-i Account and Current-i Account). Customers can have more than one type of account. For each account that a customer has, the data need to be stored are: Account ID or Account Number, Account Type, Minimum amount and current amount. BBCB also offers customers loans. Customers can take different types of loans from the bank branches One customer can make multiple loans. The data need to be stored for the loans are: Loan ID, Loan Type and Total Amount, Monthly Payment and Duration. Data on payments make by a customer for each loan are also recorded. It includes the date of a payment and the current balance of amount to be paid for a loan Based on the case study, answer the followings: 1. Produce a conceptual ERD to model the database for BBCB Information System (10%) 2 Based on your answer in 1, derive and list all relations schema from the ERD. (5%) 7 BI 93 90 es