English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2 answers

GAMES:
- GameID
- Title
- VendorID
- RatingID
- MSRP
- CategoryID

CATEGORY
- CategoryID
- CategoryName
- CategoryDescription

RATING
- RatingID
- RatingCategory
- RatingReason

VENDOR
- VendorID
- VendorName
- VendorWebsite
- VendorSupportPhone
- VendorSupportEmail

CUSTOMER
- CustomerID
- CustomerName (probably multiple fields here)
- CustomerAddress
- CustomerPhone
- CustomerEmail
- CustomerContactPrefID

CUSTOMERCONTACTPREF
- NoContact
- Phone
- Email

INVENTORY
- GameID
- Quantity

PURCHASES
- CustomerID
- GameID
- TransactionID

TRANSACTION
- TransactionID
- PaymentType
- PaymentAmount
- PaymentDate


That's as far as I'll go on the question. I'm sure you could normalize the data even more but I think you get the point.

2007-03-13 04:20:34 · answer #1 · answered by Jim Maryland 7 · 0 0

THis would mimic most any retail shop.

A database should include the

Game Title
Author
Distributor
Cost
Shipping Costs
Retail Suggested
Retail Actual
Number ordered
Number received
Date Ordered
Date Received
Current Number in Stock.
Date of Sale
Amount Sold

2007-03-13 04:14:47 · answer #2 · answered by Marvinator 7 · 0 0

fedest.com, questions and answers