识别图书馆系统中的重复书籍 [英] Identify duplicate books in a library system

问题描述

我为论文项目开发了一个图书馆系统。我的问题是这个，


我有5本书，其中3本书和作者有相同的标题，

AccessionNo - ----- ISBN ------- 标题 ------------------ 作者

00001 ---------------------- 07-123 ------------ English 101 -------------------- Keign

00002 ------------------ ---- 06-411 -----------数学------------------ Rey Sean

00003-- -------------------- 07-123 ------------ English 101 ------------- -------- Keign

00004 ---------------------- 05-424 -----目的驱动生活--------- Blen John

00005 ---------------------- 07-123 --- ---------英语101 --------------------- Keign



我我不知道如何告诉我的系统AccessionNo 00001,00003和00004是同一本书。我最初的想法是，我只是比较书的ISBN，因为每本书都有一个独特的ISBN号，但问题是，未在国际上出版的本地书籍没有ISBN号。

请帮助我... tnx提前



比昨天更好（-.-）

Hi,

Im developing a Library System for my Thesis Project. My Problem is this,

I have 5 books and the 3 of which has the same title and authors,

AccessionNo------ISBN -------Title------------------Author
00001----------------------07-123------------English 101-------------------- Keign
00002----------------------06-411-----------Mathematics------------------Rey Sean
00003----------------------07-123------------English 101---------------------Keign
00004----------------------05-424-----The Purpose Driven Life---------Blen John
00005----------------------07-123------------English 101---------------------Keign


I don''t have an idea on how to tell my system that AccessionNo 00001, 00003 and 00004 are the same book. My initial idea is that i''ll just compare the ISBN of the book since each book has a unique ISBN Number, but the problem is, local books that is not published internationally has no ISBN No..

please help me out... tnx in advance


Better Than Yesterday (-.-)

推荐答案

比较ISBN号码或书名。

对于那些没有ISBN的书籍，不给他们分配一个号码，也把这个号码放在书上。


问候

>> ALI<<

Compare ISBN Numbers or Book Title.
And for those books which have no ISBN no assign them a number and put that number on book also.

Regards
>> ALI <<

我不知道如何告诉我的系统AccessionNo 00001,00003和00004是同一本书。

I don''t have an idea on how to tell my system that AccessionNo 00001, 00003 and 00004 are the same book.

我的错误AccessionNo 00001,00003和00005..hehehe sori 4


比昨天更好（ -.-）

My mistake AccessionNo 00001, 00003 and 00005..hehehe sori 4 that


Better Than Yesterday (-.-)

我认为这里的主要问题不是如何的技术细节，而是关于什么的决定。


您需要确定要将哪些字段视为标识相同字段。书。一旦你这样做，检查它们是否相同就很简单。


MS Access中的一个向导将构建一个查询，以便您检查重复记录，在您选择的字段上。这将为您提供基础知识。

I think the main issue here is not the technical details of how, but the decision as to what.

You need to decide which fields you want to treat as identifying the "same" book. Once you do that, it''s simple to check whether they are the same.

One of the wizards in MS Access will build a query for you to check for duplicate records, based on the fields you choose. This will hive you the basics to build on.

这篇关于识别图书馆系统中的重复书籍的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！