表的规范化

发布于 2024-12-11 09:38:57 字数 850 浏览 0 评论 0原文

我正在尝试使用 VB.Net 和 MySQL 作为数据库创建一个简单的注册程序。这是我的基本信息简单表格

在此处输入图像描述

但是，我正在尝试提高我在表格标准化方面的基本知识这就是为什么我将日期字段分开以避免（比方说在一天内）重复插入相同的日期。我的意思是，当一天有 50 个人注册时，它只会在 tblRegDate 表中添加单个日期（记录），而不是在表中添加 50 次。有什么办法可以做到这一点吗？在 VB.Net 和 MySQL 中可以吗？或者更确切地说，我应该添加或修改某些字段吗？或者我应该在VB.Net中设定一个条件？上表是我朋友教我的，但我发现它并没有消除冗余。请给我任何指示或引导我到有简单教程的网站。提前致谢！

这是我的 MySQL 代码：

CREATE TABLE tblInfo(
       Number INT AUTO_INCREMENT,
       LastName VARCHAR(45),
       FirstName VARCHAR(45),
       MiddleName VARCHAR(45),
       Gender ENUM(M,F),
       BirthDate DATE,
       PRIMARY KEY(Number));

CREATE TABLE tblRegDate(
       IDRegDate INT AUTO_INCREMENT,
       Date TIMESTAMP,
       Number INT,
       PRIMARY KEY(IDRegDate),
       FOREIGN KEY(Number) REFERENCES tblInfo(Number));

原文

I am trying to create a simple Registration Program using VB.Net and MySQL for its database. Here's my simple table for the basic Information

enter image description here

However, I am attempting to improve my basic knowledge in normalization of table and that's why I separated the Date field to avoid, let say in one day, the repeated insertion of the same date. I mean, when 50 individuals registered in one day, it will simply add a single date(record) in tblRegDate table instead of adding it up for 50 times in a table. Is there any way to do this? Is it possible in VB.Net and MySQL? Or rather, should I add or modify some field? or should I make a condition in VB.Net? The table above is what my friend taught me but I discovered that it doesn't eliminate the redundancy. Kindly give me any instruction or direct me to site where there's a simple tutorial for this. Thanks in advance!

here's my MySQL codes:

CREATE TABLE tblInfo(
       Number INT AUTO_INCREMENT,
       LastName VARCHAR(45),
       FirstName VARCHAR(45),
       MiddleName VARCHAR(45),
       Gender ENUM(M,F),
       BirthDate DATE,
       PRIMARY KEY(Number));

CREATE TABLE tblRegDate(
       IDRegDate INT AUTO_INCREMENT,
       Date TIMESTAMP,
       Number INT,
       PRIMARY KEY(IDRegDate),
       FOREIGN KEY(Number) REFERENCES tblInfo(Number));

分享到QQ

分享到微博