Apolyton Archive  |  Preserved copy of the Apolyton Civilization Site and its forums as they stood in September 2005. Read-only; nothing here can be posted to or replied to.  |  Forum index |  About this archive |  The 1998–2001 UBB forums
Today on Apolyton WARDELL INTERVIEW PROMO A.C.S. HISTORY CHAPTER 4 GET CIV4 /w FREE PLUS! A.C.S. PHOTO GALLERY GET A.O.M. V1.1
Apolyton Civilization Forums
main| civ2| civ3| civ4| smac| ctp2| ron| moo3| galciv| galciv2| alt| about|
ApolytonPLUS | register | search | faq | new posts | pm (-/-) | upload | members
hall of fame new! | civgroups | civgroups news | interviews | the column | radio | chat | directory | news | store | PLUS
Apolyton Civilization Forums : Powered by vBulletin version 2.0.3 Apolyton Civilization Forums > Miscellaneous > Archive > Off-Topic-Archive > ER diagram HELP :(
Show a Printable Version | Email This Page to Someone! | Receive updates to this thread | Report this to Apolyton news!

bottom of page
  
Author
Thread    < Last Thread     Next Thread > Post New Thread     Post A Reply
Kaak is offline Kaak
King
Lost
May 1999
time: 23:31
  Old Post 22-10-2003 12:23 Visit Kaak's homepage!
Edit/Delete Message Reply w/Quote
#1 Report this post to a moderator
ER diagram HELP :( Support Apolyton, pre-order Civilization IV

Okay, i'm trying to make an ER diagram for the following situation:

You operate a library. The library has books. Each book has a BID, a name , and 1 or more authors. Each author has a name. The library has patrons. each patron has a PID and a name. patrons check out books. a book checkout record contains the date the book was checked out.


Thanks in advance for the help!
Space05us is offline Space05us
King

Nov 2001
time: 17:31
  Old Post 22-10-2003 13:10
Edit/Delete Message Reply w/Quote
#2 Report this post to a moderator
Support Apolyton, buy Civilization: The Boardgame

thats way over my head but I'll bump it just to help you out.
Kaak is offline Kaak
King
Lost
May 1999
time: 23:31
  Old Post 22-10-2003 13:12 Visit Kaak's homepage!
Edit/Delete Message Reply w/Quote
#3 Report this post to a moderator
Support Apolyton buy from Amazon

thanks buddy

radicus is offline radicus
Settler

Aug 2003
time: 05:31
  Old Post 22-10-2003 13:27
Edit/Delete Message Reply w/Quote
#4 Report this post to a moderator
Support Apolyton, buy GURPS/ Alpha Centauri

Master artist!
Space05us is offline Space05us
King

Nov 2001
time: 17:31
  Old Post 22-10-2003 13:40
Edit/Delete Message Reply w/Quote
#5 Report this post to a moderator
Enter the AD-FREE zone

wow, that looks so simple I feel dumb now.

Kaak is offline Kaak
King
Lost
May 1999
time: 23:31
  Old Post 22-10-2003 13:41 Visit Kaak's homepage!
Edit/Delete Message Reply w/Quote
#6 Report this post to a moderator
Support Apolyton buy from Amazon

close, but you are missing book check out record!?! I don't know how to show it...
reds4ever is offline reds4ever
Prince
of the Spion Kop
Mar 2001
time: 05:31
  Old Post 22-10-2003 16:27
Edit/Delete Message Reply w/Quote
#7 Report this post to a moderator
Support Apolyton, buy Civilization III: Complete

quote:
 Originally posted by Kaak
close, but you are missing book check out record!?! I don't know how to show it...


as a separate Entity?
reds4ever is offline reds4ever
Prince
of the Spion Kop
Mar 2001
time: 05:31
  Old Post 22-10-2003 16:29
Edit/Delete Message Reply w/Quote
#8 Report this post to a moderator
Support Apolyton, buy Civilization: The Boardgame

model an Entity 'date' which has a many-many relationship with 'checkout'?
Az is offline Az
King
MACEDONIA - It's the name of the sovereign country to the north of Greece
Apr 2000
time: 07:31
  Old Post 22-10-2003 16:37
Edit/Delete Message Reply w/Quote
#9 Report this post to a moderator
Support Apolyton buy from Amazon

* Az reminds himself that he could do this stuff some time ago.
Adagio is offline Adagio
Emperor

Jun 2001
time: 06:31
  Old Post 22-10-2003 17:04
Edit/Delete Message Reply w/Quote
#10 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations

quote:
 Originally posted by radicus
Master artist!


Wasn't it suposed to be a many to many relationship between book and author?

One author could have written several books, while one book could be written by several authors?

Otherwise looks fine

* Adagio reminds himself he's not that experienced in making those either...

A "Patron", is this the same thing as a customer?
Az is offline Az
King
MACEDONIA - It's the name of the sovereign country to the north of Greece
Apr 2000
time: 07:31
  Old Post 22-10-2003 17:09
Edit/Delete Message Reply w/Quote
#11 Report this post to a moderator
Remove this text

quote:
 Originally posted by Kaak
close, but you are missing book check out record!?! I don't know how to show it...


The 'Check out' is a separate identity. it should be perfect for this.
radicus is offline radicus
Settler

Aug 2003
time: 05:31
  Old Post 22-10-2003 22:17
Edit/Delete Message Reply w/Quote
#12 Report this post to a moderator
Support Apolyton, buy GURPS/ Alpha Centauri

quote:
 Originally posted by ADG
A "Patron", is this the same thing as a customer?



yup!
Adagio is offline Adagio
Emperor

Jun 2001
time: 06:31
  Old Post 22-10-2003 22:20
Edit/Delete Message Reply w/Quote
#13 Report this post to a moderator
Browse Apolyton AD-FREE

Thx... learning new words every day

  < Last Thread     Next Thread > Post New Thread     Post A Reply
All times are GMT. The time now is 05:31.
Apolyton Time is 00:31.		     top of page
Rate This Thread:
archivepost
Forum Jump:
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
 




Contact Us - Apolyton Civilization Site - Support Us!

Building a better Apolyton through better information. Click here and take our poll!
Non-US visitors, click here!

Powered by: vBulletin Version 2.0.3
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Page generated in 0.0424 seconds (89.32% PHP - 10.68% MySQL) with 31 queries
Page Loading Time:

Support Apolyton: Amazon USA | Amazon UK | Amazon DE | Amazon FR |
Support Apolyton and get FREE PLUS, Buy from Chips&Bits: Galactic Civilizations | Galactic Civilizations: Deluxe Edition | Call to Power 2 | Civilization: The Boardgame | GURPS/ Alpha Centauri | Alpha Centauri | Civilization IV | Civilization III: Complete |

Front Page | Civilization IV | Civilization III | Civilization II | Call to Power II | Alpha Centauri | Master of Orion III
Rise of Nations | Galactic Civilizations | Galactic Civilizations II | Misc
Alt.Civs | Civ I | C:CtP I | About | News | Directory | Apolyton Store | Forums | Chat | Columns | Interviews | Newsletter
Scenario League | CSC | Clash of Civs | Spanish Site | CtP Maps | Cradle of Civ | WesW's Ctp1/2 Site | Civ3 Haven

apolyton.net | apolyton.com | civilization2.net | civilization3.net | civilization4.net | civilizationiv.info | calltopower.net | galciv.net | galciv2.net | moo3.net