421 reputation
26
bio website damirsystems.com/?page_id=5
location Toronto, Canada
age 53
visits member for 1 year, 10 months
seen 2 days ago

Apr
17
revised Advanced design question related to compound primary keys
added 11 characters in body
Apr
17
revised Advanced design question related to compound primary keys
added 7 characters in body
Apr
17
answered Advanced design question related to compound primary keys
Apr
7
comment Does redundancy exists in this table?
@Jose_Sunstrider; well still flawed; left a comment on the article there.
Apr
6
comment Does redundancy exists in this table?
Where did you find that definition? It is flawed -- think UserID appearing in multiple tables.
Oct
31
comment If all variables are a subset of the candidate key, is the database design 5NF?
@Lukazoid -- study that link before providing data and rules. That example contains a table and dataset that can be considered BCNF or 6NF just by stating a business rule -- same table same data.
Oct
31
revised If all variables are a subset of the candidate key, is the database design 5NF?
added 25 characters in body
Oct
31
answered If all variables are a subset of the candidate key, is the database design 5NF?
Oct
9
comment Two possibilities of primary key
@RafaelBarros; here on DBA.SE site.
Oct
9
answered Two possibilities of primary key
Oct
9
comment Two possibilities of primary key
Your question is really confusing. Are you saying that there are two types of users? If so, which columns are common and which are specific to each type? Or, do both types have id_1 and id_2?
Oct
9
comment Database design question
Many gigabytes? So, if you buy a 1TB blade it all fits into memory? Why would you prefer distributed file system over in-memory DB?
Jun
24
awarded  Yearling
May
21
awarded  Caucus
May
21
awarded  Constituent
May
7
revised How to design this database to avoid cyclic dependency?
exactly one
May
7
answered How to design this database to avoid cyclic dependency?
Mar
15
comment What alternatives exist when a table requires too many foreign keys?
Could you provide schema example for say 5 of these tables ...
Mar
15
revised Enforce data integrity with a recursive table
edited body
Mar
15
answered Enforce data integrity with a recursive table