Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

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.

Latest News: Hackers Breach Network of LabCorp, US' Biggest Blood Testing Laboratories

Featured Deal: Get 96% off the MCSA SQL Server Training Deal

ER Assistant DB Design

Started by Iscariot , May 01 2009 12:45 AM

Please log in to reply

4 replies to this topic

#1 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.

Back to top

BC AdBot (Login to Remove)

BleepingComputer.com
Register to remove ads

#2 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.

Back to top

#3 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?

Back to top

#4 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.