Relational databases can be implemented as an effective design tool during the Preliminary and Final Engineering phases of manufacturing system design projects. The use of a hierarchical relational database structure will be shown to enhance system development, handling detailed information about electrical, mechanical, chemical or other parameters of system components and their applications. Holding such information in a central database structure as it becomes available maximizes its accessibility and coordinates communication between disciplines involved in the project. This enables calculations to be automated, ensures data integrity, and minimizes redundant compilation and typing of data. The ability to interface with a computer aided design (CAD) package can increase the labor savings of such a database even further. Techniques will be shown for assessing a particular project's needs and developing an overall structure which can be customized to suit the details of an application, providing an effective design tool for quality and efficiency in the project.
- Relational Databases,
- Computer Aided Engineering
Available at: http://works.bepress.com/elizabeth_scheyder/5/