21,524 reputation
53780
bio website in.another.dimension
location Athens, Greece
age 47
visits member for 3 years, 11 months
seen 50 mins ago

Interests: math, programming and games, not necessarily in that order.

Favourite numbers: Surreals


1h
reviewed Close Design Database for Wholesales
1h
reviewed Close How to get best mark for each Student
1h
reviewed Delete Design Database for Wholesales
1h
comment SQLite 3 Tree List Without CTE
If you ask the question at askubuntu.com , they will probably know a way to install the latest version of sqlite3. I've installed and used the latest Postgres in Debian which has similar policy.
7h
reviewed Close How to add External data source into MySQL?
7h
comment finding text in a string
+1 for the LIKE. I have yet to find a need to use regexes.
7h
comment Normal Form question
How far have you gone so far? Determining normal form is usually done by checking the definitions.
11h
revised Normalization to 2NF and 3NF
deleted 11 characters in body
11h
reviewed Edit Normalization to 2NF and 3NF
11h
revised Normalization to 2NF and 3NF
Improved the title
11h
comment Normalization to 2NF and 3NF
I've edited yopur answer, mainly the format. I agree on the results (2nf and 3nf) but I disagree that there is any choice in the original table. The only candidate key is AB. +1 none the less.
12h
revised Normalization to 2NF and 3NF
added 182 characters in body
12h
reviewed No Action Needed Do I need to reindex mysql table after bulk delete?
1d
reviewed Close Query in mysql is not solving
1d
revised Facing SQL Error 3403
deleted 1 character in body
1d
reviewed Leave Open Facing SQL Error 3403
1d
reviewed No Action Needed How to stop Firebird SuperClassic (run as application) in Win 7?
1d
reviewed No Action Needed How to change ibdata1 path in mysql?
1d
revised Moving data from table with VARCHAR(50) fields to table with numeric fields increases table size
added 18 characters in body
1d
comment Use join to aggregate data from various normalized tables
Use left join, not right join. First (left) join branches, then (left) join to all the tables, related to branches.