| Re: Loop through array, change headings [message #184445 is a reply to message #184443] |
Wed, 01 January 2014 03:24   |
Beauregard T. Shagnas
Messages: 154
Registered: September 2010
Karma:
|
Senior Member |
|
|
richard the sto0pid wrote:
> Suppose I had a table that had 12 columns and 365 rows. Which would
> represent a calendar.
One row for every day; I suppose that could be some form of "calendar" -
albeit a strange one. What will you do for Leap Year? Why do you need 11
extra fields?
> What data would be in the cell for Feb, 31?
Database tables have fields, not cells. A database is not a spreadsheet.
There is no Feb 31.
> There would be data only in the cells for that given column.
That sentence is untranslatable.
> row1 would be Jan 1, column 1.
> row1 coluimns 2 through 12 would be blank.
What would you want to place in 11 extra *fields* for each day?
> According to you, I would need 12 tables.
Nothing of the sort, just another untranslatable statement. It enforces
the fact that you know absolutely nothing about database design,
especially _relational_ database design. You continue to reinforce Denis's
statement of your "comprehension of computer systems which appears to have
started at nothing and continues to devolve backwards."
While you're reading about Third Normal Form, also study Primary Keys and
Foreign Keys.
--
-bts
-This space for rent, but the price is high
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]