They will curse you every day if you designed this system for them. Imagine the bankers collating all such sheets to find their daily cumulative transactions, branch-wise and as a company. In the first approach, it might look simplistic at first glance, but is actually very complicated for an organization to handle.
The customers’ master data is maintained in one table, and transaction details are maintained in another table.Every customer’s transactions to be maintained in a separate sheet (table).What are the options then? There can be many ways, but two simple methods which come to my mind are as below. Now when the data is for a large organization like a bank, keeping that all in one table will be simply not possible. If the information for transactions is maintained in one sheet, this data will repeat every time whenever the customer transacts, and unnecessarily consume memory. The customer account details, which do not change frequently, can be called their master data. If the bank starts maintaining data in one table, it shall have customer name, their account numbers, transaction dates, and transactions details, along with many other customer-related details. Let us understand this by taking an example of a bank keeping details of its customers and their transactions. But as the size of the data grows, it becomes more and more difficult to handle this tabular data (because of its size). This format has its advantages like the relevant data is easy to find and it’s fast to fetch results. One of the most popular ways is storing all the information in one worksheet or table (basically 2-dimensional format, which has dimensions as ROWS and COLUMNS). This information can be stored in many possible ways. Introduction to Relational DatabaseĪ database is simply a set of related information. This is an integral and unavoidable step of Data Mining and Data Preparation.īut before we go forward, Let me explain what is a relational database, and how do they differ from other forms of dataBase. In the age of relational databases, Joining and Merging tables is a necessity.