473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help! Complicated Relationships

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

Nov 12 '05 #1
15 1822
Hi James

"James" <ja*********@ntlworld.com> schrieb im Newsbeitrag
news:XoQic.97$cy3.25@newsfe1-win...
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


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
Nov 12 '05 #2
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$cy3.25@newsfe1-win...
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

Nov 12 '05 #3
"Peter Steimann[MVP Access]" <PS************@Timesoft.ch> wrote in message
news:c6************@ID-93817.news.uni-berlin.de...
Hi James

"James" <ja*********@ntlworld.com> schrieb im Newsbeitrag
news:XoQic.97$cy3.25@newsfe1-win...
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


First of all, i would think a little about the naming-conventions
(tables and fields) tblUser looks much better than user-;)

Peter, I think "user" is just fine for a table of users - if there will only
ever be one of them. Otherwise i'd go with "users".
"tblUser" is not good - there's no valid reason to use "tbl" "qry" prefixes
for database object names.

--
btw if this were a table of linux users do you think we could we call it
"lusers" <g>


Nov 12 '05 #4
Hello Robert,

Firstly, thankyou very much for replying to my cry for help!
I'm keen to emphasise that any comments/advice I receive
is very much appreciated.

Apologies for the vague post; I must admit, it isn't the
clearest post I've ever made!

The database I'm creating has (for my knowledge) developed
a lot since 4 o'clock today. Please check:
http://homepage.ntlworld.com/james.m...te/library.gif
as I've updated the image of the relationships in my database.

As far and Enquiries and Audio go, everything seems to work ok!! :oD
I'm thinking that the rest of the database will be easy once I've
worked out how I'm going to work with it in its present state.
This is why I left out any mention of other tables because I
wanted to concentrate on the enquiry-audio part of the database
(hope this makes sense!). The enquiries made by users are just
'points of interest' (It's pretty pointless but I had to include it), users
can make an enquiry on any item of stock (to find out whether its
on loan etc). Other actions the user can perform are:
2. reserving an item and 3. loaning or borrowing an item.
Of course, each user can have multiple enquiries, multiple reservations
and multiple loans.
The 'catalogue' as I'm sure you've guessed, is a way of controlling
each unique item by type: each item can either be a 'audio,' 'book,'
or 'Score.' I'm hoping to connect all these tables in the same fashion as
'audio' is connected now. I think this will work, what do you think ????

Naming conventions etc have been intentionally ignored because
I feel that the most important thing is to get the model working.

Ok, I hope that make things a little clearer. Let me know your
thoughts and I'll try to help you to help me!

Thanks Robert,
James

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
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$cy3.25@newsfe1-win...
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


Nov 12 '05 #5
Hi Peter,

Thanks for your reply.

I've just updated the image I captured of database relationships.
Please check again.

The naming conventions will be important, I did forget about
them earlier on nevertheless thankyou for reminding me! :o)

I wanted to concentrate on enquiries for audio as I think that
if I were to get this right, I could do the rest. As it stands,
everything appears to work! horray! However, I will probably
need more help so I've made a post lower down that makes
things clearer, sorry I can't type it all out again - my fingers
are beginning to ache!

James
"Peter Steimann[MVP Access]" <PS************@Timesoft.ch> wrote in message
news:c6************@ID-93817.news.uni-berlin.de...
Hi James

"James" <ja*********@ntlworld.com> schrieb im Newsbeitrag
news:XoQic.97$cy3.25@newsfe1-win...
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


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

Nov 12 '05 #6
Hi James,

I built a library database a while back....if your interested I can send you
a copy for review, it may be of some help. Let me know which version of
Access your using.
Cheers,

Dave

"James" <ja*********@ntlworld.com> wrote in message
news:XoQic.97$cy3.25@newsfe1-win...
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

Nov 12 '05 #7
Hi Dave,

I'm using Access 2002 (think its part of Office XP).
If you could send it that would be excellent.
My Email is: ja*********@ntlworld.com

Many thanks,

James

"Dave Brydon" <db*****@ns.sympatico.ca> wrote in message
news:iP*********************@ursa-nb00s0.nbnet.nb.ca...
Hi James,

I built a library database a while back....if your interested I can send you a copy for review, it may be of some help. Let me know which version of
Access your using.
Cheers,

Dave

"James" <ja*********@ntlworld.com> wrote in message
news:XoQic.97$cy3.25@newsfe1-win...
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


Nov 12 '05 #8
Okay. I see that you have a separate item Id and item barcode and item copy
number. I didn't see that at first. Each individual item in the library
can be identified with the item id or the combination of item barcode + copy
number. So the copy number in the Book table is not needed. It looked to
me at first like you had forgotten to put the copy number in the audio
table. Having 2 ways of identifying a book is redundant, but it might be
easier for the people who handle the books to work with a single number (if
they even look at the number).

