Database Reference
In-Depth Information
Figure 6-5.
Accessing an Oracle Database from Delphi via ODBC
6.5 Summary and Concluding Remarks
Here is a summary of what we have covered in this chapter:
•
The user interface for a database system should provide the end
users with a user friendly, controlled environment that gives
users all the privileges and functionalities that they need and
nothing more.
•
In planning the user interface, you must first decide what type of
interface will be provided. The interface may be command-based,
menu-driven, or GUI-based.
•
Next, you should design the user interface using established
principles of user interface design.
•
The final step is the development and implementation of the
user interface. Features that the user interface will provide will
influence the tools used in developing the user interface. For
instance, if the database is to be accessible from the WWW, then
the tools used must facilitate such capability.
So now you know how to design a database and a user interface for that database.
Later in the course, you will learn Structured Query Language (SQL), the universal
database language. In preparation for this, the next two chapters discuss the relational
algebra and relational calculus respectively — two subjects areas that will enhance your
appreciation of SQL.
