SQL Prc

by Prasad Gavande

HTML

Project: Online Transaction fraud alert system.
Objective: The objective of this system is to build an engine to detect fraudulent transactions and provide alerts to users on suspicious banking transactions

Scenario: The system will have the following tables
1. Customer Master: 
	CRN
	Name
	Address
	Customer Type (Can be preferred, savings, current, salary)
2. Transactions
	Customer Id
	Date and time of transactions
	Type of transactions
	Channel of transactions
	Merchant
	Location

Requirements:
a. All required masters and transactions must be created in the system.
b. The system shall be built in a modularised way where function is distributed to perform only specific responsibility to achieve modularity
c. All transactions should be processed through the Fraud alert system.
d. System shall define the rules based on the type of transaction, amount and type of customer.
e. Rules can be added or modified. Any new rule added or modified should not require change in the main Fraud Alert definition logic. 
Some of the sample rules for alert generations are: 
1. When transactions are done from two different channels (e.g. ATM and Online) with a time span of 30 seconds
2. When transactions are done from two difference areas with a span of 1 hour (e.g. two transactions happening from different countries.)
3. When transactions are done from certain merchants, example buying gold, buying electronics
4. When transactions are done beyond the limit defined for the customer type.

















Following Point TO DO:

1. Create table Custemer having following feild and data type
(CRN	 	int Primary key identity,
Name 		nvarchar(30),
Adress 	nvarchar(30)(Used for location purpose),
Customer_type 	int(forigen key with custmer type table),
	Amount 	money or bigint)
     
     2.    Create table Transaction having following feild and data type
(Trans Id		int Primary key,Identity
Customer Id 		int(forigen key with Custemer table with CRN),
 TransactionsDateTime 	 Datetime,
Type...