Through three days of effort, we can design this database-based course on schedule.
My littleProgramThe development tool used isVs2005st + SQL Server 2005(Standard Edition)
The selected runtime environment is.NET 2.0. The operating system isXp pro Eng
This program is quite simple.2Class, one is the Administrator, and the other is a common user.
Administrators can manage all common users (add, delete, and modify common users) and view related statistics. Such as the number of customers, the proportion of men and women, and the total amount.
Ordinary users are equivalent to the salesclerks in the bank. They are responsible for checking the customer's basic information and adding new customer information (some customers use our company's services ), add a new transaction record (the customer wants to save money or withdraw money ). And so on.
The entire database is composed3A table consists of two views. One is responsible for managing the ID and psw of common users.
The other two are responsible for managing the bank's customer information and the transaction records of each customer.
After my basic verification, they all meet the requirements of the 3rd paradigm.
The two views are used by common users because they can filter data (user passwords, balances, etc) and maintain data consistency (otherwise you need to update more than one copy of data at the same time ).
Indexes and stored procedures are not used throughout the implementation process. (Things are too difficult, and the teacher has not given specific requirements ).
What I'm most satisfied with the entire program is that my program can process different data sources (such as SQL Server orcl) entirely through the configuration file ). You only need to ensure that the data in the data source has the three tables that I want, and the data type and constraints are the same.
Here I provide all of myCodeIncluding creating scripts for databases (only for SQL Server. Hope to help those who need it. I also hope that experts can point out my shortcomings and help me make progress.
The file is as follows:/files/gpcuster/bankaccountms.rar