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?
Comments