Good Evening,
I am developing an ASP.NET app (obviously) and one of the problems I have with the database is that there are 3 sections of the site (amongst others):
1) Auction
2) eCommerce
3) Product Info section
This site is about car modifying, so product information (new wheels, new seats, etc) is important to have.
But, if I have a database with product info (which is planned, along with ratings of how well the part would work with a specified other part), then this will create redundancy if a user is selling exactly the same part and adds it in another table (i.e. one related to the auction). Auction and eCommerce will be merged into the same tables (i.e. there'll be a bool, along with other fields, if the sale is an auction or "buy it now" - no seperate tables as I currently have as this will be a waste of resources).
Now the problems are several:
1) If a user adds a product to the tables required for either a sale or auction, which is not in the ...
Go to the complete details ...