I think you're on the right track. Go for it!

Robert
"James" <ja*********@ntlworld.com> wrote in message
news:e_Sic.146$cy3.82@newsfe1-win...
Hello Robert,

Firstly, thankyou very much for replying to my cry for help!
I'm keen to emphasise that any comments/advice I receive
is very much appreciated.

Apologies for the vague post; I must admit, it isn't the
clearest post I've ever made!

The database I'm creating has (for my knowledge) developed
a lot since 4 o'clock today. Please check:
http://homepage.ntlworld.com/james.m...te/library.gif
as I've updated the image of the relationships in my database.

As far and Enquiries and Audio go, everything seems to work ok!! :oD
I'm thinking that the rest of the database will be easy once I've
worked out how I'm going to work with it in its present state.
This is why I left out any mention of other tables because I
wanted to concentrate on the enquiry-audio part of the database
(hope this makes sense!). The enquiries made by users are just
'points of interest' (It's pretty pointless but I had to include it), users can make an enquiry on any item of stock (to find out whether its
on loan etc). Other actions the user can perform are:
2. reserving an item and 3. loaning or borrowing an item.
Of course, each user can have multiple enquiries, multiple reservations
and multiple loans.
The 'catalogue' as I'm sure you've guessed, is a way of controlling
each unique item by type: each item can either be a 'audio,' 'book,'
or 'Score.' I'm hoping to connect all these tables in the same fashion as
'audio' is connected now. I think this will work, what do you think ????

Naming conventions etc have been intentionally ignored because
I feel that the most important thing is to get the model working.

Ok, I hope that make things a little clearer. Let me know your
thoughts and I'll try to help you to help me!

Thanks Robert,
James

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
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$cy3.25@newsfe1-win...
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



Nov 12 '05 #9
:oD Big Smiles!

Thanks for reminding me. I've made the changes (this
will also apply to table 'Score' which is yet another media type.

I've decided to migrate all attributes that all media types
have in common (i.e. a 'title' and a 'category') to the
catalogue. This should make things better. I've got until
Tuesday afternoon to complete this! agh!

Thanks for your help, and if you want, I can keep you
updated? (I might need the help :oP )
James

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
Okay. I see that you have a separate item Id and item barcode and item copy number. I didn't see that at first. Each individual item in the library
can be identified with the item id or the combination of item barcode + copy number. So the copy number in the Book table is not needed. It looked to
me at first like you had forgotten to put the copy number in the audio
table. Having 2 ways of identifying a book is redundant, but it might be
easier for the people who handle the books to work with a single number (if they even look at the number).

I think you're on the right track. Go for it!

Robert
"James" <ja*********@ntlworld.com> wrote in message
news:e_Sic.146$cy3.82@newsfe1-win...
Hello Robert,

Firstly, thankyou very much for replying to my cry for help!
I'm keen to emphasise that any comments/advice I receive
is very much appreciated.

Apologies for the vague post; I must admit, it isn't the
clearest post I've ever made!

The database I'm creating has (for my knowledge) developed
a lot since 4 o'clock today. Please check:
http://homepage.ntlworld.com/james.m...te/library.gif
as I've updated the image of the relationships in my database.

As far and Enquiries and Audio go, everything seems to work ok!! :oD
I'm thinking that the rest of the database will be easy once I've
worked out how I'm going to work with it in its present state.
This is why I left out any mention of other tables because I
wanted to concentrate on the enquiry-audio part of the database
(hope this makes sense!). The enquiries made by users are just
'points of interest' (It's pretty pointless but I had to include it),

users
can make an enquiry on any item of stock (to find out whether its
on loan etc). Other actions the user can perform are:
2. reserving an item and 3. loaning or borrowing an item.
Of course, each user can have multiple enquiries, multiple reservations
and multiple loans.
The 'catalogue' as I'm sure you've guessed, is a way of controlling
each unique item by type: each item can either be a 'audio,' 'book,'
or 'Score.' I'm hoping to connect all these tables in the same fashion as 'audio' is connected now. I think this will work, what do you think ????

Naming conventions etc have been intentionally ignored because
I feel that the most important thing is to get the model working.

Ok, I hope that make things a little clearer. Let me know your
thoughts and I'll try to help you to help me!

Thanks Robert,
James

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
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$cy3.25@newsfe1-win...
> 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
>
>
>



Nov 12 '05 #10
Hi John

"John Winterbottom" <as******@hotmail.com> schrieb im Newsbeitrag
news:c6************@ID-185006.news.uni-berlin.de...
"Peter Steimann[MVP Access]" <PS************@Timesoft.ch> wrote in message
news:c6************@ID-93817.news.uni-berlin.de...
Hi James

"James" <ja*********@ntlworld.com> schrieb im Newsbeitrag
news:XoQic.97$cy3.25@newsfe1-win...
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
First of all, i would think a little about the naming-conventions
(tables and fields) tblUser looks much better than user-;)

