It's a basic process in normalisation (called "projection"): project detail to child tables. For the database work you describe yourself as doing, you need to study up on normalisation, eg from links like those at http://www.artfulsoftware.com/dbresources.html.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.