Differences
This shows you the differences between two versions of the page.
|
tech:others:color_coordination_puzzle_solution_explanation [2014/11/15 09:13] |
tech:others:color_coordination_puzzle_solution_explanation [2014/11/15 09:13] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | To page explains why the [[tech:others:color_coordination_puzzle_solution_by_sql|Solution by SQL]] solves the puzzle [[tech:others:color_coordination_puzzle|Color Coordination Puzzle]] | ||
| + | |||
| + | If you run the SQL here is what you will get: | ||
| + | |||
| + | ^blk_num ^ color_position ^ color_cd ^ | ||
| + | | 2 | 0 | Y | | ||
| + | | 1 | 2 | R | | ||
| + | | 6 | 4 | W | | ||
| + | | 0 | 3 | G | | ||
| + | | 3 | 1 | X | | ||
| + | | 4 | 5 | B | | ||
| + | | 5 | 0 | Y | | ||
| + | |||
| + | What does this output mean?\\ | ||
| + | |||
| + | The table CIRCLES has the following definition: \\ | ||
| + | |||
| + | BLK_NUM is the Block Number or the Piece Number (corresponds to each cookie and ranges from 0 to 6) COLOR_POSITION ranges from 0 to 5 and is useful in determining the sequence of the dots on the cookie COLOR_CD is of course the color of the dot. \\ | ||
| + | |||
| + | When we defined the table data each cookie was given a number from 0 to 6. This is the original number. \\ | ||
| + | |||
| + | The result is the order in which you need to place the cookies (based on the original number). So you place cookie # 2, 1st and keep going clockwise, placing cookie #1 next and so on until you complete the circle. You place the last cookie (# 5) in the center. \\ | ||
| + | |||
| + | The 2nd and 3rd values in the output help you rotate the placed cookies and align the dots. So rotate (or place cookie) # 1 so that Yellow is facing the center. Red dot faces center for cookie # 2 and so on. \\ | ||
| + | |||
| + | Check out the picture below as well for the explanation of the solution above. | ||
| + | |||
| + | {{general:discs_puzzle_sol.jpg|}} | ||
