创建数据库时遇到的困难 [英] Difficulties when creating a database

问题描述

我使用VB.NET和SQL Server数据库在职业高中建立了学费支付系统应用程序.我的数据库有问题，请帮助我创建一个具有查看表单(姓名，学生证号，陆军部门，月费，月薪，描述)的数据库
我对付款"感到困惑，当学生想一次支付三个月的费用时，用户是否必须输入三次数据?如果为true，那么数据库又如何...?
请帮我解决这个问题.

解决方案

这完全取决于您的要求.我个人将创建另一个用于付款的表，其中包括一个用于支付金额的字段，另一个用于下一次到期的支付的字段，然后将此表链接到带有学生ID的学生.

I made ​​a tuition payment system application in vocational high schools using VB.NET and SQL Server database. I have a problem on the database, please help me create a database with a view Form (Name, Student Identification Number, Department, of Army, monthly fees, Pay per month, description)
I''m confused on Pay, when students want to pay three months at a time, whether the user must enter the data three times ..? If true, what about the database ...?
please, help me to solve this problem.

解决方案

This would all depend on your requirements. Personally I would create another table altogether for payments, which would include a field for amount paid, and another field for next payment due, and I would link this table to students with the student id.

这篇关于创建数据库时遇到的困难的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！