Reputation
3,269
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
11 11
Newest
 Guru
Impact
~199k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
Apr
26
comment Oracle RAC First Node not accessible
@saeed.sh Try starting (not installing.. It should already be started). As other have note please clarify your installation and what you are experiencing.
Apr
26
answered Oracle RAC First Node not accessible
Apr
25
awarded  Guru
Apr
20
awarded  Good Answer
Apr
18
awarded  Enlightened
Apr
18
awarded  Nice Answer
Apr
18
answered If a person's name is Null then how would it break the database?
Apr
12
revised Is REINDEX dangerous?
Fix syntax
Mar
28
answered Why query plan changes by number of rows
Feb
14
awarded  Yearling
Jan
17
answered should I denormalize for user profiles?
Dec
23
answered Does an order by clause have a negative effect on performance?
Dec
12
revised why in explain in mysql row count is very high
added 123 characters in body
Dec
12
answered why in explain in mysql row count is very high
Nov
22
answered How to add foreign key with more than 1 field in SQL Power Architect
Nov
22
answered Does any SQL engine have navigation support in CHECK clauses?
Nov
6
answered Best data modeling approch to handle redundant foreign keys in relational model
Oct
2
comment Explaining 2NF vs 3NF with an example
@philipxy When we have multiple candidate keys, we choose one as primary for use in relationship This choice may change as more data becomes available. My use of non-prime should have been rather than non-primary, as at some point you need to pick one of multiple candidate key for use in relationships. Subject_name remains a candidate key in the subjects table and remains both prime and transitive in that table. A database implementation would likely include a unique key on subject_name.
Oct
2
revised Explaining 2NF vs 3NF with an example
Correct usage of prime vs primary.
Oct
2
revised Explaining 2NF vs 3NF with an example
deleted 8 characters in body