Peter, I think "user" is just fine for a table of users - if there will only
ever be one of them. Otherwise i'd go with "users".
"tblUser" is not good - there's no valid reason to use "tbl" "qry" prefixes
for database object names.


You can name then however you wan't. Using naming-conventions makes life
easier. That's my experience.

-- btw if this were a table of linux users do you think we could we call it
"lusers" <g>
A user is a user...

Peter






Nov 12 '05 #11
"John Winterbottom" <as******@hotmail.com> wrote in message news:<c6************@ID-185006.news.uni-berlin.de>...
Peter, I think "user" is just fine for a table of users - if there will only
ever be one of them. Otherwise i'd go with "users".
"tblUser" is not good - there's no valid reason to use "tbl" "qry" prefixes
for database object names.


You shouldn't be allowed to be your own straight man :-). I could be
pedantic about this and quote some "lusers":

By common entity naming conventions, an entity name must be singular.
We therefore call the table where we store CDs "CD" and not "CDs." We
use this convention because each entity names an instance. For
example, the "San Francisco 49ers" is an instance of "Football Team,"
not "Football Teams."

MySQL and mSQL
Yarger, Reese and King
O'Reilly 1999

But I don't follow this convention myself even though I am a luser,
err.. instance of lusers, err.. listed in lusers. Although you are
correct about there being no pragmatic reasons for tbl and qry
prefixes (except maybe no duplicate names being allowed -- I like
associating qryData with tblData), it is easier for repliers and
others on the newsgroup to decipher what's going on when someone posts
their Code/SQL if they have such prefixes. I try not to get dogmatic
about naming conventions. Controls, OTOH, sometimes lend themselves
to easier solutions when a naming convention is used. For me, I think
clients really like to see what looks like organization so I'll keep
the tbl and qry prefixes.

James A. Fortune
Nov 12 '05 #12
"James Fortune" <ja******@oakland.edu> wrote in message
news:a6**************************@posting.google.c om...
"John Winterbottom" <as******@hotmail.com> wrote in message

news:<c6************@ID-185006.news.uni-berlin.de>...
Peter, I think "user" is just fine for a table of users - if there will only ever be one of them. Otherwise i'd go with "users".
"tblUser" is not good - there's no valid reason to use "tbl" "qry" prefixes for database object names.


You shouldn't be allowed to be your own straight man :-). I could be
pedantic about this and quote some "lusers":

By common entity naming conventions, an entity name must be singular.
We therefore call the table where we store CDs "CD" and not "CDs." We
use this convention because each entity names an instance. For
example, the "San Francisco 49ers" is an instance of "Football Team,"
not "Football Teams."

Entities are sets, or collections, of things, so it is logical to name them
in the plural.
Nov 12 '05 #13
You're welcome. Yes, keep me updated.

Robert

"James" <ja*********@ntlworld.com> wrote in message
news:VNVic.200$cy3.134@newsfe1-win...
:oD Big Smiles!

Thanks for reminding me. I've made the changes (this
will also apply to table 'Score' which is yet another media type.

I've decided to migrate all attributes that all media types
have in common (i.e. a 'title' and a 'category') to the
catalogue. This should make things better. I've got until
Tuesday afternoon to complete this! agh!

Thanks for your help, and if you want, I can keep you
updated? (I might need the help :oP )
James

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
Okay. I see that you have a separate item Id and item barcode and item

copy
number. I didn't see that at first. Each individual item in the library
can be identified with the item id or the combination of item barcode +

copy
number. So the copy number in the Book table is not needed. It looked to me at first like you had forgotten to put the copy number in the audio
table. Having 2 ways of identifying a book is redundant, but it might be easier for the people who handle the books to work with a single number

(if
they even look at the number).

I think you're on the right track. Go for it!

Robert
"James" <ja*********@ntlworld.com> wrote in message
news:e_Sic.146$cy3.82@newsfe1-win...
Hello Robert,

Firstly, thankyou very much for replying to my cry for help!
I'm keen to emphasise that any comments/advice I receive
is very much appreciated.

Apologies for the vague post; I must admit, it isn't the
clearest post I've ever made!

The database I'm creating has (for my knowledge) developed
a lot since 4 o'clock today. Please check:
http://homepage.ntlworld.com/james.m...te/library.gif
as I've updated the image of the relationships in my database.

