Databases Reference
In-Depth Information
The following objects can be created in the application schema:
• Tables
• Primary keys
• Unique constraints
• Foreign keys
• Indexes on the foreign keys
• Other indexes
• Sequences
• Scripts for insert and update triggers on the tables to generate an ID
• Other objects (packages, materialized views, and so on)
Other tools
Beside the tools for creating a model, we need some tools during the further
development process, tools for accessing the database easily, and tools for web
development. Without going into detail, we will just name a few tools that you
can use.
Examples of database tools are:
• Toad
• SQL Developer
• PL/SQL Developer
Tools for web development, HTML, CSS, and JavaScript are as follows:
• Aptana
• Firebug
• Web Developer
• Internet Explorer Developer Tools
• Built-in tools in the browser
Miscellaneous tools:
• Versioning tools
• Performance measurement tools
• GUI design tools
Refer to
Chapter 5
,
Debugging and Troubleshooting
for the details on other tools.
