Sample Database Diagrams

The database diagrams in this section might give you ideas for designing your own database. These databases aren't included with Visual FoxPro; they're included here as examples of the types of databases and tables you can create.

Appointments Database

This database structure stores appointments for a professional office, and could easily be modified for use in an office of doctors, dentists, lawyers, or accountants. The Appointments table has a multiple-field primary key to uniquely identify each appointment. This primary key, the "client_sta" index, is created by indexing on an expression that combines the client_id and date_start time fields.

Example of an appointments database

Personnel Database

This database structure stores human resources information. The Job History table stores information on each hire or promotion, so it can contain many records for each employee.

Example of a personnel database

Library Database

This database stores information about library books and loans to patrons. Notice the many-to-many relationships between the Books and Authors tables and between the Books and Subjects tables.

Example of a library database

See Also

Refinement of the Design | Identification of Relationships | Determination of the Fields You Need | Organization of Requirements into Tables | Analysis of Data Requirements | Designing Databases