Question

provide explanation:

Introduction: The banks in Australia (and most of the other countries having a modern banking system) provide the customers to transfer money between two accounts in real-time. In most of the Australian banks, the transfer software/app, popularly known as Real-time Money Transfer (RMT), has an identical flow. As for example, a transfer starts after the usual log in and standard authentication. After that, the user selects a recipient for the transfer. Having proper authentication (if required), if the total amount to transfer is less than the current balance of the user, the system transfers the money immediately to the recipient. Some of the systems allow the sender to send an email to the recipient to let him know about the transfer. Although the transfer seems to be a straight-forward one, most of the bank enforce additional authentication to ensure the smooth and safe transfer of the money. You are now the in-charge of the development of this software in a new Bank. Your task is to oversee the development of this Real-time system required to ensure secure money transfer.

Description: The RMT should work according to the following rules:

Step-1: Sender enters the interface after successful authentication

Step-2: Selects the account (multiple accounts may be linked in one interface) and amount to transfer

Step-3: Select the recipient of the transfer either a) from an already Save info and move to Step-6, OR b) by entering the recipient name and account info

Step-4: The bank sends an SMS code in the sender’s mobile number (which is already stored in the bank database)

Step-5: Sender retrieve that code from SMS and enter the code in the website/ app and resume the transfer

Step-6: Transfer is completed and a confirmation message is shown

Item Must be include in:

(* Introduction

* An External Entity-Relationship Diagram

* Discussion on ERD

* Data and Control Flow Diagrams (DFD/CFDs)

* Discussion on DFD/CFDs

* Control Specifications (Cspec)

* Discussion on Cspec

* Data Dictionary

* Discussion on Data Dictionary

* Conclusion)

Thanks

Answer 1

time_stamp status kiosk ID last_name recievedAmount city Origin passport no Users Transfer Kiosk street Sender Destination number first_name Recipient transfer ID sentAmount Belongs to from_currency to_currency rate ExchangeRat Is Of Currency Currency Is Of Currency Account type exchange_id currency balance

This ER (Entity Relationship) Diagram represents the model of internet Banking Entity. The entity-relationship diagram of internet Banking shows all the visual instrument of database tables and the relations between Credit, Fund Transfers, Banks, User etc. It used structure data and to define the relationships between structured data groups of internet Banking functionalities. The main entities of the internet Banking are Banks, Credit, Debits, Fund Transfers, Services and User. internet Banking entities and their attributes : • Banks Entity : Attributes of Banks are bank_id, bank_customer_id, bank_name, bank_branch_code, bank_place, bank_type, bank_description • Credit Entity : Attributes of Credit are credit_id, credit_name, credit_amount, credit_total, credit_type, credit_description • Debits Entity : Attributes of Debits are debit_id, debit_name, debit_amount, debit_total, debit_type, debit_description • Fund Transfers Entity : Attributes of Fund Transfers are transfer_id, transfer_bank_id, transfer_name, transfer_fund, transfer_total, transfer_type, transfer_description • Services Entity : Attributes of Services are service_id, service_bank_id, service_name, service_type, service_description • User Entity : Attributes of User are user_id, user_name, user_mobile, user_email, user_username, user_password, user_address Description of internet Banking Database : • The details of Banks is store into the Banks tables respective with all tables • Each entity (User, Debits, Services, Credit, Banks) contains primary key and unique keys. • The entity Debits, Services has binded with Banks, Credit entities with foreign key • There is one-to-one and one-to-many relationships available between Services, Fund Transfers, User, Banks . All the entities Banks, Services, Debits, User are normalized and reduce duplicacy of records . We have implemented indexing on each tables of internet Banking tables for fast query execution.

Branch management Accounts management Currency management Online Banking System Accounts type management system user managen System user managent Login management