As far and Enquiries and Audio go, everything seems to work ok!! :oD
I'm thinking that the rest of the database will be easy once I've
worked out how I'm going to work with it in its present state.
This is why I left out any mention of other tables because I
wanted to concentrate on the enquiry-audio part of the database
(hope this makes sense!). The enquiries made by users are just
'points of interest' (It's pretty pointless but I had to include it),

users
can make an enquiry on any item of stock (to find out whether its
on loan etc). Other actions the user can perform are:
2. reserving an item and 3. loaning or borrowing an item.
Of course, each user can have multiple enquiries, multiple reservations and multiple loans.
The 'catalogue' as I'm sure you've guessed, is a way of controlling
each unique item by type: each item can either be a 'audio,' 'book,'
or 'Score.' I'm hoping to connect all these tables in the same fashion

as 'audio' is connected now. I think this will work, what do you think ????
Naming conventions etc have been intentionally ignored because
I feel that the most important thing is to get the model working.

Ok, I hope that make things a little clearer. Let me know your
thoughts and I'll try to help you to help me!

Thanks Robert,
James

"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
> 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$cy3.25@newsfe1-win...
> > 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
> >
> >
> >
>
>



Nov 12 '05 #14
rkc

"John Winterbottom" <as******@hotmail.com> wrote in message
news:c6************@ID-185006.news.uni-berlin.de...
"James Fortune" <ja******@oakland.edu> wrote in message
news:a6**************************@posting.google.c om...
"John Winterbottom" <as******@hotmail.com> wrote in message news:<c6************@ID-185006.news.uni-berlin.de>...
Peter, I think "user" is just fine for a table of users - if there
will only ever be one of them. Otherwise i'd go with "users".
"tblUser" is not good - there's no valid reason to use "tbl" "qry" prefixes for database object names.
You shouldn't be allowed to be your own straight man :-). I could be
pedantic about this and quote some "lusers":

By common entity naming conventions, an entity name must be singular.
We therefore call the table where we store CDs "CD" and not "CDs." We
use this convention because each entity names an instance. For
example, the "San Francisco 49ers" is an instance of "Football Team,"
not "Football Teams."

Entities are sets, or collections, of things, so it is logical to name

them in the plural.


A single row in a table is not an entities.

SELECT * FROM Employee WHERE EmployeeID = 1 doesn't
return a set of Employees.

If you Google this subject you can read for hours and still just have
to make up your own mind.


Nov 12 '05 #15
"rkc" <rk*@yabba.dabba.do.rochester.rr.bomb> wrote in message
news:Ac*******************@twister.nyroc.rr.com...


Entities are sets, or collections, of things, so it is logical to name them
in the plural.


A single row in a table is not an entities.

SELECT * FROM Employee WHERE EmployeeID = 1 doesn't
return a set of Employees.


no it doesn't , but

SELECT * FROM Employees WHERE Dept = 'Accounting'

probably will, (unless you work for a very small company like me).

If you Google this subject you can read for hours and still just have
to make up your own mind.


This is true. Use whatever works. I once read of a programmer who
endeavoured to make his code as obscure as possible - so he used a most
cryptic naming convention - I believe it was a misguided attempt to anhance
his job security. I would have thought it would have the opposite effect.
Nov 12 '05 #16

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an rtf file created in word. I used the Help...
9
by: Tom | last post by:
A question for gui application programmers. . . I 've got some GUI programs, written in Python/wxPython, and I've got a help button and a help menu item. Also, I've got a compiled file made with...
6
by: wukexin | last post by:
Help me, good men. I find mang books that introduce bit "mang header files",they talk too bit,in fact it is my too fool, I don't learn it, I have do a test program, but I have no correct doing...
3
by: Colin J. Williams | last post by:
Python advertises some basic service: C:\Python24>python Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on win32 Type "help", "copyright", "credits" or "license" for more information. >>> With...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
5
by: Steve | last post by:
I have written a help file (chm) for a DLL and referenced it using Help.ShowHelp My expectation is that a developer using my DLL would be able to access this help file during his development time...
8
by: Mark | last post by:
I have loaded Visual Studio .net on my home computer and my laptop, but my home computer has an abbreviated help screen not 2% of the help on my laptop. All the settings look the same on both...
10
by: JonathanOrlev | last post by:
Hello everybody, I wrote this comment in another message of mine, but decided to post it again as a standalone message. I think that Microsoft's Office 2003 help system is horrible, probably...
1
by: trunxnirvana007 | last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="9B7D5ADD-D8FE-4819-A36C-6DEDAF088CC7"' 'UPGRADE_WARNING: Couldn't resolve...
0
by: hitencontractor | last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003. I added a menu item called "MyApp Help" in the end of the menu bar to show Help-> About. The application...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.