tailieunhanh - Oracle Unleashed- P13

Oracle Unleashed- P13: When I first started using Oracle many years ago, it was possible to know the database and the tools available. With the rash of recent releases of different options for the database and the spate of new tools, only people who wear their underpants over their trousers will be able to know everything there is to know about the Oracle products. | item in the primary key. Hold down the Ctrl key and select any other items in the key. Click the Primary Key refer to Figure . Saving the Diagram To save the diagram click the Save icon refer to Figure . You can name your diagram anything you like it probably makes sense to name it something related to the top menu level. It is important to save often. The Oracle client server tools use a large amount of memory and can sometimes cause a general protection fault on the PC. Saving often decreases the risk of losing any unsaved work. Multiple Diagrams Often you could have multiple diagrams for one application in Designer 2000. For example a business might have an accounting department and a payroll department. Both departments could have separate diagrams and a third diagram might depict all the departments in the business. Consolidating You can make changes to a table or its foreign keys in either the Data Diagrammer or RON. The changes are not reflected on other diagrams that use the same tables. The user might have a reason to keep the changes off for example to reflect an earlier point in time or the business opinions of another department. It is possible to take into account the changes from other users and consolidate them into the current diagram. To do so choose Edit Consolidate from the menu bar. At this point you can choose whether to consolidate a specific table foreign key or the entire diagram. . If you do not consolidate an element that has changed you cannot edit it. If foreign keys have been added to tables that are on your diagram you can add them to your diagram by choosing Edit Include Relationship. All the relationships missing from your diagram appear on a list and you can select the ones you want to add to your diagram. Making a Diagram Easier to Follow There are several ways you can make the diagram easier for the customer to follow. You can change the layout to make the table layout easier to follow and you can change the .