Hail to the Victors

Blogonaut: Hail to the Victors: Project Questions...

Blogonaut: Hail to the Victors: Project Questions...

The error code that we receive is: ERROR at line 1:
ORA-02298: cannot validate (KBARTNIC.SYS_C0044228) - parent keys not found

This doesn't make sense because story_id is the primary key of both our story table and our subheadline table, but it won't allow us to execute the following command:

alter table subheadline add foreign key (story_id) references story;

Without a constraint here, we can enter in subheadlines for stories that don't exist.

Oh well, I suppose that we can just make it an attribute.

Project Questions...

In completing our database assignment this weekend, a few questions arose....

The first question is regarding conditional dependencies. Since they share the same primary key, would the primary key of the dependent table be considered a foreign key linking back to the primary key of the other table? Oracle errors when you attempt to do this and will not allow you to specify this relationship. It seems like there needs to be an integrity constraint between tables that are conditionally dependent.

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?

Test II

This is a test post.