For educational use only, I have prepared an installation guide of MySQL 5.6.20 Community Server tested on Windows XP (32-Bit), Windows 7 (32-Bit), Windows 8 (64-Bit), Ubuntu 14.04 (64-Bit) and Mac OS 10.9.4 (64.bit)
SQL Developer – Connections tab not visible
1) Do make sure that you have downloaded the version that includes the jre
2) Do make sure that you have the right version, there is a 64-bit version if you have a 64-bit system.
3) Do make sure that SetJavaHome has been properly set to the Java location on your system, the option is found in the SQL Developer configuration file \sqldeveloper\bin\sqldeveloper.conf (http://forums.oracle.com/forums/thread.jspa?threadID=1049872)
If when attempting to connect you are getting a Locale not recognized error, make sure that your regional settings are set to English, Control Panel->Regional and Language Options, you also need to add the following to the sqldeveloper.conf file: AddVMOption -Duser.Xlanguage=en
Access Denied error when starting Oracle Database
If you are getting an Access Denied error when starting the Oracle XE server you need to right-click on the “Start Dabatase” option and select “Run as administrator”.
It is know that some errors are particular to Windows Vista, if you still cannot get either Oracle XE or Oracle SQL Developer to work you might want to try to install a Virtual Machine, install an OS of your choice (recommended Windows XP) and install Oracle XE then Oracle SQL Developer.
Recently I participated in a discussion of a common problem in data modelling. The question is whether to represent parties (groups) as roles or as subtypes (generalisation hierarchy).
When designing the Conceptual Data Model, parties can be represented as subtypes provided there is a common context amongst sub-types. In the Logical Model, subtypes should be represented only if each subtype has a unique concept that the others don’t.