What is RDB (Requirements Database)? - WIP
RDB
is the abbreviation for requirements database. Requirements database stores the requirements information in structured relational format in Excel or tsv files.
This document is a work-in-process. I will work on it.
Here is an example data set for RDB:
den = tibble::tribble(
~data_entity_id, ~entity_name,
7L, "enum_value",
8L, "enum_var"
)
dfl = tibble::tribble(
~data_field_id, ~data_field_name, ~type, ~pk_fk, ~not_null, ~data_entity_id, ~fk_data_entity_id, ~enum_var_name,
26L, "enum_value_id", "INT", "PK", FALSE, 7L, NA, NA,
27L, "enum_var_id", "INT", "FK", TRUE, 7L, 8L, NA,
28L, "enum_value_name", "TEXT", "NON_KEY", FALSE, 7L, NA, NA,
29L, "enum_var_id", "INT", "PK", FALSE, 8L, NA, NA,
30L, "enum_var_name", "TEXT", "NON_KEY", FALSE, 8L, NA, NA
)
This data set stores metadata for two entities (tables): enum_value
and enum_var
This meta data actually describes attributes of these two entities. The UML diagram of these entities are as here:
Having meta data of entities defined as structured data helps me to automate several development and management related tasks. For example, I can generate DDL statements of the database tables and sample data for these tables automatically from RDB.