Scribd
Upload
16 views4 pages

Credit Card Management System Design

Uploaded by

suganyasuganya0587
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views4 pages

Credit Card Management System Design

Uploaded by

suganyasuganya0587
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Advanced Materials Research Submitted: 2014-08-06

ISSN: 1662-8985, Vols. 1044-1045, pp 1730-1732 Accepted: 2014-08-11


doi:10.4028/[Link]/AMR.1044-1045.1730 Online: 2014-10-01
© 2014 Trans Tech Publications, Switzerland

Design and Realization of the Credit Card Management system


Pu Zhang 1,a
1
Pingdingshan Industrial College of Technology, No.3 Shuiku Road ,Zhanhe River District,
Pingdingshan,Henan Province, China
a
djxzcy@[Link]

Keywords :Credit card management system, report generation, customers, management strategy

Abstract:For the convenience of customers and bank managers to the management of credit card,
credit card management system includes client money query, customer consumption management,
credit card accounts, sales management, credit ratings, statistics report, the number of overdraft
statistical function module, etc. This design USES the ACCESS to do background database, using vc
+ + development environment, combined with a c + + programming language implementation. The
credit card information query and statistics report, open an account pin is the characteristics of this
system. In particular System "query module" function greatly reduce the workload of staff, and to the
rapid, accurate, and other advantages replace manually operated, and improve the efficiency of the
credit card management.

Introduction
Credit card management using C/S architecture, in order to do background database Access2000,
using vc + + development tools with C + + programming language to complete the function and
interface design, realize the function of user queries and user consumption (including the pressing
time query, the query) inductor and administrator authentication interface and the generated report
file function, enter the administrator in the authentication screen code and password for user
information query and management operations. To decrease the risk degree, effectively improve
customer loyalty, and to maintain a long-term and beneficial business relationship.

[Link] system and the analysis of demand


With the rapid development of information technology, people in pursuit of material life and
spiritual life constantly improves. Because of the credit card is easy, beautiful, easy to carry, has
become more and more people travel, consumption used by a payment tool. Has become an inevitable
tendency of the development of credit card, bank administrators need to establish a standardized
credit card system, facilitating clients to query and Banks internal personnel management of the credit
card information. Through investigation and analysis, combined with the customers and the opinions
of the credit card administrator, I come to the conclusion that there are the following requirements:
for users, the user by entering your username and password, you can know that personal information
such as credit card consumption, balance whether overdrafts. For administrators, he needs to manage
all credit card for the customer, because customer information is confidential, so only authorized
administrator can operate. By entering the correct username and password to enter the admin
interface. Administrator's main task is to my credit card for the client, customers must first before my
credit card account. To new users of information entry, need pin households to delete the customer
information, take statistics overdraft, customer consumption to the customer to carry on the summary,
the customer basic information displayed in the report, this device installation and removal of the
management, etc.

All rights reserved. No part of contents of this paper may be reproduced or transmitted in any form or by any means without the written permission of Trans
Tech Publications, [Link]. (ID: [Link], Pennsylvania State University, University Park, USA-08/05/16,22:53:37)
Advanced Materials Research Vols. 1044-1045 1731

[Link] system design

2.1Function module design


Module is data function, executable statement program objects such as collection, it is named
alone and can be accessed by name. Modular is to divide the program into several modules, each
module to complete the function of a child, the modules are lumped together into a whole, can
complete the specified functions meet the requirement.
The principal functional modules are as follows: system user management module, the
administrator management module, query functions module, add a function module, the account
opening function module, function module, report generation module pin.

2.2System overall structural design


According to the mentioned in the preceding section, the concept of system function module
design reference in structural design, we can get is as shown in figure 3-1 as follows:

Figure 3-1 System overall structure design

[Link] logical structure design


Logical structure design of the task is to design the conceptual structural design stage good basic
converting e-r diagram and choose the DBMS products consistent with the logical structure of the
supported data model. So the logic structure design should first select the most suitable for the
description and expression of the corresponding concept of the structure of the data model, and then
select the most appropriate DBMS. When designing logical structure typically divided into three
steps.
1)Converts conceptual structure to the general relationship, mesh, hierarchical model
2)Will be transformed to the relationship, mesh, hierarchical model to particular DBMS support
data model transformation
3)Optimize the data model
According to the principles of transformation, the credit card management system overall e-r
diagram into relation model, and optimize the relational model, the results are as follows:
The user (user name, id number, telephone number, address, password)
This device (installed this device ID, time, place, remove time)
Credit card (account, bank id, credit card number, report the loss of STH, advance)
Accounts (account number, amount, account opening time, pin time, interest, id number,
overdraft, credit level)
1732 Frontiers of Energy, Materials and Information Engineering

[Link] card management system

4.1To create the ODBC data source


In the control panel, double-click the icon "management tools" and then double-click in new
window "data sources (ODBC)," in the pop-up dialog box to select "system DSN", click "add" button,
the pop-up dialog box to select the "Microsoft Access Driver (*. MDB)". Click "Finish", a new dialog
will pop up, the data source name CreditCardManage, after naming data source, the need to connect it
to a database. Click "select", get stored in the data directory credit card. Copies of the MDB file,
select, click "ok" to end this dialog. , and then click "ok" to complete the creation of a data source.

