TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Guest User
Tech Writer
357
121.4k
Simple one for a DBA
Apr 6 2012 5:12 AM
Hi
I am designing and implementing an E-Commerce solution and needed a pointer on table constraints
I have the following tables
Category
CategoryId PK
CategoryName
Description
Version
CustomerEntity
CustomerId PK
CustomerName
City
Country
Version
Product
ProductId
CategoryId
ProductName
UnitPrice
UnitsInStock
Version
Order
OrderId
CustomerId
OrderDate
Version
OrderDetails
OrderId
ProductId
UnitPrice
Quantity
Version
Given the above I would like to implement a shopping cart table but do not know what columns to have nor what tables to reference with a Foreign Key?
Thanks
Reply
Answers (
5
)
sql
How to put the between and operatorsin Case condition...