Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

ER Assistant DB Design


  • Please log in to reply
4 replies to this topic

#1 Iscariot

Iscariot

  • Members
  • 49 posts
  • OFFLINE
  •  
  • Local time:04:14 AM

Posted 01 May 2009 - 12:45 AM

I'm trying to design a Database for an online vendor of trading cards, specifically Magic the Gathering.
The database will be used for an inventory of collectible trading cards. The database will maintain the number of items in stock, information of items, pending orders, processed orders, customer information.
So far this is what I have.
Posted Image

All in all, does this seem complete?

Edited by Iscariot, 01 May 2009 - 12:52 AM.


BC AdBot (Login to Remove)

 


#2 jgweed

jgweed

  • Staff Emeritus
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:04:14 AM

Posted 01 May 2009 - 08:08 AM

Do you intent to have one entry per card, even if duplicate inventory?
Whereof one cannot speak, thereof one should be silent.

#3 Iscariot

Iscariot
  • Topic Starter

  • Members
  • 49 posts
  • OFFLINE
  •  
  • Local time:04:14 AM

Posted 01 May 2009 - 10:33 AM

Do you intent to have one entry per card, even if duplicate inventory?

I'm sorry, what do you mean by duplicate inventory?

#4 jgweed

jgweed

  • Staff Emeritus
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:04:14 AM

Posted 01 May 2009 - 11:02 AM

Two cards that fall under the same descriptive categories- - - Same Name,Set,Rarity, and so on.
Does the physical condition of the card need to be included (as with stamps or coins)?

Edited by jgweed, 01 May 2009 - 11:02 AM.

Whereof one cannot speak, thereof one should be silent.

#5 Iscariot

Iscariot
  • Topic Starter

  • Members
  • 49 posts
  • OFFLINE
  •  
  • Local time:04:14 AM

Posted 01 May 2009 - 03:17 PM

If a card has the same characteristics then it affects the CardStock number.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users