HP 3000 Manuals HP 3000 Manuals
Chapter 2 Logical Design An ALLBASE/SQL database is defined both logically and physically. Logically, an ALLBASE/SQL database is one or more tables or views with the same owner. This chapter will give guidelines on how to design the logical structure of a relational database and to use ALLBASE/SQL table, view, and index definition features to meet the needs of users and applications. The logical design process lets you create efficient databases so that your applications will perform smoothly and be easy to maintain and support. The process consists of several distinct steps: * Identifying the data for tables * Normalizing the data * Arranging data in tables * Designing views * Designing indexes * Designing hash structures * Designing integrity constraints * Defining security levels * Defining the DBEnvironment scope The following sections describe each of these steps using the sample DBEnvironment PartsDBE as an illustration.