救命!复杂的关系 [英] Help! Complicated Relationships
问题描述
大家好!
我正在尝试为一个库存设计数据库,该库可存储一系列媒体。 (见链接)
http: //homepage.ntlworld.com/james.m...te/library.gif
每位用户可以进行多次查询/预订/贷款
(如果我能得到正确的查询,我可以做其余的事)。每个查询
可以在每个库存物品上进行,每个库存物品都是
一个副本,每个副本都包含物品信息。每个项目可以是音频,书籍或乐谱(乐谱)
。
我真的很感激任何观察或建议我在哪里/>
正确/我出错了。我真的很感激
帮助我应该做出什么样的查询,这样才有可能
最终让用户对任何音频项目进行查询。
谢谢你的阅读,
詹姆斯
Hello Everyone!
I''m trying to design a database for a library that stocks a range
of media. (see link)
http://homepage.ntlworld.com/james.m...te/library.gif
Each user can make many enquiries / reservations / loans
(if I can get enquiries right, I can do the rest). Every Enquiry
can be made on each item of stock, every item of stock is
a copy and every copy contains item info. Each item can be
of audio, book or score (musical score).
I would really appreciate any observations or advice where I''m
going right / where I''m going wrong. I would really appreciate
help with what queries I should make which will make it possible
eventually for a User to make an enquiry about any item of audio.
Thankyou for reading,
James
推荐答案
嗨詹姆斯
" James" < JA ********* @ ntlworld.com> schrieb im Newsbeitrag
新闻:XoQic.97
Hi James
"James" <ja*********@ntlworld.com> schrieb im Newsbeitrag
news:XoQic.97
cy3.25@newsfe1-win ...
cy3.25@newsfe1-win...
大家好!
我正在尝试为库存设计一个数据库,这个库可以存储各种媒体。 (见链接)
http: //homepage.ntlworld.com/james.m...te/library.gif
首先,我会考虑一下命名约定
(表格和字段)tblUser看起来比用户好得多;)
远离[E-Mail]或[Active]等字段名称会员?]和
空格, - 和?使未来的生活更轻松。 (查询,
sql)等。
我想念ID-Field(ID,PrimaryKey,Autonumber)
你必须处理你的DBDesign:没有关系到表预订?
彼得
First of all, i would think a little about the naming-conventions
(tables and fields) tblUser looks much better than user-;)
Stay away from fieldnames like [E-Mail] or [Active Member?] and from
Spaces, "-" and ?. Makes life much easier in futuractions. (Queries,
sql)etc.
I miss the ID-Field (ID, PrimaryKey, Autonumber)
You have to work on your DBDesign: No Relation to the table Reservation?
Peter
当我看你的设计我看到你有一个查询功能并且
没有查看书籍的功能,所以我想也许一个询问是什么时候你会查看一本书,而不是查询一本书的存在。
这是正确的吗?
如果条形码是
不是唯一的,你在音频和copynumber中省略了copynumber应该是PK每个副本。
罗伯特
" James" < JA ********* @ ntlworld.com>在消息中写道
news:XoQic.97
When I look at your design I see that you have a function for "enquiry" and
no function for checking out books, so I''m thinking maybe an enquiry is when
you check out a book as opposed to inquiring about the existence of a book.
Is this correct?
You left out copynumber in audio and copynumber should be a PK if barcode is
not unique for each copy.
Robert
"James" <ja*********@ntlworld.com> wrote in message
news:XoQic.97
这篇关于救命!复杂的关系的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!