I'm really a Database design greenhorn. I only do it because we have no one on staff who can do it and the database will be the backend for a application I am writing. The target database is Oracle 9. I've attached a jpg of the ERD. I would appreciate any pointers, suggestions or corrections.

Thanks,
-Mark

is document_id unique? if so, i would not use a compound primary key in the document table, nor a compouind foreign key in the nasageneral table

Yes, it is unique. Thanks. The idea is to be able to support any future additional document types in addition to the type represented by the nasageneral table. The database is basically a listing of documents (of a specific type) that have or will be imported into another system. I've updated the model and attached the changes.

Thanks,
-Mark