VAX Rdb/VMS Guide to Database Design and Definition

This manual, published in December 1985, serves as a tutorial for designing and defining databases using the VAX Rdb/VMS relational database management system (Version 2.0 for VMS and MicroVMS operating systems). It guides users through the process of developing a logical database model compatible with the relational data model and subsequently translating this model into a physical database using VAX Rdb/VMS data definition statements.

Key areas covered include:

• Data Organization: Principles of database management, the relational database model, and the steps to design a logical database, including identifying functions, objects, data items, normalizing data (eliminating repeating fields, identifying primary and foreign keys), and defining relations and fields.
• Database Creation: Practical instructions on how to create a physical database, including naming database files, specifying database size, defining fields with global and local attributes (data types, validation, missing values), establishing relations, defining constraints, creating indexes, and defining views (virtual relations) to simplify queries and enhance security.
• Database Protection: A comprehensive guide to implementing database security using Access Control Lists (ACLs), detailing how to create and manage ACL entries, assign user identifiers and access rights (read, write, modify, erase, define, change, delete, control, operator, administrator) for databases and relations, and order these entries for effective protection.
• Database Restructuring: Methods for dynamically changing or deleting existing database elements such as relations and fields, emphasizing how to use CHANGE and DELETE statements without major disruptions.

The document is designed to help users ensure data integrity, optimize storage efficiency, and control access within their Rdb/VMS databases.