Hail to the Victors: Project Questions... asks some project questions.
More specifically, we have two tables, story and subheadline, that have the same primary key. We separated out the subheadline table because we were afraid that there would be a lot of nulls. Therefore, wouldn't the primary key in the subheadline table be a foreign key referencing the story table?
Also, can you clarify what you mean by including the DROP commands in the contents of our project. Are you just looking for us to type out what the DROP scripts are for each table?
Not sure what the errors are in oracle for your first item. A quick fix would be simply not to go with the sub-entity. Alternatively, you could try doing the foreign key constraint first and then the primary key constraint. Listing the exact code that is giving you a problem could help.
As for the drop stuff. I need a file that will drop all your tables and views by running it from within Oracle.