First Level Data Flow Diagram(1st Level DFD) OF Online Banking System: First Level DFD (1st Level) of Online Banking System shows how the system is divided into sub-systems (processes), each of which deals with one or more of the data flows to or from an external agent, and which together provide all of the functionality of the Online Banking System system as a whole. It also identifies internal data stores of Account Type, Customer, Branch, Balance, Transaction that must be present in order for the Online Banking system to do its job, and shows the flow of data between the various parts of Bank, Transaction, Customer, Account Type, Branch of the system. DFD Level 1 provides a more detailed breakout of pieces of the 1st level DFD. You will highlight the main functionalities of Online Banking. Main entities and output of First Level DFD (1st Level DFD): • Processing Bank records and generate report of all Bank • Processing Account records and generate report of all Account • Processing Transaction records and generate report of all Transaction • Processing Balance records and generate report of all Balance • Processing Branch records and generate report of all Branch • Processing Customer records and generate report of all Customer • Processing Account Type records and generate report of all Account Type

The Control Specifications (CSPEC) is used to indicate (1) how the software behaves when an event or control signal is sensed and (2) which processes are invoked as a consequence of the occurrence of the event. The control specification (CSPEC) contains a number of important modeling tools. The control specification represents the behavior of the system in two ways. The CSPEC contains a state transition diagram that is sequential specification of behavior. It also contains a process activation table (PAT) -a combinatorial specification of behavior. Process Model Data input Data output DFDs PSPECS Proceso activators Data conditions Control Model CFDs CSPECS Control output Control input

A metadata (also called the data dictionary) is the data about the data. It is the self describing nature of the database that provides program-data independence. It is also called as the System Catalog. It holds the following information about each data element in the databases.

The data dictionary contains the bookkeeping information about the database so that it can manage the data. It does not contain the information of the actual data of the database. Without the presence of a data dictionary, a database management system cannot access the data from the database. Database administrators handle the data dictionary, and users don’t interact with it.

The data dictionary contains the following information:

•   It contains the names of all the tables and schemas present in the database.

•   It contains the details about the tables which are present in the database like when the tables were created, owner information about the tables, etc.

•   It contains the information about the constraints of the tables like primary key attribute.

•   It also contains the information about the views of the database.

Importance of Data Dictionary

Data dictionary is essential in DBMS because of the following reasons:

• Data dictionary provides the name of a data element, its description and data structure in which it may be found.

• Data dictionary provides great assistance in producing a report of where a data element is used in all programs that mention it.

• It is also possible to search for a data name, given keywords that describe the name. For example, one might want to determine the name of a variable that stands for net pay. Entering keywords would produce a list of possible identifiers and their definitions. Using keywords one can search the dictionary to locate the proper identifier to use in a program.

These days, commercial data dictionary packages are available to facilitate entry, editing and to use the data elements.

Functions of the data dictionary

Its function is as follows:

•   It defines the data objects of each user in the database. As we know, we cannot remember all the tables, views, constraints, etc., so the user can easily search them when any Data Definition Language (DDL) fired, then the database searches for the data dictionary. The DBMS software updates the object.

•   It gives us the report about the data and the resources which the objects are using.

•   It allows seeing the tables and views to those users who have the proper rights to access the database. Thus, it controls the access of the database.

Advantages of the data dictionary

•   The data dictionary used so that we can remove the duplicacy in the data definition.

•   As it provides documentation. So it is a valuable reference for any organization.

•   It helps the analysts in simplifying the structure so that it can meet the requirement of the data of the system.

•   It helps in improving the communication between the user and the system analyst.

•   Maximum of the database management system contains the data dictionary as a standard feature.

•   Through this, new database administrators can easily understand the database of the system.

•   The database administrator can easily track any problem in the database.

Disadvantages of the data dictionary

•   The data dictionary does not provide functional details.

•   It seems to be costly.

•   Technical users easily understand it. Non-technical users cannot handle it.

•   It should be well designed in such a way so that we can take advantage of it.

•   The creation of a new data dictionary is a difficult task. It takes many years to create.