关于逻辑的简单问题 [英] simple problem about logic

问题描述

我在逻辑上有问题


我的主表学生是

i have problem in logic


my master table Student is

StudentId(int,not null)
FullName(nvarchar(30),not null))
DOB(smalldatetime)

我的子表 StudentCerificates 是

my child table StudentCerificates is

StudentCerificateId(int,not null,pk)
StudentId(int,not null,pk)
CertificateName(nvarchar(30))
CertificateDate(smalldatetime)

我将学生和学生证书的信息保存在数据库中

我这样做

我的问题我听不懂

i save the infromation of student and student cerificates in database

i do this

my problem i can not understand this

On submission of complete form for saving record(s) into database, a verification must make sure that at least a single record exists for Student Certificates, otherwise abort the save operation.

推荐答案

该要求只是说明，如果您没有该学生的任何证书记录，请中止保存(不要将任何内容写到数据库).

The requirement simply states that if you do not have any certificate records for the student, abort the save (dont write anything to the database).

嗯，听起来像是功课！好吧，可以怀疑您实际上是在申请学校之类的东西:P

基本上，如果学生在完成注册时没有提供至少一张证书，则将其从数据库中完全删除.

Hmmm, this sounds like homework! Well, benefit of the doubt that you are actually making an application for a school or something :P

Basically, if the student does not supply at least one certificate by the time they finish signing up, remove them completely from the database.

这篇关于关于逻辑的简单问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！