Question

Closed. This question needs to be more focused. It is not currently accepting answers.

更新问题,只通过编辑这一员额。

Closed 3 years ago.

Improve this question

我把跟踪每天运行、然后跟踪次日库存的图象放在一起,如果想说明如何设计数据库关系,我几年来没有这样做,那么我要求某些数据库Ninjas提供某种帮助。

当主要钥匙在标值上时,同一标尺将有一天1+日2的条目。

Any help much appreciated

数据库图表

idhar koi nangi chuddi ki tasweer lga bharrway

Answer 1

这样做的一个途径是提供一个<代码>Stock的表格,该表格储存一般信息,另一个表格<编码>StockPrices,储存每天的存货摘要。

<编码>Stock的主要关键内容是Ticker<>/code>,因为它独特地确定了一个库存,而且非常简短/易于理解。


The primary key for StockPrices will be (Ticker,Date). The column Ticker on this table with have a foreign key relation to the primary key of Stock.
对两天之间的任何比较可以简单地回答:
SELECT *
FROM Stock s
INNER JOIN StockPrices spDay1 ON s.ticker = spDay1.ticker AND spDay1.date = [first day you want to compare to here]
INNER JOIN StockPrices spDay2 ON s.ticker = spDay2.ticker AND spDay2.date = DATEADD(dd, 1, spDay1.date)

友情链接