4.2Using AppWizard to create a database applications


Starting from the AppWizard to create a new MFC AppWizard (exe) project. Named
CreditCardManagement, then follow these steps:
1)The first step in the MFC AppWizard dialog box, selects the "single document".
2)In the next step in the MFC AppWizard dialog box, select "view database does not use file
support", then click the "Data Source".
3)In the Data Source group box, click the ODBC radio button, then choose CreditCardManage
from the drop-down list, click OK, in the latest dialog box to select all the table. Steps after receiving
the default values, click "Finish".

[Link]
Based on the credit card system software design, I not only to the development of credit card
service industry have a certain understanding, and the credit card management system
implementation in the application of new technology in the future development space is very
considerable. At the same time to have a deeper understanding of vc + + programming language.
Algorithm is complicated because the new technology, combined with the support of hardware
performance is high also. My computer system configuration is low, unable to complete the
application of new technology. However, this system can realize the basic function of all, to be
strengthened and perfected.

References
[1] Hongliang Yan, etc. The [Link] programming tutorial. Shanghai Jiaotong University press.
[2] Yucai feng. The database system. Wuhan: huazhong university of science and technology press,
1993.
[3] Yingwei Li, etc. [Link] database high-level programming (c #). Beijing: Tsinghua University
press.
[4] Jinxiu Xiao, etc. The ASP network programming technology [M]. Beijing: Tsinghua university
press, 2001.
[5] Yingxue Chen. Microsoft, [Link] programming. : Beijing Hope electronic publishing house,
2001.
Frontiers of Energy, Materials and Information Engineering
10.4028/[Link]/AMR.1044-1045

Design and Realization of the Credit Card Management System


10.4028/[Link]/AMR.1044-1045.1730

Common questions

Powered by AI

The modular design of the credit card management system improves scalability by allowing individual modules to be updated or expanded without affecting the entire system. This design includes separated functions such as user management, administration, and report generation, each operating independently. Maintainability is also enhanced, as developers can target specific modules for troubleshooting or enhancements, making it easier to implement updates and fix issues .

The credit card management system is designed using a client/server (C/S) architecture. Its main components include the client money query interface, customer consumption management, credit card accounts, sales management, credit ratings, and statistical report generation modules. These components collectively facilitate efficient management by allowing users to query their personal information and consumption history, while providing administrators with tools to manage accounts and generate comprehensive reports. This modular design replaces manual operations, improving user efficiency and data accuracy .

The credit card management system utilizes the ACCESS database as its backend to store and manage user and transaction data efficiently. The use of VC++ development tools, in combination with the C++ programming language, aids in creating the system's user interface and implementing its functionality. This integration allows for effective user queries, consumption tracking, and report generation, ultimately replacing manual operations with rapid and accurate processing .

Report generation plays a critical role by providing administrators with summarized data on customer consumption, credit card usage, and account statistics. These reports help in strategic decision-making, tracking financial trends, and managing risk. Administrators rely on these insights to maintain customer relationships and ensure efficient credit card operations .

The potential limitations of the credit card management system in implementing new technologies include its reliance on current hardware performance, which may not support advanced features efficiently. The system's existing configuration might lack the flexibility to integrate novel technologies without significant modifications. Moreover, enhancements might require substantial updates in both hardware and software components to exploit new technology's full potential, which could be resource-intensive .

The query module significantly enhances the credit card management system by reducing staff workload through automation of data retrieval and management processes. Compared to manual operations, this module allows for rapid and accurate access to credit card information, improving overall efficiency and reliability in processing user and administrator queries. This automation minimizes human error and ensures quicker response times .

The logical structure design process involves converting the conceptual data model into a general relationship model, then into a data model compatible with the chosen database management system (DBMS). This step optimizes the relational model by organizing data entities such as users, devices, credit cards, and accounts into a structured format. Effective logical design ensures consistent data organization and is crucial for the system's ability to handle data retrieval and manipulation efficiently .

The system ensures customer information confidentiality and secure management through administrator authentication processes, requiring the entry of correct usernames and passwords to access sensitive data. Only authorized administrators can perform operations involving customer account management. This restriction minimizes unauthorized access risks, protecting confidential user information .

The use of ODBC (Open Database Connectivity) data sources facilitates database connection by acting as an interface that standardizes access to the necessary data. In the credit card management system, the ODBC driver connects the software application to the ACCESS database by linking the system's functions to the data source named 'CreditCardManage'. This configuration allows seamless data transactions and management between the application and its backend database .

The AppWizard contributes to the development process by simplifying the creation of MFC (Microsoft Foundation Class) applications. It guides developers through setting up project frameworks, choosing document views, and configuring database connections via ODBC, such as selecting the 'CreditCardManage' data source. This tool streamlines application development, allowing developers to focus on implementing specific functionalities while ensuring robust database integration .

You might also like