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
Asif Aziz
1.7k
74
6.2k
How to manage item price in database
Mar 19 2018 5:18 AM
I have two table in my application, one is "item" and "itemprice" and these are already created by a previous developer. The itemprice table contain fields like, unitOfSale , itemPoint, itemSalePrice and itemPurchasePrice, tax. There are some fields those are duplicate in item and itmPrice table.
Can i merge itemPrice table in item table. will it do any negative imapact on architecture,
Do I need to keep the history of itemprice when it changes?
If I need to keep history of price then which architecture should i follow ? one table (merged table) or two table?
Reply
Answers (
4
)
I want to build a ASP.NET MVC SAS based application
Can we consider the following class as Data Class code smell