A Data Model Validation Approach for Relational Database Design Courses
InSITE 2004
• Volume 4
• 2004
This paper presents an instructional method for validating a relational database design. Data model validation is often overlooked in course projects involving relational database design, in part because while most database texts stress the importance of validation, few provide an instructional method for performing validation. Validation is a critical step, especially for students. A flawed data model may omit non-key attributes or even the foreign keys required to join tables. This can make the design of SQL queries, forms, and reports a frustrating experience. This approach requires the designer to determine which attributes account for the field values on forms and reports, which entities are associated with those attributes, and how those entities are linked to an integral or primary entity. Such an approach serves to validate the completeness of the data model.
data model validation, instructional method, database, relational database, validation, verification.
137 total downloads


Back