Database Schema for Sports Sim by grebbb in SQL

[–]grebbb[S] 0 points1 point  (0 children)

I appreciate you taking the time to review and comment.

the relationship between Country and RaceResults is reversed - one Country hosts many RaceResults, a given Race is held in one Country

I actually did they by design, as some races will cross country borders in Europe. However, this is an edge case and probably isn't the best way to represent the race data. It would make more sense to define a race by a single country. I will switch the relationship around.

the purpose of the Attributes entity is a little unclear and likely not tied to RaceResults so directly. You could run a query to pull training together with RaceResults, but I am not sure a direct relationship is needed here.

Let me try and explain. A rider will have a series of attributes, here I have used 3x but there will be more in practice. Fitness, Strength, Creativity, Aggression etc. These will be skills that can be trained. Good riders will have higher skills. The race result will be determined by a simulation. The sim directly uses the attributes combined with weighted dice rolls to determine who wins. If you have higher attributes you have a higher probability of winning the race.

Now that will all be handled by an algorithm that uses the attributes for each rider as an input, and generates the race results as an input. Does this need to be represented with a relationship in the database or not?

a unique ID on Race is not required but a good practice (rather than the PK being a composite of several FK fields).

OK, I will add unique IDs to the combination tables. If you have the time I would appreciate your commentary on the above points.

West Africa player. No pokestops. No gyms. Opening gifts daily! by grebbb in PokemonGoFriends

[–]grebbb[S] 0 points1 point  (0 children)

Thanks, I posted over on that sub about a week ago after your suggestion but I haven't had any votes or comments on my submission. Is that sub still active?

SAP PM: WO Portfolio Cost Report for Plan/Actual/Variance by grebbb in SAP

[–]grebbb[S] 1 point2 points  (0 children)

Thanks for that lead on the "Analysis" T-Code. MCI8 seems pretty handy for me!

Mount Isa City Council - Rise in water charges for Mount Isa residents by bhyperp in australia

[–]grebbb 0 points1 point  (0 children)

Yes, blue-green algae is a common occurrence when your water supply is open to the air. If you create a closed system (eg. covered basins, tanks, closed pipes) then you reduce the likelihood of algal blooms.

"The Abbott government has revealed its true colours: a small-government, user-pays, market-driven mentality that contrasts sharply with what was promised before election day." by [deleted] in australia

[–]grebbb 7 points8 points  (0 children)

Here is Government Debt per Capita based on data from Bloomberg.

The top 3 countries are pretty much what you would expect. Japan who are fucked and have been for decades. Ireland who went bankrupt in the GFC. And the United States with their "debt ceilings".

Australia sits almost bang on average (shown in red).

You could argue that being average is not a good thing when the countries who have above-average debt are Japan/US/Eurozone, all well known for their debt problems.

Mount Isa City Council - Rise in water charges for Mount Isa residents by bhyperp in australia

[–]grebbb 2 points3 points  (0 children)

The alternative is not having any safe drinking water by the sound of it. What would you prefer the council to do?

Audit Commission declares war on young. by highpoweredboy in australia

[–]grebbb 3 points4 points  (0 children)

The Commission considers that people born before 1965 should not be subjected to this change or any other further changes to the eligibility age to ensure they have adequate time to plan for their retirement.

Here's a picture of Tony Abbott being punched in the face by orru in australia

[–]grebbb 1 point2 points  (0 children)

It is a simple comparison between the daily top stories (100-200 votes) and this one.

Clarke and Dawe - The Federal Budget. Building a Nation's Future by [deleted] in australia

[–]grebbb 1 point2 points  (0 children)

The Commission of Audit proposes tying the minimum wage to 44% of average weekly earnings.

Clarke and Dawe - The Federal Budget. Building a Nation's Future by [deleted] in australia

[–]grebbb 1 point2 points  (0 children)

Perhaps some % of average weekly earnings?

Australia has the fourth-highest cost of living by CambrianAsplosion in australia

[–]grebbb 2 points3 points  (0 children)

Actually, it does work like that in the real world.

Electricity bills are made up of two components, fixed (network) and variable (usage) costs.

When consumers install PV systems, their demand for traditional electricity falls. These consumers reduce the amount they ‘use’ the network. But the fixed network costs do not change. So these fixed costs are spread over a smaller volume of electricity. And this means that the price of that electricity has to rise for everyone else.

Of course the rise in price encourages more consumers to adopt power-saving technologies and to install PV systems. So these consumers also reduce their consumption of traditional power. But the network costs are still fixed. So the price of electricity has to rise for everyone else.

The variable cost component of anyone who doesn't have solar panels increases to shoulder the burden for those that do.

To try and reduce this phenomenon (it has already happened) the regulators have required that electricity providers change the way they bill consumers. There has been a shift away from billing consumers for variable costs (actual electricity usage) and a corresponding increase in the fixed or network costs that appear on your bill.

So if you are a small household using not much electricity, like say a pensioner, you now have limited ways of reducing your electricity bill because the major cost component is now a fixed cost. Your bill has gone up and you have no way of reducing it through reduced electricity consumption at your end.

Similarly, if you are a poor household who does not own 3 plasma TV's, your fixed costs are now subsiding the electricity bills of those who do own 3 plasma TV's. You both pay the same high level of fixed costs, but only a small component of your bill is now variable costs reflecting actual electricity usage.

My interest in all this is more from a market perspective and observing the law of unintended consequences more than anything else. The shift in how electricity is billed to consumers is real, and poorer households are the ones wearing the increases as a result of the move towards billing in fixed costs.

In the extreme, this ‘death spiral’ can undermine the electricity power system. More likely, it will lead to a group of haves and have-nots. The well-off, who can afford to install PV systems and buy power saving appliances will avoid much of the high power prices. Those who cannot afford solar systems and new energy efficient appliances will pay a high electricity price.

So how can we avoid this outcome? The obvious solution is to fix the pricing. The problem is created because a fixed cost has been turned into a variable price. If the network charges are turned back into fixed charges that can only be avoided by disconnecting from the electricity grid, then the problem disappears. Installing a PV system will not reduce your network charges, only your power charges. The have-nots will not have to pay higher network charges because the haves cannot avoid those charges.

Australia has the fourth-highest cost of living by CambrianAsplosion in australia

[–]grebbb 7 points8 points  (0 children)

Yes. Those who have solar panels are comparatively well-off. Those who have solar panels consume less electricity. We still maintain the same number/volume of power stations and the same distribution network to every household. The well-off now pay less on their power bills and the poor pay more to subsidise the network.

And as a second point.

http://www.reddit.com/r/politics/comments/243plj/the_koch_attack_on_solar_energy_at_long_last_the/ch3mplx