Data model and relational database design for the New Jersey Water-Transfer Data System (NJWaTr)

With the extensive use of relational databases in the business environment there is a need to reduce database complexity in order to avoid data inconsistency and redundancy, which can provide a company with unreliable and/or meaningless data and information. The use of the REA Data Model in database design can significantly help with this problem. The model can eliminate the need for unnecessary data artifacts which should only be generated by the system when needed. This paper also addresses the need for a Relational Database Complexity Metric. A simple and easy to understand metric is presented.

Download Full-text

A Data Model Validation Approach for Relational Database Design Courses

10.28945/2797 ◽

2004 ◽

Author(s):

Kevin R. Parker

Keyword(s):

Model Validation ◽

Relational Database ◽

Data Model ◽

Database Design ◽

Instructional Method ◽

Design Data ◽

Critical Step

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.

Download Full-text

Formalized Approach in Relational Database Design

Key Engineering Materials ◽

10.4028/www.scientific.net/kem.685.930 ◽

2016 ◽

Vol 685 ◽

pp. 930-933 ◽

Cited By ~ 1

Author(s):

Victoria V. Osipova ◽

Igor L. Chudinov ◽

Aysel S. Seidova

Keyword(s):

Relational Database ◽

Data Model ◽

Database Design ◽

Domain Model ◽

Relational Data ◽

Conceptual Information ◽

Suggested Approach ◽

Database Development ◽

Relational Data Model ◽

Information Domain

Design of the conceptual information domain model is a significant and complicated stage in database development that influences its quality and can be considered as a skill. The suggested approach is based on analysis of attribute domains and relationships between them and uses the relational data model to determine the availability and the type of relationships between model entities.

Download Full-text