I am a bit lost in a little SQL problem, to which I need an answer. It will probably be a triviality to you guys. Nevertheless, I am designing a database (it's a uni exercise) and there is a requirement to keep historical data of prices for products. Thus I have a table PRODUCT and table PRODUCTPRICE. Product has a primary key ProdCode. And PRODUCTPRICE has a primary key ProdCode (it's a foreign key as well) and a StartDate. The combination of ProdCode and StartDate would create a PK. An price record with NULL in the EndDate would be the current price of the product. Please let me know if this make sense to you. Ask any subsequent questions if you need more info please. Thank you a lot guys. I am also uploading a diagram of the exercise, if you could please let me know if it makes sense to you. Please remember this is only a database analysis exercise not a real system. Relational-Model-v2.pdf
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.